Chris,

You may find that files are growing in size over time. This happens when you 'Save' the file. Each Save adds any changes you have made to the original file, hence it will grow over time. This is very noticeable in Powerpoint files were you may have added or modified images, etc. This applies to Excel and Word file as well. In these cases you can reduce the size by using 'Save As' as it will re-write the file from scratch. Give it go it may work in your case.

Cheers,
Peder

On 18/01/2006, at 7:22 PM, Chris Burton wrote:

Hi people

While doing some validation of a small data file in excel this arvo (original size about 200k) I now have a file over 30mb! I have 4 pages, two with about 400 records long containing text and numbers and out to ab in width. I have two other pages that I have done a few pivot tables.

Has anyone else had this problem, as I cant see how this little file has grown in size to 30 mb after a few saves. It this an inherent problem with excel (Excel X for Mac service release 1).

I have just done a small pivot table on another file and it jumped from 148k to 4.2mb!!

Im stumped here? Do I need to remove excel preferences?

Thanks for any suggestions

chris


-- The WA Macintosh User Group Mailing List --
Archives - <http://www.wamug.org.au/mailinglist/archives.shtml>
Guidelines - <http://www.wamug.org.au/mailinglist/guidelines.shtml>
Unsubscribe - <mailto:[EMAIL PROTECTED]>

WAMUG is powered by Stalker CommuniGatePro