Excel VBA code using ctrl+a doesn't work after upgrading to Excel 2003

[kris416]

I have a spreadsheet and within the sheet itself is the following:
\a {calc}/fxvbalance~balance~r
{goto}start~/fccebalance~
{goto}totals~


I do know a few things, one is there is a "name" defined as "\a" which
refers to the cells where the commands above are located. In Excel 97,
you hit "ctrl+a", and it excutes some calculations. I cannot find in
the sheet anywhere references to "fxvbalance" or some of the others. I
do know that we upgraded to Office 2003, and now this calculation
process doesn't work. I also am not familiar with how it is embedded
within the sheet, instead of using a macro. Any help would be greatly
appreciated.

Thanks

 

[Quaoar]

I have a spreadsheet and within the sheet itself is the following:

\a {calc}/fxvbalance~balance~r
{goto}start~/fccebalance~
{goto}totals~


I do know a few things, one is there is a "name" defined as "\a" which
refers to the cells where the commands above are located. In Excel 97,
you hit "ctrl+a", and it excutes some calculations. I cannot find in
the sheet anywhere references to "fxvbalance" or some of the others. I
do know that we upgraded to Office 2003, and now this calculation
process doesn't work. I also am not familiar with how it is embedded
within the sheet, instead of using a macro. Any help would be greatly
appreciated.

Thanks

Umm, a shot in the dark, but this looks like it might be an embedded
Lotus 123 macro that was converted in Excel 4 or so. It does not look
like any Excel 4 macro language I've used. Select the sheet, and Press
CTRL + ` (grave accent) to show formulas. See if a macro is visible in
the formulas.

Q

 

[kris416]

The information I copied in the original post is visible even before yo
use ctrl + `. There aren't any maco's that I can see. The weird thin
is it will execute those calculations in Excel 97 when you hit ctrl
A