A formula in a cell could not be converted

[Scubie]

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.

[MarvinP]

Hi Scubie and welcome to the forum.

In your Hyperlink path you have a .mht, did you mean. .htm?

I'm wondering if excel doesn't know how to open a .mht file and is giving you the error because of that?

[Scubie]

Hi Scubie and welcome to the forum.

In your Hyperlink path you have a .mht, did you mean. .htm?

I'm wondering if excel doesn't know how to open a .mht file and is giving you the error because of that?

Thanks Marvin, but it actually activates the .mht file which is a Single File Web Page.
I just can't Save the Workbook without getting the error.
Regards
T
confused:

[MarvinP]

Hi Scubie,

I guess I can't help much with this one without trying to reproduce it. I wonder what would happen if you were using 2007 excel. Would you get the same error message? Is it a 2003 vs 2007 problem?

[Scubie]

Hi Scubie,

I guess I can't help much with this one without trying to reproduce it. I wonder what would happen if you were using 2007 excel. Would you get the same error message? Is it a 2003 vs 2007 problem?

Hi Marvin
I am using 2003 as don't have 2007,

I am only a poor Pensioner

If you have time you can go to the URL below, and download Test.xls to view the code.
http://www.firstlovemusic.co.uk/club/
Regards
Terry

[MarvinP]

Hi Terry,

What browser are you using on the machine that has the problem? I'm reading the .mht file that is on your link above and it claims:

This document is a Single File Web Page, also known as a Web Archive file. If you are seeing this message, your browser or editor doesn't support Web Archive files. Please download a browser that supports Web Archive, such as Microsoft Internet Explorer.

Another possibility is to fool Excel into thinking you have already saved the .mht (or xls) file so you don't get the message:
Try these lines of VBA to do this.

Application.ActiveWorkbook.Saved = True 
Application.ActiveWorkbook.Close

[Scubie]

HI Marvin,
I am using IE8 and don't have the problem you mentioned.
I think I will leave this problem for a while, although I have noticed in the Forum that others have had the same problem but with different coding and have not found an answer.
Thanks again
Terry

[Scubie]

Hi Terry,

What browser are you using on the machine that has the problem? I'm reading the .mht file that is on your link above and it claims:

Hi Marvin
I have solved the problem.
In case you come across it again:-
It would appear that my defined Names were in a mess due to my having copied a Worksheet from another Workbook. It was trying to use the other names, so I had to check and correct all my Names.

Regards
Terry

[MarvinP]

Hi Terry,

Thanks for the update. I wonder, too many times, why the problem and my answer seem to be in different worlds. I guess I assume things that aren't correct when giving some answers. It helps when you find the answer and report back. It gives me some confidence that I'm not going crazy.