excel saving information

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Saving Information

Excel Saving Information

resolvedResolved · Low Priority · Version 7

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

Wed 5 Jun 2013: Automatically marked as resolved.

 

Training courses

 

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
What does 'Resolved' mean?

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 command

If 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.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips


Server loaded in 0.12 secs.