Hi all
Using Excel 2007, I've created an interactive chart using picture links where a user can bring up any one of a range of charts by selecting which one they'd like to see from a combo box. The combo box relies on a CHOOSE formula to do this with each of the charts sitting within a named range on a different sheet.
The problem I have is that when I close and reopen the file, the pictures are blank. I can only refresh them if I go to the sheet and enter the range names to highlight each individual range. With 30 charts to look at, this is very time consuming and, frankly, my managing director will not do this each time he wants to use the interactive chart.
I found a bit of VB that is meant to refresh the links upon opening the file but I tried it and it didn't work. I'm not familiar with VB anyway so I'm not sure what the problem was. This is the whole script:
Sub Rectangle2_Click()
Sheets(“charts”).Select
Application.Goto Reference:=”CHART1″
Application.Goto Reference:=”CHART2″
Application.Goto Reference:=”CHART3″
Sheets(“OUTPUT”).Select
Sheets(“charts”).Select
ActiveWindow.SelectedSheets.Visible = False End Sub
Has anyone encountered a similar problem? If so, how did you overcome it?
Would appreciate any help anyone can give me.
Thanks!
Using Excel 2007, I've created an interactive chart using picture links where a user can bring up any one of a range of charts by selecting which one they'd like to see from a combo box. The combo box relies on a CHOOSE formula to do this with each of the charts sitting within a named range on a different sheet.
The problem I have is that when I close and reopen the file, the pictures are blank. I can only refresh them if I go to the sheet and enter the range names to highlight each individual range. With 30 charts to look at, this is very time consuming and, frankly, my managing director will not do this each time he wants to use the interactive chart.
I found a bit of VB that is meant to refresh the links upon opening the file but I tried it and it didn't work. I'm not familiar with VB anyway so I'm not sure what the problem was. This is the whole script:
Sub Rectangle2_Click()
Sheets(“charts”).Select
Application.Goto Reference:=”CHART1″
Application.Goto Reference:=”CHART2″
Application.Goto Reference:=”CHART3″
Sheets(“OUTPUT”).Select
Sheets(“charts”).Select
ActiveWindow.SelectedSheets.Visible = False End Sub
Has anyone encountered a similar problem? If so, how did you overcome it?
Would appreciate any help anyone can give me.
Thanks!