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

%3CLINGO-SUB%20id%3D%22lingo-sub-2229414%22%20slang%3D%22en-US%22%3ECan't%20open%20files%20with%20waterfall%20diagram%20in%20excel.%20Every%20time%20a%20error%20message%20pops%20up.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2229414%22%20slang%3D%22en-US%22%3E%3CP%3ECan't%20open%20files%20with%20waterfall%20diagram%20in%20excel.%20Every%20time%20a%20error%20message%20pops%20up.%20I%20tried%20it%20couple%20of%20time%2C%20as%20well%20in%20a%20clean%20file%2C%20but%20i%20hope%20i%20lose%20my%20graphs%20not%20again%20this%20time.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20forward%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EStijn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2229414%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2229744%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20open%20files%20with%20waterfall%20diagram%20in%20excel.%20Every%20time%20a%20error%20message%20pops%20up.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2229744%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1005796%22%20target%3D%22_blank%22%3E%40svreriks%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20have%20an%20older%20version%20of%20Excel%3F%20Waterfall%20charts%20were%20introduced%20in%20Excel%202016%2C%20so%20if%20you%20have%20Excel%202013%20or%20earlier%2C%20Excel%20will%20have%20problems%20with%20them.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

@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.

@Hans Vogelaar 

 

 

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?

 

@svreriks 

I'm afraid I have neither an explanation nor a solution. Sorry!

@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?

 

@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 

@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?

@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.

 

I found out the problem is with my excel. Thank you for your help!