Thread
:
Auto Calculate
View Single Post
#
2
Posted to microsoft.public.excel.misc
Fred Smith
external usenet poster
Posts: 623
Auto Calculate
It wouldn't be too hard to record a macro to do this.
Next time you do it manually, turn on macro recording in a blank spreadsheet.
When you're done, turn off macro recording, then save the file. Next time, you
should be able to run the macro from this file.
By the way, you should be able to use the shortcut F9 to recalculate.
--
Regards,
Fred
"Nick Leach" <Nick
wrote in message
...
could you tell me how i could auto calculate multiple excel spreadsheets.
what i'm trying to say is, in a folder on our network, there are multiple
excel documents. we have to go into each document and go through Tools, the
Auto Calculate. is there a way to just do it once or send out a rule through
the server to say auto calculate all of these spreadsheets in this folder?
Thank you in advance
Nick
Reply With Quote
Fred Smith
View Public Profile
Find all posts by Fred Smith