Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy charts and remove links to original source data
I've got a workbook with multiple worksheets. For every one worksheet with a
pivot table, there is a corresponding worksheet containing a chart relating to that data source. Via a macro, I'd like to be able to select all sheets containing '(Chart)' in the worksheet name and copy them out into another workbook. Would I do this by selecting each sheet and doing a 'move/copy' to a new workbook? Once the sheets are exported, is there an easy way to remove all links to the source data? The idea is to use the initial workbook to update the source data and charts on a monthly basis, then distribute the charts as a separate document. The recipients of such information (both internal and external contacts) should not be able to access the original source data. Many thanks in advance - my vb skills/knowledge is limited. Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to copy sheet with charts without link to original data | Charts and Charting in Excel | |||
Links doesnt work in the copy version of the original sheet | Excel Discussion (Misc queries) | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Copy tabs(sheets) from workbook without link to original source | Excel Discussion (Misc queries) | |||
Copy tabs(sheets) from workbook without link to original source | Links and Linking in Excel |