Hello,
I have a VBA code that goes to a specific Folder, grabs data from an Excel file, and then puts (data) in another Excel file (template with VBA) file as "Raw Data" tab.
Then my VBA refreshes 30+ Pivots from that “Raw Data” tab.
Now “Raw Data” is stored together with 20+ Pivots in one Excel file.
Challenge:
Is there a way to keep my "Raw Data" in the external Excel file and simply refresh my Pivots by only "pointing"/linking that source?
Is this doable?
Thanks!
Michael
Hi Michael,
I just had a quick go.. and it seems to work.
In a new workbook, select DATA>From Other Sources>From Microsoft Query
choose excel files and select your raw data file and select options. Click all the appropriate types and close. You'll see a list of sheets, select the sheet with your data on and select all fields if necessary. You'll then be promted for the type of connection, Choose Pivot Table.
That should do it.
Pivot.xlsx
RawData.xlsx
Dave
Last edited by djm601; 03-10-2014 at 05:53 PM.
Put the data in one workbook with all the pivot tables linked to that workbook. Then use..
ActiveWorkbook.RefreshAll
Great tips.
Worked!
Thank you much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks