Last Calculated Value

[Howard Brazee]

I have a spreadsheet written in Excel 2006 for Windows. It has a
function written in Visual Basic.

When I open it using Excel Mac 08, it opens in an empty sheet, and I
need to arrow to the sheet that's used, where a column has #NAME? for
the cells using this function.

When I open it with Numbers 08, I get "Last calculated value used" as
a warning. The numbers from the calculation I had at work are in
those cells.

I infer that those numbers are saved, but that Excel Mac won't show me
them.

What good is having Excel for Mac if it's not compatible with Excel
for Windows?

 

[CyberTaz]

There is no VBA in Office 2008 (its exclusion was announced almost a year
prior to the release) so the macro will not run. Although technically this
is not a 'compatibility' issue because macros constitute customization, I
can understand where you're coming from. It has been announced tha VBA will
return to Mac Office in the next release anticipated late this year or early
next. In the meanwhile I'm afraid you'll have to continue using Numbers or
obtain a copy of Office/Excel 2004.

[BTW: There is no "Excel 2006" for either Mac or Windows.]

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Howard Brazee]

There is no VBA in Office 2008 (its exclusion was announced almost a year
prior to the release) so the macro will not run. Although technically this
is not a 'compatibility' issue because macros constitute customization, I
can understand where you're coming from. It has been announced tha VBA will
return to Mac Office in the next release anticipated late this year or early
next. In the meanwhile I'm afraid you'll have to continue using Numbers or
obtain a copy of Office/Excel 2004.

I don't think Numbers supports it either - but the difference is that
Numbers shows the last calculated value, which has a minor value to me
(as long as I'm aware that changing a value will break it).


--
"In no part of the constitution is more wisdom to be found,
than in the clause which confides the question of war or peace
to the legislature, and not to the executive department."

- James Madison