Hoping someone can offer some advice...
I have an excel file that handles a huge amount of data via the Power Query Editor and puts it into a series of pivot tables. I use power query because there is too much information for one Excel data sheet to handle, so i have multiple excel sheets that Power Query merges together and carries out a series of lookups to pull it all together.
The file works fine when you first use it (apart from it taking quite a while to load after you select a pivot table filter for the first time - but that's usual with heavy pivot tables). Then after a while it freezes up the whole Excel program every so often as if its processing / loading something (spinning cursor icon). It does this same thing every so often at fairly regular intervals, often lasting a few minutes. Autosave is turned off so its not that getting in the way. It gets annoying because its useful to have the 'problematic' file open while I'm working on other excel sheets (for reference / data etc). While I'm working on another excel document or sharing screen with colleagues Excel is working fine and then it freezes up for a few minutes
I haven't ever had this problem before with a file. The file contains sensitive information so i cant share the file itself. Has anyone had a similar problem that you have managed to solve?
Many Thanks for the help
I have an excel file that handles a huge amount of data via the Power Query Editor and puts it into a series of pivot tables. I use power query because there is too much information for one Excel data sheet to handle, so i have multiple excel sheets that Power Query merges together and carries out a series of lookups to pull it all together.
The file works fine when you first use it (apart from it taking quite a while to load after you select a pivot table filter for the first time - but that's usual with heavy pivot tables). Then after a while it freezes up the whole Excel program every so often as if its processing / loading something (spinning cursor icon). It does this same thing every so often at fairly regular intervals, often lasting a few minutes. Autosave is turned off so its not that getting in the way. It gets annoying because its useful to have the 'problematic' file open while I'm working on other excel sheets (for reference / data etc). While I'm working on another excel document or sharing screen with colleagues Excel is working fine and then it freezes up for a few minutes
I haven't ever had this problem before with a file. The file contains sensitive information so i cant share the file itself. Has anyone had a similar problem that you have managed to solve?
Many Thanks for the help