Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Adding Refresh All to Excel Sheet
Name: bcreasy Date: March 13, 2007 at 06:48:24 Pacific OS: XP Pro SP2 CPU/Ram: 2.8 - 512 Product: Dell
Comment:
I have some office 2003 spreadsheets that have data fields from external sources. When I go to update I use the "Main" page but have to click the "Refresh All" button from the tool bar to update. Is it possible to somehow link this into the page, some folks don't have the "Refresh All" button on tool bar and it's a pain to explain all the time. I would like the button attached to my main sheet. Possible ?
Name: DerbyDad03 Date: April 20, 2007 at 11:07:36 Pacific
Reply:
1 - Write or record a macro that performs the Refresh All function. 2 - Store the macro in the ThisWorkbook module of the workbook. 3 - Place a "button" (a shape, a textbox, etc.) on the Main page. 4 - Right click the button and assign the macro.
When the users click the button, the macro will run. This method assumes that the Macro Security level of each user's Excel app is set to allow macros to run.
Summary: Hello, I have to send a feed back email to a list of customers. I have all their data on a Excel sheet. What I would like to do is this: I want to know if there is someway I can get Outlook to send ...
Summary: I need to print 200 addresses very fast, so i got no time to go through the word option. Since word only allows me to enter name by name not all names at ones. That and word will start to print outsid...
Summary: Yes it can, you create it like a formula using IF THEN ELSE statements, checking for the current MONTH, not the day. Read up your Excel Help documentation on this, the usage is there along with an exa...
0 
