Removing Links

loudawg

New Member
Joined
Apr 21, 2002
Messages
4
Hi Everyone,

I've posted this question on some Excel newsgroups and websites and haven't had that much luck. So, this is my final shot before I totally give up. I have a excel spreadsheet with 7 small charts on it. They all link to a separate spreadsheet that has data on it. I want to place the spreadsheet with the 7 small charts on a server so my co-workers can access it. But, a message appears
asking if I want to update the links. Does anyone have any ideas on how to
get rid of these links?

I've tries this code from a excel website (http://www.geocities.com/jonpeltier/Excel/Charts/DelinkChartData.html) but keep on coming up with "run-time error '1004'. Unable to set the XValues property of the Series Class":

Sub DelinkChartFromData()
''' Thanks to Tushar Mehta
Dim mySeries As Series
Dim sChtName As String

''' Make sure a chart is selected
On Error Resume Next
sChtName = ActiveChart.Name
If Err.Number <> 0 Then
MsgBox "This functionality is available only for charts " _
& "or chart objects"
Exit Sub
End If
If TypeName(Selection) = "ChartObject" Then
ActiveSheet.ChartObjects(Selection.Name).Activate
End If
On Error GoTo 0

''' Loop through all series in active chart
For Each mySeries In ActiveChart.SeriesCollection
'''' Convert X and Y Values to arrays of values
mySeries.XValues = mySeries.XValues
mySeries.Values = mySeries.Values
Next mySeries
End Sub

If anyone has any idea on how to do this or any other suggestion, please let me know.
Thanks
Lou K
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
One: Tools, Options, Edit
then uncheck the "Ask to update automatic links" box

Two: Is there any reason why the spreadsheet with the data is not part of the spreadsheet with the charts?

If you don't want the users to view the actual data, you could hide the spreadsheet with Format, Sheet, Hide
 
Upvote 0
I wrote a neat little utility that will remove links. Let me know if you're interested and I'll send it to you
 
Upvote 0
If you sourced your charts from PivotTables that were in turn sourced from each of your 7 worksheets there wouldn't be a link problem.
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,218
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top