ExcelBanter - Ho to get Pivot Tables collapsed by default in IE

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Ho to get Pivot Tables collapsed by default in IE (https://www.excelbanter.com/excel-discussion-misc-queries/216612-ho-get-pivot-tables-collapsed-default-ie.html)

KWalsh125

Ho to get Pivot Tables collapsed by default in IE

I have a Pivot Table created in Excel 2003 and saved as an HTML file. When
the file is opened in IE6 or 7 the default view is expanded. Im looking for
a way to change the Pivot Table view to collapse all when opened in IE.

Anyone have any ideas?

All times are GMT +1. The time now is 10:44 PM.