Problem with formula in cell
 

I get the following message when I save a workbook:

A formula in a cell (Name:[Book1.xls]CO3POS!ResetSheet) could not be
converted because it contains a function that is not available in the file
format wo which you are saving.....

I have a macro in Module1 with the name ResetSheet but I do not have this
referenced in a cell on the CO3POS worksheet. How can I resolve this?

Problem with formula in cell
 

Why not save in the normal file format for the version of excel you are
using.

Look in Tools=Options=Transition tab and the first entry is where you
select the default format for saving.

Choose "Microsoft Excel Workbook" from the dropdown would be my
recommendation.

--
Regards,
Tom Ogilvy

"RW" wrote in message
...
I get the following message when I save a workbook:

A formula in a cell (Name:[Book1.xls]CO3POS!ResetSheet) could not be
converted because it contains a function that is not available in the file
format wo which you are saving.....

I have a macro in Module1 with the name ResetSheet but I do not have this
referenced in a cell on the CO3POS worksheet. How can I resolve this?

Problem with formula in cell
 

Microsoft Excel Workbook is already selected in the Transition tab.

I do not have a ResetSheet formula. It is a macro in module1. Why would
Excel think it's a formula in a cell?


"Tom Ogilvy" wrote:

Why not save in the normal file format for the version of excel you are
using.

Look in Tools=Options=Transition tab and the first entry is where you
select the default format for saving.

Choose "Microsoft Excel Workbook" from the dropdown would be my
recommendation.

--
Regards,
Tom Ogilvy

"RW" wrote in message
...
I get the following message when I save a workbook:

A formula in a cell (Name:[Book1.xls]CO3POS!ResetSheet) could not be
converted because it contains a function that is not available in the file
format wo which you are saving.....

I have a macro in Module1 with the name ResetSheet but I do not have this
referenced in a cell on the CO3POS worksheet. How can I resolve this?

Problem with formula in cell
 

If you take it out or comment it out (including the declaration), do you
still get the message?

--
Regards,
Tom Ogilvy

"RW" wrote in message
...
Microsoft Excel Workbook is already selected in the Transition tab.

I do not have a ResetSheet formula. It is a macro in module1. Why would
Excel think it's a formula in a cell?


"Tom Ogilvy" wrote:

Why not save in the normal file format for the version of excel you are
using.

Look in Tools=Options=Transition tab and the first entry is where you
select the default format for saving.

Choose "Microsoft Excel Workbook" from the dropdown would be my
recommendation.

--
Regards,
Tom Ogilvy

"RW" wrote in message
...
I get the following message when I save a workbook:

A formula in a cell (Name:[Book1.xls]CO3POS!ResetSheet) could not be
converted because it contains a function that is not available in the
file
format wo which you are saving.....

I have a macro in Module1 with the name ResetSheet but I do not have
this
referenced in a cell on the CO3POS worksheet. How can I resolve this?

Problem with formula in cell
 

I commented it out and I still get the message.

I also tried changing the name of the macro to ResetSheet2 and I still got
the message with the original name (ResetSheet)

This is very frustrating.


"Tom Ogilvy" wrote:

If you take it out or comment it out (including the declaration), do you
still get the message?

--
Regards,
Tom Ogilvy

"RW" wrote in message
...
Microsoft Excel Workbook is already selected in the Transition tab.

I do not have a ResetSheet formula. It is a macro in module1. Why would
Excel think it's a formula in a cell?


"Tom Ogilvy" wrote:

Why not save in the normal file format for the version of excel you are
using.

Look in Tools=Options=Transition tab and the first entry is where you
select the default format for saving.

Choose "Microsoft Excel Workbook" from the dropdown would be my
recommendation.

--
Regards,
Tom Ogilvy

"RW" wrote in message
...
I get the following message when I save a workbook:

A formula in a cell (Name:[Book1.xls]CO3POS!ResetSheet) could not be
converted because it contains a function that is not available in the
file
format wo which you are saving.....

I have a macro in Module1 with the name ResetSheet but I do not have
this
referenced in a cell on the CO3POS worksheet. How can I resolve this?

Problem with formula in cell
 

Sure you don't have a hidden sheet named ResetSheet. Maybe an Excel4 macro
sheet?

Try running code like

Sub ShowAllSheetsandNames()
Dim sh as Object, nm as Object
for each sh in ActiveWorkbook.Sheets
sh.Visible = xlsheetvisible
Next
for each nm in Activeworkbook.Names
nm.visible = True
Next
End Sub

look at all the sheets and go into Insert=Name=Define and examine all the
names. See if they have a strange function in them.

--
Regards,
Tom Ogilvy




"RW" wrote in message
...
I commented it out and I still get the message.

I also tried changing the name of the macro to ResetSheet2 and I still got
the message with the original name (ResetSheet)

This is very frustrating.


"Tom Ogilvy" wrote:

If you take it out or comment it out (including the declaration), do you
still get the message?

--
Regards,
Tom Ogilvy

"RW" wrote in message
...
Microsoft Excel Workbook is already selected in the Transition tab.

I do not have a ResetSheet formula. It is a macro in module1. Why
would
Excel think it's a formula in a cell?


"Tom Ogilvy" wrote:

Why not save in the normal file format for the version of excel you
are
using.

Look in Tools=Options=Transition tab and the first entry is where
you
select the default format for saving.

Choose "Microsoft Excel Workbook" from the dropdown would be my
recommendation.

--
Regards,
Tom Ogilvy

"RW" wrote in message
...
I get the following message when I save a workbook:

A formula in a cell (Name:[Book1.xls]CO3POS!ResetSheet) could not
be
converted because it contains a function that is not available in
the
file
format wo which you are saving.....

I have a macro in Module1 with the name ResetSheet but I do not
have
this
referenced in a cell on the CO3POS worksheet. How can I resolve
this?

Problem with formula in cell
 

Tom,

Thanks for providing the code to look for invisible sheets - none existed.

I also checked Insert=Name=Define on each sheet and did not see anything
named ResetSheet.


Is there anything else I can look for?

"Tom Ogilvy" wrote:

Sure you don't have a hidden sheet named ResetSheet. Maybe an Excel4 macro
sheet?

Try running code like

Sub ShowAllSheetsandNames()
Dim sh as Object, nm as Object
for each sh in ActiveWorkbook.Sheets
sh.Visible = xlsheetvisible
Next
for each nm in Activeworkbook.Names
nm.visible = True
Next
End Sub

look at all the sheets and go into Insert=Name=Define and examine all the
names. See if they have a strange function in them.

--
Regards,
Tom Ogilvy




"RW" wrote in message
...
I commented it out and I still get the message.

I also tried changing the name of the macro to ResetSheet2 and I still got
the message with the original name (ResetSheet)

This is very frustrating.


"Tom Ogilvy" wrote:

If you take it out or comment it out (including the declaration), do you
still get the message?

--
Regards,
Tom Ogilvy

"RW" wrote in message
...
Microsoft Excel Workbook is already selected in the Transition tab.

I do not have a ResetSheet formula. It is a macro in module1. Why
would
Excel think it's a formula in a cell?


"Tom Ogilvy" wrote:

Why not save in the normal file format for the version of excel you
are
using.

Look in Tools=Options=Transition tab and the first entry is where
you
select the default format for saving.

Choose "Microsoft Excel Workbook" from the dropdown would be my
recommendation.

--
Regards,
Tom Ogilvy

"RW" wrote in message
...
I get the following message when I save a workbook:

A formula in a cell (Name:[Book1.xls]CO3POS!ResetSheet) could not
be
converted because it contains a function that is not available in
the
file
format wo which you are saving.....

I have a macro in Module1 with the name ResetSheet but I do not
have
this
referenced in a cell on the CO3POS worksheet. How can I resolve
this?

Problem with formula in cell
 

Nothing comes to mind.

--
Regards,
Tom Ogilvy

"RW" wrote in message
...
Tom,

Thanks for providing the code to look for invisible sheets - none existed.

I also checked Insert=Name=Define on each sheet and did not see anything
named ResetSheet.


Is there anything else I can look for?

"Tom Ogilvy" wrote:

Sure you don't have a hidden sheet named ResetSheet. Maybe an Excel4
macro
sheet?

Try running code like

Sub ShowAllSheetsandNames()
Dim sh as Object, nm as Object
for each sh in ActiveWorkbook.Sheets
sh.Visible = xlsheetvisible
Next
for each nm in Activeworkbook.Names
nm.visible = True
Next
End Sub

look at all the sheets and go into Insert=Name=Define and examine all
the
names. See if they have a strange function in them.

--
Regards,
Tom Ogilvy




"RW" wrote in message
...
I commented it out and I still get the message.

I also tried changing the name of the macro to ResetSheet2 and I still
got
the message with the original name (ResetSheet)

This is very frustrating.


"Tom Ogilvy" wrote:

If you take it out or comment it out (including the declaration), do
you
still get the message?

--
Regards,
Tom Ogilvy

"RW" wrote in message
...
Microsoft Excel Workbook is already selected in the Transition
tab.

I do not have a ResetSheet formula. It is a macro in module1. Why
would
Excel think it's a formula in a cell?


"Tom Ogilvy" wrote:

Why not save in the normal file format for the version of excel
you
are
using.

Look in Tools=Options=Transition tab and the first entry is
where
you
select the default format for saving.

Choose "Microsoft Excel Workbook" from the dropdown would be my
recommendation.

--
Regards,
Tom Ogilvy

"RW" wrote in message
...
I get the following message when I save a workbook:

A formula in a cell (Name:[Book1.xls]CO3POS!ResetSheet) could
not
be
converted because it contains a function that is not available
in
the
file
format wo which you are saving.....

I have a macro in Module1 with the name ResetSheet but I do
not
have
this
referenced in a cell on the CO3POS worksheet. How can I
resolve
this?