Hi All,
Newcomer here, so apologies if I miss anything out!
I am working with Excel 2013 64-bit at work.
I do the vast majority of the businesses forecasting using Excel and at the moment i am really struggling to get along with it.
Document:
Binary Worksheet - 25mb
About 50 sheets
Linked to 3 documents
Heavy use of pivots and vlookups
Main sheet approx 2 million cells (mix of raw data and lookups)
All lookups refer to data within this document and not another document
Problem
Constantly crashing
Takes 1-2mins to refresh large pivots
Format painter tool can take 1min to do just 10-20 cells
Undo takes at least 10seconds to undo just 1 cells raw data, can take 10mins to undo formatting.
Forever crashing and 'not responding'
I know its not a hardware problem. I am on a gig network, Xeon processor and SSD, we've even tried running it on out new server before it was implemented.
The problem is even worse when I have an off-site meeting and have to work with my laptop (nothing special), it's basically impossible!
How can I improve/fix this?
Appreciate any help you can give.
Bookmarks