question

clf-2271 avatar image
0 Votes"
clf-2271 asked emizhang-msft commented

Power pivot freeze when refreshing

I'm using Excel 2019, when refresh power pivot with external excel sheet data source being occupied by other user in local network, Excel gets freeze everytime. I used to use Access with linked excel files, when the excel file is being opend by other user, Access will open a copy and continue its job. Does there any possible for pp to do the job?

office-excel-itpro
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @clf-2271,
I have not heard back from you in a few days and wanted to check on the status of the problem. If you have any questions with the previous information I've provided, please don't hesitate to let me know. I am glad to be of assistance.

0 Votes 0 ·

1 Answer

emizhang-msft avatar image
0 Votes"
emizhang-msft answered

Hi @clf-2271,
Did you use 32-bit or 64-bit Excel?
As far as I know 32-bit Excel is limited to 2GB in Memory and Power Pivot relies on being able to keep all data in Memory.
If you're using 32-bit Excel, you can change to 64-bit Excel to improve Memory.
Then you can also refer to this article to check if it will help you:
https://powerpivotpro.com/2012/04/workarounds-for-canceled-due-to-memory-pressure/


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.