Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel link to data in other worksheet only refreshes one column
In an Excel workbook, I want to link data from one worksheet (a list of
companies containing three columns of data - name, ID#, Ref#) to several other worksheets in the workbook (where various calculations will occur). I used the Import Data feature to link between worksheets. When I update data in the source worksheet (add a company name, ID#, Ref#), only the company name is updated/refreshed in the dependent worksheets. I need all three data elements from the source worksheet to be refreshed in the dependent worksheets. Anyone understand the problem and how to fix it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to link website data to Excel cells | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Updating Excel OLE chart data in PPT from Excel | Charts and Charting in Excel | |||
Link excel and word in mail merge without losing your data source? | Excel Discussion (Misc queries) | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) |