refresh excel table (1 Viewer)

mazer

New member
Local time
Today, 03:57
Joined
Aug 19, 2005
Messages
8
Is there any way to refresh an excel table? I added a formula to one of my excel tables but it wont work unless I re-enter the data that it use!
 

Sergeant

Someone's gotta do it
Local time
Yesterday, 22:57
Joined
Jan 4, 2003
Messages
638
You can hit F9 to recalculate manually, or in VBA:
[Sheet Object].Calculate
 

Users who are viewing this thread

Top Bottom