sarsukanth
Board Regular
- Joined
- Jun 21, 2010
- Messages
- 56
Hi All,
We have a excel file which has pivot tables, those pivot tables are connected with database connections directly. so when we Refresh All all pivot tables are refreshing with latest data from Database directly.
Now we want to change the source of PivotTable from that Database connection to normal Excel range.
so is it possible, if yes could you please explain how.
Advance Thank you for your support.
Regards,
Raghu
We have a excel file which has pivot tables, those pivot tables are connected with database connections directly. so when we Refresh All all pivot tables are refreshing with latest data from Database directly.
Now we want to change the source of PivotTable from that Database connection to normal Excel range.
so is it possible, if yes could you please explain how.
Advance Thank you for your support.
Regards,
Raghu