1. Home
  2. Knowledge Base
  3. DataLog
  4. Excel Integration Problems

SITUATION:
The Excel worksheet keeps refreshing DataLog data that the user wants saved.

EXPLANATION:
Excel keeps track of when specific cells need to be refreshed and will “call” the correct functions.
This causes problems when a permanent copy of exported data is desired.
Further, if changes were made to a worksheet, at a later date, the sale might no longer exist in the database.
The result is cells filled with the “NoSale# error code.
If the sale number does exist, then the current data will be overwritten with the new data from DataLog.

SOLUTION:
To prevent the problem, copy the data from the master spreadsheet to another spreadsheet.
Use Paste Special; select Values and number formats so that formulas are stripped; then paste the actual calculated values.
The spreadsheet can now be changed without DataLog refreshing the data.
Continue to use the original spreadsheet to import different sales if needed.



SITUATION:
The DataLog Excel integration feature is not working properly after upgrading one PC to a newer version of Excel; using multiple PCs.

EXPLANATION:
The problem occurs as the result of opening the spreadsheet in a different version of Excel. Excel re-fires the math.

SOLUTION:

a) Update Excel on the computers that are “behind.”

b) When creating the spreadsheet on one PC after having brought in the comp sales data needed, copy the cells with data and paste over the top of the existing information so that the formulas are overwritten with just the numbers and text.
When doing the paste, use the “Values and Number formats” paste special option.

c) It may be possible to mark the spreadsheet as read-only on the one PC and then use the paste options (mentioned in “b” above) to paste “special” into a new spreadsheet



 

Was this article helpful?

Related Articles