Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Want to have Data in Data.xls and PivotTable in PT.xls
Hello,
Perhaps this is an easy question but I couldn't do this when I tried. I have a range or a Table filled with Data in Data.xls (Sheet1) I want to create one PivotTable in a new workbook DigitalDashboard.xls (Sheet1) that will always get it's data from Data.xls. Any ideas whether this can be done? When I tried it wouldn't let me. The idea is that DigitalDashboard.xls will always run (24x7) and behind the scenes I will be opening Data.xls, updating the data. Perhaps I have to close DigitalDashboard.xls before I can update Data.xls because it will be used by another process. Do you have any suggestions for this? Thanks in advance Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I group new pivottable data w/old data instead of 5/31/08 | Charts and Charting in Excel | |||
Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
Pivottable - use same source data, and group data differently | Excel Discussion (Misc queries) | |||
PivotTable data... | Excel Discussion (Misc queries) | |||
How do I add new data to a pivottable/chart? | Charts and Charting in Excel |