I have an Excel workbook, very large (70 Megas) and inside I have 3 databases, many of Pivot tables with Report Connetcions and a Dashboard. However, the file is being very slow to operate. It takes time to calculate, it's slow. What could I do so that everything goes blazing fast? (Get all data in Dashboard+Slicers working fast).
They're all done by formula (index+match,ifs, vlookps, pivot tables, pivot charts).
thanks for your opinion.
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
If it is slow to calculate, that is probably due to formulas. Without examples of those it will be hard to comment specifically, but most people use vlookup and index/match inefficiently. Sorting the data will help as will reusing a match value whenever possible. If your workbook is 70MB on disk and is an XML format, then it is actually far larger in memory when opened.
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks