Excel does not save my changes

Question

Hello, 

I am experiencing problem with my excel sheet. I try to add new column into my excel sheet and once I fill or copy anything into the column and save it. Then when I re-open the document, the column is gone and nothing is saved. 

When I try to re-fill it, it offers me what to write there, because it remembers my last input - however, the same happens when i save it and re-open the excel document. It is not there anymore. 

Thank you for your help.

Answer 1

Hi KaterinaJ!

I'm Jen, an independent advisor and a Microsoft user like you. I'd be happy to help you out with this issue.

Try to repair your office installation and see if it fixes the issue.

Open Microsoft Windows Settings.

Click Apps to open the Apps & features window.

Find and click your Microsoft Office 2016 application in the list.

Select Modify, then "Online Repair", and follow the onscreen instructions.

Once the fix is applied, restart your computer.

Then, re-try opening your excel workbook and check if the changes get saved.

If the above method doesn't work, kindly try the other solutions mentioned in this thread.

https://answers.microsoft.com/en-us/msoffice/fo...

I hope this information helps. If you have any questions, please let me know and I'd be glad to assist you further.

Thank you and Best Regards!

Jen :)

Answer 2

Dear Jen, 

Thank you so much!!! your guidelines helped me to fix my problem! :) 

Best regards, 

Katerina Jandikova

Answer 3

Dear Jen, 

Thank you for your response. 

I have tried it yesterday. However, I got stuck on the point that I am not the admin therefore, i could not go further than the online repair because it requires password from me. Currently, I am waiting for our IT guys to help me.

Thank you, 

Kate

Answer 4

Dear Stacy, 

Thank you for your reply. I have tried the suggested way of yours. However, when i open the window with the unsaved files it is empty. 

I found out, that I have only issues whenever I add there new column or new line -> then i save it. After re-opening, it does not show me the things i saved there. However, on the other hand, whenever, I already update the existing fields - those are saved even after i re-open it. 

Thank you for your help.

Kate