E
ExcelSuperUser
Is there something that I can do to the front end of the file w/o using vb
code?
code?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How can I shrink a file size w/ a pivot table and many formulas?
S
sephiroths816
I'm not sure if it will help you, but it definitely helped me. I found
a program that shrinks Excel file sizes. The reasoning they gave was
that for some reason while creating a sheet, it redundantly saves
formulas and data that you previously deleted or something. Anyhow, I
went from a 10mb file to a 3mb file. Then i shrunk it again to see if
it would shrink again. It went to 600k. I couldn't shrink it anymore
then that. I don't quite remember the name of the program, but if you
google "Excel file shrink" or something like that, you're bound to
find it or something similar.
a program that shrinks Excel file sizes. The reasoning they gave was
that for some reason while creating a sheet, it redundantly saves
formulas and data that you previously deleted or something. Anyhow, I
went from a 10mb file to a 3mb file. Then i shrunk it again to see if
it would shrink again. It went to 600k. I couldn't shrink it anymore
then that. I don't quite remember the name of the program, but if you
google "Excel file shrink" or something like that, you're bound to
find it or something similar.
D
Dana DeLouis
One option in versions prior to 2007 is to select your pivot table and look
at the options. I can't remember the exact name, but uncheck the default
option to save the data with the Pivot table. The idea being that you don't
want to keep a large amoutn of duplicate data. However, select "refresh on
open."
I can't find that exact option in Excel 2007. I believe you unselect the
option "save source data with file." I have a hard time with Pivot tables
now. My productivity has gone down the toilet since using Excel 2007.
at the options. I can't remember the exact name, but uncheck the default
option to save the data with the Pivot table. The idea being that you don't
want to keep a large amoutn of duplicate data. However, select "refresh on
open."
I can't find that exact option in Excel 2007. I believe you unselect the
option "save source data with file." I have a hard time with Pivot tables
now. My productivity has gone down the toilet since using Excel 2007.
R
Roger Govier
Hi Dana
Click on a cell in the PT.
Above the ribbon, will appear a tab Pivot Table Tools>Options>far left
group>Pivot Table options>Data
I find PT's in XL2007 to be far easier and quicker to use, as well as
more powerful.
Click on a cell in the PT.
Above the ribbon, will appear a tab Pivot Table Tools>Options>far left
group>Pivot Table options>Data
I find PT's in XL2007 to be far easier and quicker to use, as well as
more powerful.