Dec 28 2022 07:49 PM
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?
Dec 28 2022 09:18 PM
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-...
