Notifications
Clear all
Excel Dashboards
2
Posts
2
Users
0
Reactions
48
Views
Topic starter
Hi Mynda
I recreated what you have shown in chapter 5 in the Excel Dashboards course on "Rollover chart"
However, I get an error message "cannot open the specified file"
I have saved my file .xlsm and have developer in the cutomized ribbon ticked as well.
Posted : 18/12/2019 12:56 am
Hi Junko,
I could not find anything wrong with what you did, that is an odd problem.
But to get it working I copied your function, renaming it of course, and then changed the HYPERLINK calls to the function and the chart data is now being update.
See attached.
regards
Phil
Posted : 18/12/2019 8:45 am