February 11, 2016
What is occurring when a workbook shows "Preparing worksheet" in the status bar?
I have a workbook with several Power Query connections to MS Dynamics CRM spreadsheets. Three of the connections are loaded to the Power Pivot Data Model. The loaded tables are not large -- two with 3,000 records and one with 82 records.
I find that the workbook frequently freezes with the status bar showing a progressive Preparing Worksheet bar at the bottom, followed by auto-recalculating the worksheets. Some of this I understand when changes to the Data Model call for refreshing related tables in the workbook. However, it often goes into Preparing Worksheet mode simply by switching views back and forth from the workbook to the Data Mode. The challenge is that each time this brings work to a standstill until the process completes.
Short of putting the entire workbook into Manual Calculation mode, is there any way to minimize this activity? It's causing long delays while waiting for Excel to catch up.
Thanks for any suggestions.
Excel 2016 64 bit
July 16, 2010
This thread has an explanation for "Preparing Worksheet":
Which is backed up by a similar explanation on this thread:
Hope that helps.
Most Users Ever Online: 57
Currently Online: clark shao
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas