Home

Error in Excel : All the charts are removed

%3CLINGO-SUB%20id%3D%22lingo-sub-481821%22%20slang%3D%22en-US%22%3EError%20in%20Excel%20%3A%20All%20the%20charts%20are%20removed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-481821%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20i%20open%20any%20excel%20file%20that%20contains%20charts%2C%20I%20am%20getting%20an%20error%20that%20there%20is%20problem%20found%20in%20the%20file%20and%20if%20i%20want%20to%20restore%20the%20file.%20If%20i%20say%20yes%2C%20it%20removes%20all%20my%20charts%20in%20the%20excel%20file.%20I%20could%20not%20add%20any%20new%20chart%20to%20the%20excel%20(also%20in%20complete%20new%20excel%20sheet).%3C%2FP%3E%3CP%3EI%20tried%20repairing%20it%20and%20I%20tried%20reinstalling%20it.%20that%20does%20not%20solve%20the%20problem.%20I%20did%20not%20had%20this%20issue%20before.%3C%2FP%3E%3CP%3EI%20have%20attached%20pictures%20regarding%20this%20Issue%3F%20How%20can%20i%20solve%20it%3F%3C%2FP%3E%3CP%3EI%20am%20using%20Excel%202016%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-481821%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharts%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharts%20%26amp%3B%20Visualizing%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-486236%22%20slang%3D%22en-US%22%3ERE%3A%20Error%20in%20Excel%20%3A%20All%20the%20charts%20are%20removed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-486236%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F326191%22%20target%3D%22_blank%22%3E%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F326191%22%20target%3D%22_blank%22%3E%40eecstuttgart%3C%2FA%3E%2C%20I%20am%20sorry%20that%20I%20could%20not%20find%20an%20answer.%20However%20I%20noticed%20this%20other%20post%20with%20a%20similar%20issue.%20Maybe%20you%20can%20help%20each%20other%20finding%20a%20solution.%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FExcel-doesn-t-create-graphs-not-even-reads-files-with-graphs%2Fm-p%2F482811%23M29685%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FExcel-doesn-t-create-graphs-not-even-reads-files-with-graphs%2Fm-p%2F482811%23M29685%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-487869%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20in%20Excel%20%3A%20All%20the%20charts%20are%20removed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-487869%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20the%20same%20problem%2C%20I've%20already%20tried%20fixing%20it%20with%20the%20instalation%20program%2C%20but%20it%20didn't%20work.%20If%20you%20manage%20to%20solve%20it%20I%20appreciate%20it%20if%20you%26nbsp%3B%20tell%20me%20how%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F326191%22%20target%3D%22_blank%22%3E%40eecstuttgart%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-497660%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20in%20Excel%20%3A%20All%20the%20charts%20are%20removed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-497660%22%20slang%3D%22en-US%22%3E%3CP%3EDear%26nbsp%3Becstuttgart%2C%3C%2FP%3E%3CP%3EI'm%20experiencing%20the%20same%20issue.%20I%20found%20this%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fit-it%2Farticle%2Fexcel-2016-non-pu%25C3%25B2-aprire-file-contenenti-grafici-o-inserire-nuovi-grafici-d01c197f-0269-4a0d-8b8e-569021730662%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fit-it%2Farticle%2Fexcel-2016-non-pu%25C3%25B2-aprire-file-contenenti-grafici-o-inserire-nuovi-grafici-d01c197f-0269-4a0d-8b8e-569021730662%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3CP%3EUnfortunately%20it%20didn't%20work%20in%20my%20computer.%20In%20case%20you%20will%20succed%20solving%20the%20issue%2C%20I%20would%20appreciate%20if%20you%20can%20give%20me%20a%20feedback.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-498146%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20in%20Excel%20%3A%20All%20the%20charts%20are%20removed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-498146%22%20slang%3D%22en-US%22%3EHi..%20I%20could%20not%20solve%20the%20problem.%20Hence%20i%20reset%20my%20computer%20itself%20completely.%3CBR%20%2F%3Eand%20then%20i%20installed%20office%20again.%3CBR%20%2F%3ENow%20everything%20works%20fine%20.%3C%2FLINGO-BODY%3E
eecstuttgart
New Contributor

When i open any excel file that contains charts, I am getting an error that there is problem found in the file and if i want to restore the file. If i say yes, it removes all my charts in the excel file. I could not add any new chart to the excel (also in complete new excel sheet).

I tried repairing it and I tried reinstalling it. that does not solve the problem. I did not had this issue before.

I have attached pictures regarding this Issue? How can i solve it?

I am using Excel 2016

Thanks in advance.

4 Replies
@eecstuttgart, I am sorry that I could not find an answer. However I noticed this other post with a similar issue. Maybe you can help each other finding a solution. https://techcommunity.microsoft.com/t5/Excel/Excel-doesn-t-create-graphs-not-even-reads-files-with-g...

I'm having the same problem, I've already tried fixing it with the instalation program, but it didn't work. If you manage to solve it I appreciate it if you  tell me how@eecstuttgart 

Dear ecstuttgart,

I'm experiencing the same issue. I found this: 

https://support.office.com/it-it/article/excel-2016-non-pu%C3%B2-aprire-file-contenenti-grafici-o-in...

Unfortunately it didn't work in my computer. In case you will succed solving the issue, I would appreciate if you can give me a feedback.

 

Best

Hi.. I could not solve the problem. Hence i reset my computer itself completely.
and then i installed office again.
Now everything works fine .
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies