Interpretation of Error Message

  • Thread starter Fred_in_the_Wiregrass
  • Start date
F

Fred_in_the_Wiregrass

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

When I save a specific workbook that has some complex formulas in most of the worksheets, a warning screen pops up saying, "A FORMULA IN A CELL (NAME:Z_BE878050_08A5_49CE_80D1_A8130) COULD NOT BE CONVERTED BECAUSE IT CONTAINS A FUNCTION THAT IS NOT AVAILABLE IN THE FILE FORMAT TO WHICH YOU ARE SAVING. After pressing [enter], another warning screen pops up saying, "THE TOTAL NUMBER OF ERRORS FOUND IS 1. This workbook is an XLS format file. Under PREFERENCES, the file save extension is XLS.
Any help would be appreciated. It's driving me crazy!!!
Thanks up front.
 
B

Bob Greenblatt

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

When I save a specific workbook that has some complex formulas in most of the
worksheets, a warning screen pops up saying, "A FORMULA IN A CELL
(NAME:Z_BE878050_08A5_49CE_80D1_A8130) COULD NOT BE CONVERTED BECAUSE IT
CONTAINS A FUNCTION THAT IS NOT AVAILABLE IN THE FILE FORMAT TO WHICH YOU ARE
SAVING. After pressing [enter], another warning screen pops up saying, "THE
TOTAL NUMBER OF ERRORS FOUND IS 1. This workbook is an XLS format file. Under
PREFERENCES, the file save extension is XLS.
Any help would be appreciated. It's driving me crazy!!!
Thanks up front.
Did the file originate on a Windows machine? Can you paste the formula text
into a message here? Is that long name really a defined name for a cell?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top