View Full Version : refresh excel table


mazer
02-11-2006, 12:46 PM
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
02-11-2006, 12:53 PM
You can hit F9 to recalculate manually, or in VBA:
[Sheet Object].Calculate