Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    California
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error Message when Saving my spreadsheet (Excel 97)

    When I save my spreadsheet, I get the error messages below.

    The cell named "WORK_DAYS" contains the value of 252.
    The cells that reference "WORK_DAYS" contain the formula as follows:

    =ROUND(+$BS$5*VLOOKUP(+$D118,$BZ$5:$CB$16,2)/$BS$8,0)-ROUND(VLOOKUP($D118,$BZ$5:$CB$16,3)*$BS$11,0)

    where $BS$8 = $WORK_DAYS

    I'm saving the document as an Excel 97 spreadsheet. I searched for any field with error values and there were none. I turned on the Audit but still couldn't find any errors.


    Message 1:

    "A formula in a cell (Name:WORK_DAYS) could not be converted because it contains a function that is not available in the file format to which you are saving.
    If you continue the save, the formula and result will be saved, but the function itself will be converted to an error value."

    When I click "Yes" to the question "Do you want to see additional errors as they occur so you can fix them later?" I get the next message.


    Message 2:

    "Microsoft Excel cannot convert some of the cells. The total number of errors found is 1."


    Does anyone have a clue what the problem could be?
    Thanks,
    Caroline in lala-land

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Error Message when Saving my spreadsheet (Excel 97)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> ckaufman

    Are you trying to convert the workbook into some other version, say Lotus 123?

    These kind of errors are indicating that you are trying to convert=translate this workbook.

    Make sure that when you do a SaveAs that the Save As Type drop down says something like Microsoft Excel workbook.

    Other than that, please try and check to see that the workbook is not damaged, and repair any damage you may find.

    HTH

    Wassim <img src=/S/compute.gif border=0 alt=compute width=40 height=20>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    California
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error Message when Saving my spreadsheet (Excel 97)

    Thank you!!! That was the problem. I was inadvertently trying to save to another format (Excel 95).
    Thanks,
    Caroline in lala-land

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •