Forum Discussion

svreriks's avatar
svreriks
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 in forward, 


Stijn

8 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    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's avatar
      svreriks
      Copper Contributor

      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's avatar
        Riny_van_Eekelen
        Platinum Contributor

        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 

    Do you have an older version of Excel? Waterfall charts were introduced in Excel 2016, so if you have Excel 2013 or earlier, Excel will have problems with them.

    • svreriks's avatar
      svreriks
      Copper Contributor

      HansVogelaar 

       

       

      Thank you for your answer. I work with Excel 2016, so it should work. I have no idea what could be the error, but it definitely has something to do with the waterfall diagram, as it keeps showing up, every time i do save a file with a waterfall diagram. 

       

      Any idea how this can be caused/ and preferably solved? 🙂

       

Resources