LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 947
Default reduce the size of a file

Currently, my file is slightly over 3 mb ...

Just an idea. Are you using Pivot Tables?
The default setting is to save this duplicate data.
Try Pivot Table - Options
and uncheck "Save data with table layout."
Then check "Refresh on open."
Again, just an idea if it applies.

--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"Jason M" wrote in message
...
Are there things that I can do to reduce the size of my excel file?
Currently, my file is slightly over 3 mb and contains over 25 sheets. I
streamlined my formulas, eliminated duplicate references, removed
graphics,
etc in an effort to get the file size down. Users with older, slower PCs
are
getting delays when opening the file. Any help would be greatly
appreciated!!

Jason



 
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
How reduce the file size of Excel 2007 files (wasted non value spa jclemen1 Excel Discussion (Misc queries) 1 October 11th 06 06:01 PM
reduce size of pivot table file zapadias Excel Discussion (Misc queries) 0 May 19th 06 09:57 AM
How to Reduce Spreadsheet Size and Speed ExcelMonkey Excel Worksheet Functions 4 August 9th 05 06:38 PM
File size too big after converting Lotus 1-2-3 to Excel Learner Excel Discussion (Misc queries) 3 June 10th 05 08:27 PM
Large Excel file size caused by a bug ? I really tried everything Anik Excel Discussion (Misc queries) 5 March 16th 05 06:19 PM


All times are GMT +1. The time now is 07:55 AM.

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

About Us

"It's about Microsoft Excel"