Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
RWN RWN is offline
external usenet poster
 
Posts: 104
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 71
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
salary adjustment due to inflation,,how to ?? driller Excel Worksheet Functions 1 May 10th 07 10:50 AM
Inflation Calculator Eric Excel Discussion (Misc queries) 13 April 26th 07 03:38 PM
Cumulated expenses with inflation. [email protected] Excel Worksheet Functions 4 December 6th 06 02:13 AM
Inflation Adjustment dimitmant Excel Discussion (Misc queries) 1 November 17th 05 10:06 AM
Inflation Craig Schef Excel Discussion (Misc queries) 3 March 17th 05 02:19 PM


All times are GMT +1. The time now is 10:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"