Opening Large Spreadsheets

dano1203 · Mar 28th, 2002, 05:19 AM

Some of the traders at our company create huge spreadsheets (40mb to 80mb)with links to other large spreadsheets and then have trouble opening them. Sometimes it can take up to 3-4 minutes for the sheet to open. Can you give me any insight on why this might be happening and how to avoid it in the future.

Anne Troy · Mar 28th, 2002, 05:52 AM

Some items that cause file bloating and their potential fix:

1. The *container* becomes corrupt. Copy all sheets to a new file, one by one if necessary.

2. Contents of cells are deleting, but formatting is still stored. See *Cannot shift...* at: http://www.thewordexpert.com/excel.h...monExcelIssues

3. They need to break the files up into several files.

4. They ought to be using Access instead.

George J · Mar 28th, 2002, 05:57 AM

I have found that the links between sheets and workbooks slow down the processing speed (I think this is referred to as bottlenecking).

One way around this continual waiting may be to open excel, go to options and switch Calculations to manual, open up all these spreadsheets you will be using and in theory you can then update the calculations by pressing F9. This may not work for you as the size of the workbooks may prohibit you from opening more than 1 at a time.

Mar 28th, 2002, 05:52 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Some items that cause file bloating and their potential fix: 1. The container becomes corrupt. Copy all sheets to a new file, one by one if necessary. 2. Contents of cells are deleting, but formatting is still stored. See Cannot shift... at: http://www.thewordexpert.com/excel.h...monExcelIssues 3. They need to break the files up into several files. 4. They ought to be using Access instead. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 05:19 AM	#1
dano1203 New Member Join Date: Mar 2002 Posts: 1	Some of the traders at our company create huge spreadsheets (40mb to 80mb)with links to other large spreadsheets and then have trouble opening them. Sometimes it can take up to 3-4 minutes for the sheet to open. Can you give me any insight on why this might be happening and how to avoid it in the future.

Mar 28th, 2002, 05:57 AM	#3
George J Board Regular Join Date: Feb 2002 Location: Edinburgh, Bonnie Scotland Posts: 820	I have found that the links between sheets and workbooks slow down the processing speed (I think this is referred to as bottlenecking). One way around this continual waiting may be to open excel, go to options and switch Calculations to manual, open up all these spreadsheets you will be using and in theory you can then update the calculations by pressing F9. This may not work for you as the size of the workbooks may prohibit you from opening more than 1 at a time.