4dv18.2, Mac Mojave
I’m trying to import data from an Excel file using VP IMPORT DOCUMENT. All the numeric fields are defined as “=VLOOKUP…”. I don’t have access to any of the original lookup fields.
I can open the document using Excel, clicking on “don’t update links” in the alert that appears, and all the numeric fields are fine, and I can use AppleScript
tell Excel to open workbook … update links do not update links
In View Pro, however, I don’t see an equivalent option, and while the static text fields look fine, all the numeric fields show as #REF!
Can I use VP IMPORT DOCUMENT? Is there a solution?