Results 1 to 9 of 9

A formula in a cell could not be converted

Threaded View

  1. #1
    Registered User
    Join Date
    06-17-2011
    Location
    London, England
    MS-Off Ver
    Office 2003
    Posts
    5

    Unhappy A formula in a cell could not be converted

    I have started getting a message when I try to save a workbook after having amended a column in a working Workbook. Message is:-
    A formula in a cell (Name:[workbookname.xls]worksheetname!Totals) could not be converted because it contains a function that is not available in the file format to which you are saving.

    This occurs for each cell I have amended in a particular column.
    The original formula was:-
    =IF(ISERROR('Structure 2'!CnD);"";'Structure 2'!CnD)
    which worked fine.

    Amended formula is:-
    =IF(ISERROR('Structure 2'!CnD);"";HYPERLINK("http://www.mywebspace.co.uk/dartford/card 1.mht";'Structure 2'!CnD))
    CnD in the Structure worksheet is a valid Name for a column.

    Any assistance would be appreciated.
    Last edited by Scubie; 06-24-2011 at 10:02 AM. Reason: mispelt

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1