| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing:Data Connection Wizard Doesn't see Source Data - No Impo | Excel Discussion (Misc queries) | |||
| Removing Data Tables formed from importing data from Access | Excel Discussion (Misc queries) | |||
| Importing Data: OLE DB and data link properties dialog | Excel Discussion (Misc queries) | |||
| Data types when importing Excel data to SQLServer | Excel Discussion (Misc queries) | |||
| Importing data, then adding data to the new spreadsheet.. a conund | Excel Discussion (Misc queries) | |||
Threaded Mode
