ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Preserve Formatting of pivot table crashing (https://www.excelbanter.com/excel-programming/310663-preserve-formatting-pivot-table-crashing.html)

grant

Preserve Formatting of pivot table crashing
 
Hi there,

how come when I use the following line:
pvtTable.PreserveFormatting = True
where pvtTable is predefined as being a PivotTables object

the whole spreadsheet crashes, but when I take it out it
works?

Any help would be greatfully appreciated.

Grant.


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com