2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Issues with charts in all files

I just opened a file, which prompted the pop-up message:
> We found a problem with some content in [file name]. Do you want us to try to recover as much as we can?

I clicked yes, and a new message popped up:
> Excel was able to open the file by repairing or removing the unreadable content.

It had deleted all charts (radar) in the file. When I then tried to insert new charts, nothing happened. When I click on “Recommended charts” while marking the data, I get the following error message:
> To create a chart, select the cells that contain the data you’d like to use. If you have names for the rows and columns and you’d like to use them as labels, include them in your selection.

The marked range is 3x6 with the first row and column being labels and the data being decimal numbers. No changes in the range solves the issue, and the only charts that it allows me to create are: treemap, histogram, waterfall, and funnel. Nothing happens when selecting any other chart.

It turns out the issue was not limited to this file. All files with charts are affected. All charts are deleted when trying to recover a file. This is very problematic, and I have absolutely no idea what has caused this. I can still open the files in the web browser without causing any harm (usually it’s the opposite since the app supports some functions the browser doesn’t), but I need to work in the app.

Does anyone have any idea what has caused this issue and how to resolve it?

submitted by /u/LilG55
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#interactive charts
#Excel alternatives for data analysis
#generative AI for data analysis
#financial modeling with spreadsheets
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#row zero
#charts
#Excel