This seems symptomatic of a memory type issues and sometimes it hangs and goes into 'not responding' never to return at all I can also see that in the data model window itself is struggling to actually show the numbers / data I have in there and takes significantly longer than in 2013. I try to press escape to get out of this to no avail and have to wait for all of them to finish 'processing' When finally opening the Data Model window Excel lurches into a state of trying to refresh all of the queries I have set up. The PowerPivot window takes an eternity to load up The other disturbing things I noticed were the following: Refreshing all of these took about 10 minutes as they are pulling in quite large data filesįollowing the upgrade to 2016, I opened my workbook in Excel 2016 and ran the same procedure and it took 45 minutes Prior to this I had developed an application in Excel with several workbook (power) queries integrated within. Yesterday I upgraded from Office 2013 to 2016 via an Office 365 subscription at work
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |