Hi Peder and everyone
I have found that using Pivot tables adds a huge amount to the file
size. Each table you make increases the resultant file size, and I
think it depends on the complexity of the pivot table you do. There
is a work around on a very helpful site (exceltips) for excel that I
have included below, for others who may need it.
One draw back is that the workbook takes a lot longer to load in,
which, in my case is not worth it, so I will live with a now 60mb
file for the time being.
http://exceltips.vitalnews.com/Pages/
T0836_Reducing_File_Sizes_for_Workbooks_with_PivotTables.html
Many thanks to Peder for your advice with this
kind regards
chris
On 18/01/2006, at 9:02 PM, Peder Kristensen wrote:
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
-- 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
