HOW DO I DELETE AN AUTOMATIC LINK which is no longer there?
I have copied a chart from one workbook to create a new workbook. Now it
always says this wkbk contains automatic links to information in another
workbook.
HOW DO I DELETE AN AUTOMATIC LINK which is no longer there?
I have copied a chart from one workbook to create a new workbook. Now it
always says this wkbk contains automatic links to information in another
workbook.
Grace -
You can unlink a chart from its source data. This web page describes
several ways:
http://peltiertech.com/Excel/ChartsH...ChartData.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Grace wrote:
> HOW DO I DELETE AN AUTOMATIC LINK which is no longer there?
> I have copied a chart from one workbook to create a new workbook. Now it
> always says this wkbk contains automatic links to information in another
> workbook.
I tried this but must be doing something wrong cause after I make the series
#'s it still asked to update when I copy the chart into a new workbook.
"Jon Peltier" wrote:
> Grace -
>
> You can unlink a chart from its source data. This web page describes
> several ways:
>
> http://peltiertech.com/Excel/ChartsH...ChartData.html
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> Grace wrote:
>
> > HOW DO I DELETE AN AUTOMATIC LINK which is no longer there?
> > I have copied a chart from one workbook to create a new workbook. Now it
> > always says this wkbk contains automatic links to information in another
> > workbook.
>
Do you have any text that's linked to a worksheet? Axis or chart title,
data label, textbox?
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Grace wrote:
> I tried this but must be doing something wrong cause after I make the series
> #'s it still asked to update when I copy the chart into a new workbook.
>
> "Jon Peltier" wrote:
>
>
>>Grace -
>>
>>You can unlink a chart from its source data. This web page describes
>>several ways:
>>
>> http://peltiertech.com/Excel/ChartsH...ChartData.html
>>
>>- Jon
>>-------
>>Jon Peltier, Microsoft Excel MVP
>>Peltier Technical Services
>>Tutorials and Custom Solutions
>>http://PeltierTech.com/
>>_______
>>
>>
>>Grace wrote:
>>
>>
>>>HOW DO I DELETE AN AUTOMATIC LINK which is no longer there?
>>>I have copied a chart from one workbook to create a new workbook. Now it
>>>always says this wkbk contains automatic links to information in another
>>>workbook.
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks