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