User manual

Using@aGlancewithExcelA-4
SIMATIC PCS 7 OSx 4.1.1 @aGlance
A.2 Using the @aGlance Option
To open an @aGlance session with Excel, refer to your documentation for
Excel and the @aGlance/IT add-in, and follow the steps below.
1. Open Windows and run the Excel program.
2. Open a spreadsheet file.
3. If you have already created a sheet that contains hot links, the Excel
add-in displays one or both of the following prompts:
This document contains links. Re-establish links? or
Remote data not accessible. Start application “AAGDDE.EXE”?
In either case, click Yes to resume data acquisition.
4. Continue your spreadsheet operations. The procedures for defining cold
links and new hot links are described below.
If your @aGlance/IT add-in software is installed, you can now begin
acquiring data from the OSx server and recording it in your spreadsheet.
Consider these guidelines for cold links.
 Click
@aGlance on the Excel menu bar to display the @aGlance/IT
options (Figure A-2). If @aGlance does not appear on the menu bar, see
page A-3 for a procedure that you can use to add it to the menu bar.
A1
✂
File Edit View Insert Tools Data Window @aGlance Help
1
2
3
4
ABCD E FG HIJ
10Aerial
I
U
$
o
/
o
,
B
Browse Data...
Br
owse History...
@aGlance Help
Macro Tool...
Wizard
I
nsert Macro Sheet
Example Sheets
.
Help
A
bout.
.
Figure A-2 Selecting the @aGlance Options
Opening a Session
Working within a
Session:
Cold Links