Forum

ROLLOVER CHART, com...
 
Notifications
Clear all

ROLLOVER CHART, comes with error message for UDF function

2 Posts
2 Users
0 Reactions
48 Views
(@nd09689)
Posts: 23
Trusted Member
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
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

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
Share: