Rockwell Automation FactoryTalk Historian SE DataLink 4.2 User Guide - Manual (Page 78)

●
●
●
●
●
FactoryTalk Historian DataLink User Guide
70
the function. To maintain a constant size for Compressed Data (page 36)
functions, specify the number of values to retrieve rather than a time range.
Or to display only a predetermined portion of results, specify a limited
output cell range (page 18).
Share Spreadsheets
If you want to share FactoryTalk Historian data and make spreadsheets
accessible to other users, keep the following considerations in mind:
 You can send a FactoryTalk Historian DataLink spreadsheet to
another Microsoft Excel user. The user must have FactoryTalk
Historian DataLink installed and an active connection to the same
FactoryTalk Historian server in order to recalculate functions and see
dynamically updated FactoryTalk Historian point values.
 If users do not have FactoryTalk Historian DataLink installed, they
can still see the last data saved in the spreadsheet provided the Excel
Calculation options are set to Manual prior to the spreadsheet being
opened in Excel.
 In Excel 2007, click the Office 2007 button, then click Excel
Options > Formulas to access these options.
 In Excel XP-2003, the manual setting is available under Tools >
Options on the Calculation tab.
 You can also save in HTML or PDF format in Excel 2007 to share a
static spreadsheet.
 You can copy and paste (page 67) values from function arrays to new
locations on a spreadsheet using Paste Special. Although the
spreadsheet data can no longer be recalculated once copied, this
method allows you to distribute a customized snapshot of data to
anyone who has a copy of Excel.
 If you have Microsoft SharePoint Server in your computing
environment, you can publish a DataLink spreadsheet to a SharePoint