Power Pivot can't work

Occasional Visitor

when I use Power Pivot, it prompt that file's capacity is insufficient (2G limit), how can i solve it? Can file's capacity be expanded?

1 Reply

Hi @frank02221229 

 

Delete any tables you don’t need, any rows or columns in the, try reimport the data.

https://support.microsoft.com/en-us/office/maximum-memory-or-file-size-exceeded-2b43e34d-bb20-49e1-b... 

 

Read this topic about Create a memory-efficient Data Model using Excel and the Power Pivot 

https://support.microsoft.com/en-us/office/create-a-memory-efficient-data-model-using-excel-and-the-...