Event 1 Office Connector Web HelpOnline Help

Save As Values Command
Contents Index

  Data / Office Connector / Save As Values...

The Save As Values command creates a copy of your spreadsheet with all functions and queries specific to Office Connector removed.  The resulting file is much smaller, does not require the Office Connector software, loads much faster and can not be refreshed.

The following actions are taken when you click Save As Values:
  1. You are prompted for a new file name with the default being the current file name plus the word "Values" in parenthesis.
  2. All queries based on the Event 1 data source are removed, but the data remains on the spreadsheet.
  3. All Office Connector workbook functions are replaced by their values.
  4. The persistent function cache is deleted.
  5. The workbook is saved under the new name.

See Also



Content updated 3/6/2007
Copyright © 2007 Event 1 Software, Inc.  This documentation may not be copied in full or in part without written permission from Event 1 Software, Inc.