Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to copy pivot table workbook to new workbook?
I have been given an invoice workbook with data and pivot table. I am to
copy this workbook on a monthly basis and update the month and any related invoices so that there is a separate workbook for each month. When I copy the entire workbook I find the month column on the pivot table doesn't include the new month's name. Also, there seems to be a link from one book to the next, how do I copy this book, add the new month's name and keep the link to the preceding book all at the same time? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table using different worksheets/same workbook | Charts and Charting in Excel | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
How to get pivot table Time field to appear correctly | Excel Worksheet Functions | |||
Pivot Table in a Shared Workbook | Excel Discussion (Misc queries) | |||
Pivot Table in separate workbook | Excel Discussion (Misc queries) |