Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Reduce size file
An excel file suddenly grew from 5M to 16M when I pasted a link to a
pivottable. Is there any way to reduce this filesize? Thanks, caroline |
#2
|
|||
|
|||
Caroline
Per se. no. There is no way like Access to compact the data. It also depends on what you mean by link. It may help, if you are storing the data for quick refresh *with* the pivot table then try right clicking the table and selection 'Table Options'. You can then uncheck 'save data with table layout'...may help -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "tempêtje" wrote in message ... An excel file suddenly grew from 5M to 16M when I pasted a link to a pivottable. Is there any way to reduce this filesize? Thanks, caroline |
#3
|
|||
|
|||
Thanks Nick,
But I didn't phrase my question properly. In fact, I pasted many times following formula in different worksheets - referring to another workbook with a pivottable. =IF(ISERROR(GETPIVOTDATA("Bedrag";'[analytisch.xls]Pivottable costs'!$A$3;"Reference";CONCATENATE($A$4;".";$A88; ".";O$3)));0;GETPIVOTDATA("Bedrag";'[analytisch.xls]Pivottable costs'!$A$3;"Reference";CONCATENATE($A$4;".";$A88; ".";O$3))) I already closed, opened, closed several times, but cannot manage to reduce the size. Any idea? "Nick Hodge" wrote: Caroline Per se. no. There is no way like Access to compact the data. It also depends on what you mean by link. It may help, if you are storing the data for quick refresh *with* the pivot table then try right clicking the table and selection 'Table Options'. You can then uncheck 'save data with table layout'...may help -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "tempêtje" wrote in message ... An excel file suddenly grew from 5M to 16M when I pasted a link to a pivottable. Is there any way to reduce this filesize? Thanks, caroline |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Large Excel file size caused by a bug ? I really tried everything | Excel Discussion (Misc queries) | |||
How do I reduce the size of an exel file? | Excel Discussion (Misc queries) | |||
Deleted all images but file size still too big!! | Excel Discussion (Misc queries) | |||
Importing .txt data files increases .xls file size | Excel Discussion (Misc queries) | |||
WHY IS MY FILE SO BIG? How can I reduce the size of a file? I h. | Excel Discussion (Misc queries) |