Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the Facility Hero app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
Everything you need to know about our IoT technology backbone.Learn more
Welcome to the Schneider Electric Global Website×
Goals and Symptoms
Follow http://www.powerlogic.com/kbarticle.cfm?myrequest=RESL182688%20AND%20viewing to be able to import data into an excel spreadsheet. In order to have this data update every time you click on a button, follow the resolution below.
Causes and Fixes
This procedure will create a button that you can push in order to automate the update process with a macro.
Put your cursor inside the contents of the database query in your spreadsheet; that should cause the External Data toolbar to pop up.
Select a cell in the database query range, such as B5, and click on the Refresh button (orange exclamation point) on the External Data toolbar (let it run through its process) and on the Stop button on the Stop Recording toolbar. If the toolbar doesnt pop up, do one of the following: Select either Tools, Macro, Stop Recording or View, Toolbars and Stop Recording. Then click on Stop.
Now that weve recorded a macro, we need to attach it to a button in the spreadsheet. Though any type of button will work, well add one from Excels Forms toolbar. Click on View, Toolbars, Forms. Left-click on the button (its circled) and then release it.
Although it took many setup steps, now you can save loads of time by updating your spreadsheet with new database information with just one click.
Last Revised: May 2008
Applies To: ION Enterprise 5.6, 5.5 and 5.0
Original Author: MN
All content © 1992-2008 Schneider Electric