M mazer New member Local time Today, 20:01 Joined Aug 19, 2005 Messages 8 Feb 11, 2006 #1 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!
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!
S Sergeant Someone's gotta do it Local time Today, 15:01 Joined Jan 4, 2003 Messages 638 Feb 11, 2006 #2 You can hit F9 to recalculate manually, or in VBA: [Sheet Object].Calculate
