Recalculate in Excel mobile?

  • Thread starter Thread starter janewilliams20
  • Start date Start date
J

janewilliams20

In Excel on my PC, I can press F9 to recalculate - to re-roll a virtual
dice, in this case. My PDA doesn't have an F9 key, and I can't spot
anything obvious on the menus. Suggestions?
 
I've now tried creating an ActiveX control - a button that calculates.
Works fine on the PC, doesn't even appear in Excel Mobile. Not really
any surprise, I suppose.
 
Tools>Option>Calculation tab, Calculate Now?
I don't know Excel Mobile.
Can you record a macro to do that?
 
Let me see... yes, I can record the macro on the PC. I can assign it
to a short-cut key. And it works. But when I transfer the file to the
PDA - ah, well there *is* no Ctrl key to press, so my short-cut won't
do a lot. And the menus do not mention macros.

The tools menu has two options: sort and autofilter.

Nice try though, thanks. I didn't know where the menu way of getting to
it was before, so I'm a step further.
 
If you are using excel for pocket pc or for mobile smart phones don't expect
it do be able to do anything except for some rudimentary functions, it
shouldn't really be called excel. I have pocket pc and after testing it
quite thoroughly I have never used it
 
It's OK, rudimentary stuff is all I'm after. The most complicated I get
is a VLOOKUP, and that works. I just thought recalculating *was*
fairly rudimentary.

I'll fall back on keeping one cell clear, typing dummy data in in and
pressing return. That'll force a recalculate. It just lacks style :(
 
Back
Top