Problem with formula in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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 said:
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 said:
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?
Click to expand...
Click to expand...
 
If you take it out or comment it out (including the declaration), do you
still get the message?

--
Regards,
Tom Ogilvy

RW said:
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 said:
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 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
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 said:
If you take it out or comment it out (including the declaration), do you
still get the message?

--
Regards,
Tom Ogilvy

RW said:
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 said:
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

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?
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
If you take it out or comment it out (including the declaration), do you
still get the message?

--
Regards,
Tom Ogilvy

RW said:
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?


:

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

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
Click to expand...
the
file
format wo which you are saving.....

I have a macro in Module1 with the name ResetSheet but I do not
Click to expand...
have
this
referenced in a cell on the CO3POS worksheet. How can I resolve this?
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
If you take it out or comment it out (including the declaration), do you
still get the message?

--
Regards,
Tom Ogilvy

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?


:

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

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?
Click to expand...
Click to expand...
Click to expand...
 
Nothing comes to mind.

--
Regards,
Tom Ogilvy

RW said:
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 said:
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 said:
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.


:

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

--
Regards,
Tom Ogilvy

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?


:

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

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

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

--
Regards,
Tom Ogilvy

I get the following message when I save a workbook:

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

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

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

Similar Threads

Calling excel macro not located in that workbook. 2
Excel Formula to add network file link to each month 1
Buttons re-assigned themselves to the right macro name but in Book 1
Referencing Inactive Workbook Cells 3
Using replace in VBA 7
Please help with code 3
HELP!!! I can't set formula to cell 1
Save as File Problem 2

Back
Top