Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel file inflation
I am developing a system of 14 linked spreadsheets designed to be used
from a server over a network. Data is entered into 13 of the spreadsheets over the network. The remaining spreadsheet is _massively_ linked to the other spreadsheets and containing no data itself, does not need to be updated - but the results and graphs it contains are viewed. The spreadsheet (~256kB size) is under occasional development and so gets modified and saved back to the network from time to time. Unfortunately the file seems to grow by about 256kB every time it is resaved. At one point it got up to 9MB in size and was taking longer and longer to download and start. The spreadsheet file can be slimmed down by 'copy & pasting' whole worksheets within the workbook and this somehow causes the spreadsheet to shrink back to its proper size. Is there any way of avoiding this 'file-inflation' without resorting to such manual intervention? The system was originally developed in Win95+Office97-Excel (with a handful of VBA routines) but has been moved to Server+Win2000- workstation+Office2000-Excel for operational use. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel file inflation
Try a "Google" search using "Excel bloat"
-- Regards; Rob ------------------------------------------------------------------------ "Grinch" wrote in message .uk... I am developing a system of 14 linked spreadsheets designed to be used from a server over a network. Data is entered into 13 of the spreadsheets over the network. The remaining spreadsheet is _massively_ linked to the other spreadsheets and containing no data itself, does not need to be updated - but the results and graphs it contains are viewed. The spreadsheet (~256kB size) is under occasional development and so gets modified and saved back to the network from time to time. Unfortunately the file seems to grow by about 256kB every time it is resaved. At one point it got up to 9MB in size and was taking longer and longer to download and start. The spreadsheet file can be slimmed down by 'copy & pasting' whole worksheets within the workbook and this somehow causes the spreadsheet to shrink back to its proper size. Is there any way of avoiding this 'file-inflation' without resorting to such manual intervention? The system was originally developed in Win95+Office97-Excel (with a handful of VBA routines) but has been moved to Server+Win2000- workstation+Office2000-Excel for operational use. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel file inflation
Hi Grinch!
Possibly a used range problem. See: Debra Dalgleish: http://contextures.com/xlfaqApp.html#Unused -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel file inflation
Excel VBA Code Cleaner by Rob Bovey
Not sure this will help as it is usually recommended for code bloated workbooks, but worth a look. http://www.appspro.com/utilities/utilities.asp Bob "Grinch" wrote in message .uk... I am developing a system of 14 linked spreadsheets designed to be used from a server over a network. Data is entered into 13 of the spreadsheets over the network. The remaining spreadsheet is _massively_ linked to the other spreadsheets and containing no data itself, does not need to be updated - but the results and graphs it contains are viewed. The spreadsheet (~256kB size) is under occasional development and so gets modified and saved back to the network from time to time. Unfortunately the file seems to grow by about 256kB every time it is resaved. At one point it got up to 9MB in size and was taking longer and longer to download and start. The spreadsheet file can be slimmed down by 'copy & pasting' whole worksheets within the workbook and this somehow causes the spreadsheet to shrink back to its proper size. Is there any way of avoiding this 'file-inflation' without resorting to such manual intervention? The system was originally developed in Win95+Office97-Excel (with a handful of VBA routines) but has been moved to Server+Win2000- workstation+Office2000-Excel for operational use. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
salary adjustment due to inflation,,how to ?? | Excel Worksheet Functions | |||
Inflation Calculator | Excel Discussion (Misc queries) | |||
Cumulated expenses with inflation. | Excel Worksheet Functions | |||
Inflation Adjustment | Excel Discussion (Misc queries) | |||
Inflation | Excel Discussion (Misc queries) |