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

●
●
●
●
●
FactoryTalk Historian DataLink User Guide
30
Review the following for additional information:
Copy items to
sheet
Choose In a row or In a column to copy the names of multiple tags
selected in a Tag Search (or items in a Module Browse search) to
the spreadsheet in a row or column of values, respectively. The
default setting is In a column.
This command is also available as a shortcut to the Tag Search
ribbon item (2007).
Copy PI Server
Name
Select the check box to copy the name of the FactoryTalk Historian
server data source into an adjacent spreadsheet cell when tag names
are copied to a spreadsheet.
Use PI Server Time
Zone
Select the check box to force FactoryTalk Historian DataLink to use
the FactoryTalk Historian server time zone as a reference value to
interpret functions. If cleared, FactoryTalk Historian DataLink uses the
time zone setting of the client machine.
This option is relevant only if a PI server has a time zone setting
different from the client machine.
Display #N/A
instead of Blanks
Select the check box to substitute #N/A (Not Applicable) for blank
cells when there are fewer data points than cells in a function array.
Functions added to a spreadsheet maintain their original array size,
even if variance over a particular time period produces fewer data
values, resulting in one or more empty cells.
This feature is particularly useful when function results are plotted
through the Excel charting package.
Locale
Independent Select the check box to force FactoryTalk Historian DataLink to
interpret input time strings according to PI time format rules,
regardless of the locale settings of the client machine. PI time
assumes all strings are English and use the date-time order
dd-MMM-
yyyy hh:mm:ss .
Clear the check box to parse date-time formats according to regional
settings on the client machine, falling back to PI time format rules
only if necessary.
Disable automatic
task pane display
on click
For Excel 2007 only, select this check box to prevent the automatic
display of the function task pane when clicking in a function cell.
Right-click to choose the function name and display the pane
manually.
Disable "Resize to
show all values"
message
Select this check box to display no warning message when the
number of values retrieved by a recalculated array exceed the number
that can be displayed.