Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

data loss excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Loss on Excel.

Data Loss on Excel.

ResolvedVersion 2003

Murtaza has attended:
No courses

Data Loss on Excel.

I got the error "file error:data may have been lost" while opening a file that i had saved in the excel 2003 format.
I had recently upgraded to Office 2007 but was saving this particular file in the oild version.
when i opened the file i noticed that all the cells with the date function eomonth were showing n/a.
What is the reason for this and is there a way to repair the file?
Is there a possibility of this happening with any other excel file i am currently saving in the old version instead of saving in 2007 format?

RE: Data Loss on Excel.

Hi Murtaza

Thank you for your question.

As we are not qualified technicians, we are not able to offer advise or technical assistance on how to repair files.

If you have any questions regarding the use of particular Excel features, we can provide answers to the best of our ability in relation to these.

Kind regards
Amanda

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.