98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Saving Information
Excel Saving Information
Resolved · Low Priority · Version 7
Wed 29 May 2013, 09:14Delegate Narinder said...
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.
Wed 29 May 2013, 10:31Trainer Rodney said...
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
Wed 29 May 2013, 10:45Delegate Narinder said...
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
Wed 29 May 2013, 13:24Trainer Rodney said...
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
Wed 5 Jun 2013: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Conditional formatting for cells that return text , not picked up by Go to commandIf you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text. |
