Importing data
"ShaneDevenshire" wrote in
message ...
Hi,
Should work, just make sure your spreadsheet is set to Automatic
Recalculation or press the F9 key.
--
Thanks,
Shane Devenshire
Thank you for the two responses to my question. It appears the problem was
due to the Data Range Properties not being set correctly. Once I changed
these to "Overwrite existing cells with new data, clear unused cells" the
second worksheet refreshes correctly when the data refresh is done.
Sid.
|