Merging two excel files

C

Chuck W

Hi,

I have a file that crashed recently which had several worksheets with pivot
tables and other worksheets that had pivot charts based on these pivot
tables. When the file was restored by our tech support I did a lot of
additional work. I now realize that I want to "import" and old worksheet
named InfCont from the old workbook into tmy new workbook and delete the
existing InfCont worksheet. The old InfCont worksheet has pivot charts that
refer to pivot tables in a worksheet called PV IC. The PV IC is identifical
in both Excel files.



Is there a way to replace one worksheet with another and have the pivot
chart links point to the new PV IC worksheet?

Thanks,



Chuck
 

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

Consolidate Pivot Tables/Cache using Excel 2003 1
Embed the same Excel multiple times 0
making an excel table visible for external data on pivot table 1
How to base a pivot table on another pivot table? 3
Please help! Cannot open pivotTable source file.... 2
Single Filter to change all Pivot Tables in a Workbook 9
2nd Pivot Table on Worksheet Crahes Excel 1
Move some sheets to a new workbook, without macros, and withoutbreaking link btwn Pivot Tables and P 0

Top