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.