Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change external data source for multiple worksheets
I need to change the external data source for pivots found on multiple
worksheets within the same workbook. Is there code that I could use to do this in one click of a button. Also, how do keep the number formatting for my pivots after I refresh them? I tried just going to table options and selecting "preserve formatting" and unselecting "autoformat table" but this doesn't maintain the number formatting inside the pivot. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some help in re-organising data from external source | Excel Worksheet Functions | |||
UNC for external data source | Excel Discussion (Misc queries) | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
linking to external dbf data source | Excel Discussion (Misc queries) | |||
inserting rows through external data source | Excel Discussion (Misc queries) |