You have one response at your other post.

Brady Snow wrote:

Thanks to all that participate in these NG. They are very
helpful.

When a user is saving a workbook in Excel 2000 with many
calculations and references, she is getting the following
error:

"A formula in a cell (name:year) could not be converted
because it contains a function that is not available in
the fileformat to which you are saving. She has been
using this workbook for years and just started seening
this error. When when clicks <OK it continues on and
says that she has x amout of error in workbook. Has
anybody out there had any experience with this error. And
what is cell (name:year)?

Regards-

Brady Snow
Mckinney, Texas

--

Dave Peterson

Thanks for the reply.

I posted it again in a more detail manner hoping to get a
better answer.. The response to the previous post:

"be sure that when you see the Save As Dialog, you have
the "Save as type:" set to the value of "Microsoft Excel
Workbook (*.xls)" in order that you save the file in the
most newer format for Excel Files. If you need to save it
in older formats, then you will lost some formatting or
functions information.

Is irrelevant These same workbooks have been used for
years using the same version and saving the same way.
Please read the post again and see if you have any other
suggestions.

Many thanks,

Brady Snow
Mckinney
-----Original Message-----
You have one response at your other post.

Brady Snow wrote:

Thanks to all that participate in these NG. They are
very
helpful.

When a user is saving a workbook in Excel 2000 with many
calculations and references, she is getting the
following
error:

"A formula in a cell (name:year) could not be converted
because it contains a function that is not available in
the fileformat to which you are saving. She has been
using this workbook for years and just started seening
this error. When when clicks <OK it continues on and
says that she has x amout of error in workbook. Has
anybody out there had any experience with this error.
And
what is cell (name:year)?

Regards-

Brady Snow
Mckinney, Texas

--

Dave Peterson

.

I just have guesses/questions.

Are there any range names in your workbook?

You may want to try Jan Karel Pieterse, Charles Williams and Matthew Henson's
utility called NameManager.Zip from http://www.bmsltd.co.uk/mvp.

To eliminate any chance that there's a problem with a workbook name.

Does that (name:year) look like it's part of your workbook or a part of a
standard error message. (I don't think I've seen anything like it.)

Can you play a little with a copy of the workbook?

Eliminate some worksheets and try saving. Maybe you can isolate the worksheet
with the problem. Once you do that, you could divide the worksheet in half and
clear that. If the error goes away, then keep that half and toss the other.
Keep eliminating the half that didn't cause the problem.

Is the workbook small? If it's small (or you can make it small and still get
the error) and you remove any proprietary info, you can send it to me. (no
promise that I can find anything though.)

What version of excel are you using?

And just to be more irritating, are you sure that the user really saved in the
current version of excel?

brady snow wrote:

Thanks for the reply.

I posted it again in a more detail manner hoping to get a
better answer.. The response to the previous post:

"be sure that when you see the Save As Dialog, you have
the "Save as type:" set to the value of "Microsoft Excel
Workbook (*.xls)" in order that you save the file in the
most newer format for Excel Files. If you need to save it
in older formats, then you will lost some formatting or
functions information.

Is irrelevant These same workbooks have been used for
years using the same version and saving the same way.
Please read the post again and see if you have any other
suggestions.

Many thanks,

Brady Snow
Mckinney
-----Original Message-----
You have one response at your other post.

Brady Snow wrote:

Thanks to all that participate in these NG. They are
very
helpful.

When a user is saving a workbook in Excel 2000 with many
calculations and references, she is getting the
following
error:

"A formula in a cell (name:year) could not be converted
because it contains a function that is not available in
the fileformat to which you are saving. She has been
using this workbook for years and just started seening
this error. When when clicks <OK it continues on and
says that she has x amout of error in workbook. Has
anybody out there had any experience with this error.
And
what is cell (name:year)?

Regards-

Brady Snow
Mckinney, Texas

--

Dave Peterson

.


--

Dave Peterson