Problem Saving PowerPivot document.

Question

The error message below is popping up.

How can I work out how to fix this problem?

============================

Error Message:

============================

Value does not fall within the expected range.

---

Error occurred while setting the Sandbox Table Count.

============================

Call Stack:

============================

at Microsoft.Office.Core.CustomXMLPartsClass.Add(String XML, Object SchemaCollection)

at Microsoft.Office.PowerPivot.ExcelAddIn.ExcelInterOpUtil.SetSerializedContentAction(String content, Workbook localWorkbook, String key)

at Microsoft.Office.PowerPivot.ExcelAddIn.AddIn.SetSandboxTableCount(Workbook wb)

---

at Microsoft.Office.PowerPivot.ExcelAddIn.AddIn.SetSandboxTableCount(Workbook wb)

at Microsoft.Office.PowerPivot.ExcelAddIn.AddIn.Application_WorkbookBeforeSave(Workbook Wb, Boolean SaveAsUI, Boolean& Cancel)

============================

Answer 1

I am not sure if the original poster has the issue resolved, but this exact same issue occurred for me today as well and it is not resolved. I would be happy to replicate if needed. I also tried to execute the suggested fix, but got the same outcome as the original poster as well.

Answer 2

Is this working for you now? Very odd that i got a problem ticket from someone else with the same exact error with powerpivot in excel on the same day you posted this. Person couldn't replicate the issue today when i spoke with him, so i'm assuming if you're magically working now as well, then something happened on the O365 side to break Power Pivot.

Cheers,

Mario

Answer 3

Hello,

Unfortunately, I don't have any further troubleshooting to offer.

Many knowledgeable users are active on the forum, and I hope someone else can offer further insight into your issue.

Thanks.

Ajibola.

Answer 4

Thanks for your reply, but as you can see from the attached picture "Type ThisWorkbook.CustomXMLParts(1). Delete and press Enter." doesn't work

Answer 5

Greetings! I am Ajibola, and I am eager to assist you with confidence and assertiveness. I guarantee to provide you with exceptional support.

This error may occur if you have a corrupted or incompatible CustomXMLParts file in your workbook. This file contains some metadata and settings for PowerPivot, such as the Sandbox Table Count. To fix this problem, you can try one of the following solutions:

• Delete the CustomXMLParts file from your workbook by following these steps:

• Open your workbook in Excel and press Alt+F11 to open the Visual Basic Editor.

• Press Ctrl+G to open the Immediate window.

• Type ThisWorkbook.CustomXMLParts(1). Delete and press Enter.

• Save and close your workbook.

• Repair your workbook by following these steps:

• Open Excel and go to File > Open.

• Browse to the location of your workbook and select it.

• Click the arrow next to the Open button and select Open and Repair.

• Choose Repair to recover as much data as possible

For further reference, you can also find similar issues and solutions in the link provided:

https://powerusers.microsoft.com/t5/Using-Flows/Error-value-does-not-fall-within-the-expected-range-when-giving/td-p/348324

If you have any further questions or need additional assistance, please feel free to ask. I'm here to help!

Give back to the Community. Help the next person with this issue by indicating if this reply solved your problem. Click Yes or No below.

Kind regards.

Ajibola.