Mar 23 2021 03:17 AM
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
Mar 23 2021 06:40 AM
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.
Mar 23 2021 06:44 AM
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? :)
Mar 23 2021 06:53 AM
I'm afraid I have neither an explanation nor a solution. Sorry!
Mar 23 2021 10:00 AM
@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?
Mar 26 2021 01:50 AM - edited Mar 26 2021 03:03 AM
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
Mar 26 2021 02:58 AM
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?
Mar 26 2021 02:58 AM
@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.
Mar 26 2021 03:04 AM