Trouble saving large doc

[Fish55]

Hi,

I have been working with a sheet which over time has grown too large to continue to work with because it keeps crashing. I thought one thing I could do was to divide the information into two documents;

I though the two would be - 1- Back up data/Cost Summaries - 2 -Final Summaroes

Again over time this has grown too large so now I was looking into splitting it into three - 1 - Back up data - 2 - Cost Summaries - 3 - Final Summaries.

When doing this and testing it by updated back up data and then refreshing the cost summaries I found it does update then will not save with out crashing. I am not sure if its because its has to read from the two documents or if its because I do not have them both opening when saving..

Any advice is appreciated

Thanks

[vba_php]

have you seen this? (sorry, I don't generally post search results):

https://www.google.com/search?q=exce...file+too+large

furthermore, these might be relevant:

https://support.microsoft.com/en-us/...2-b58778fd68ef

https://support.microsoft.com/en-us/...8-7866206f3669

https://support.microsoft.com/en-us/...7-269d656771c3