Forum Discussion

Copper Contributor

Mar 23, 2021

Can't open files with waterfall diagram in excel. Every time a error message pops up.

Can't open files with waterfall diagram in excel. Every time a error message pops up. I tried it couple of time, as well in a clean file, but i hope i lose my graphs not again this time. Thanks ...

excel

Riny_van_Eekelen

Platinum Contributor

Mar 23, 2021

svreriks Not sure if I can help, but from the naming of your screenshot, I suspect that you are on a Mac. So am I, though on the most recent (beta) version for MS265. Any chance you can upload your file with the chart(s) in it?

svreriks
Copper Contributor
Mar 26, 2021
Riny_van_Eekelen

Hi Riny,

Thank you for your response. I am working on a windows computer. In the attachment i plugged in one diagram and a screenshot of the same diagram. As you can see (probably), there is an error popping up immediately after opening. Does the same happen for you if you create and save a waterfall diagram?

Kind regards, Stijn
- Riny_van_Eekelen
  Platinum Contributor
  Mar 26, 2021
  svreriks Your chart is linked to a folder "Werkmap/Taken voor Wouter/etc." so the chart comes up empty. Nothing I can do for you right now.
  - svreriks
    Copper Contributor
    Mar 26, 2021
    I found out the problem is with my excel. Thank you for your help!
- HansVogelaar
  MVP
  Mar 26, 2021
  svreriks
  
  I don't get an error when I open your workbook in Excel for Windows, but I do notice that the data source of the chart is an external workbook. Could that be the cause of the problem?