Want to have Data in Data.xls and PivotTable in PT.xls

M

Michael

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

File open and close, get some data 2
How can I create a Macro that can update a sheet? 2
Create macro to copy data on a scheduled basis 0
View Pivot Table Source data as a Data Table 6
Dynamic sheetname reference. 0
opening and referencing another workbook 2
How can I have a macro update the sheet? 1
Excel as a database 1

Top