|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 10th 10, 07:15 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
how to copy sheet with charts without link to original data
I have a worksheet with ten charts on it. I need to copy the worksheet with
all its data and related charts to new sheets or files so I have a page for every day, with different data entered every day. But when I copy the worksheet with embedded charts and paste it into a new file, the charts pull their source data from the original worksheet, not the new one. The source data Value box is written as such, ='03-09-10'!$D$12 any ideas? 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Copy Sheet to new Sheet and clear cells on original sheets | Boiler-Todd | Excel Discussion (Misc queries) | 7 | September 23rd 09 10:02 PM |
| ???Replicate a sheet but chart still link to original sheet | Jaylin | Charts and Charting in Excel | 1 | October 9th 06 03:14 PM |
| How do I copy a worksheet without the link to the original workboo | Reliabengr | Excel Discussion (Misc queries) | 1 | August 31st 05 01:17 AM |
| Copy tabs(sheets) from workbook without link to original source | Rich Ulichny | Excel Discussion (Misc queries) | 3 | August 25th 05 02:11 AM |
| Copy tabs(sheets) from workbook without link to original source | Rich Ulichny | Links and Linking in Excel | 2 | August 9th 05 03:26 PM |
Threaded Mode