Thread: Importing data
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Sid Price Sid Price is offline
external usenet poster
 
Posts: 2
Default 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.