On 9/29/2019 2:12 PM, Brian Barker wrote:
One idea: the target document needs to have been saved after any
changes before any values from it can be harvested in this way.
That one idea hit the mark Brian!
When I returned to work on my Calc spreadsheets today, the problem was
not experienced. Then, when I made a change to one of my
/_external_/ref/source/ Calc files, (i.e., what you have called " the
target document") today, the problem was experienced again. After saving
my /_external_///ref/source/ file, closing AOO and reopening Calc, I was
able to "harvest" once again. So, I must remember to save those files
before attempting to harvest data values from them.
Many thanks for your insight and sharing of your ideas.
Regards,
VinceB.
