Narinder has attended:
Excel Advanced course
Word Advanced course
Excel Saving Information
I am having trouble saving information in particular cells in a spread sheet. When I try to save it appears as if the information is saved. When the spread sheet is referred back to the last entry to that cell has disappeared and the latest update is then lost. This appears to be affecting those cells that contain the most information.
Any information on how to prevent loosing inputted information would be greatly appreciated.
RE: Excel Saving Information
Hello Narinder,
Hope you enjoyed your Microsoft Excel Advanced course with Best STL.
Thank you for your question regarding saving information in Excel.
Whenever you save data in a file (updating) take a look at the Status bar at the bottom of the window and you will observe a progress bar showing that the file is being saved. If you don't see this progress bar then the data is not being saved. If this the case please refer the matter to your IT department who should be able to help with this.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
RE: Excel Saving Information
Hello Rodney,
Thank you for your message.
I can confirm that the status bar shows as saving whenever I opt to save the file. This does not resolve the issue of data not being saved.
Thanks
Narinder
RE: Excel Saving Information
Hello Narinder,
Does your workbook have any VBA code in it. Use the VBA Editor to check on each sheet and also on the Workbook itself. There may be some code that is preventing you from saving data.
I can't think of anything else since there are no settings in Excel to do what you are experiencing except possibly through VBA.
Have you spoken to your IT department about this? I would.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
