Claude Davis 6/3/2009

Like

3155 Views

There appears to be inconsistency on how linked Excel files are updated.
After saving updates to the Excel file, AND forcing a refresh of excel links, spurious values appear in some LEAP demand data when recalculating Results. The error message is "Cannot convert excel cell to a value etc..".

On opening the sheet with the cell indicated in the message, and forcing a refresh, the erroneous links (highlighted in red italics) are updated OK (red italics changed to regular blue text).
Recalculating again gives a similar error in a different sheet but the same process is repeated.

Does LEAP handle correctly the updating of multiple sheets in the same file or indeed in multiple files?

Claude Davis 6/5/2009
 

Like

3150 Views

Using excel files with a single linked worksheet as opposed to multiple worksheets that are linked) resolves the issue.