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
Bookmarks