| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cross worksheet references cannot be easily changed
I have a 21 worksheet, workbook. The first sheet is 'info' and contains
common information used in the other 20 sheets. If I try to change a reference (for instance: change an '=info!$A$1' to let's say '=info!$A$5') what winds up in the cell is the literal '=info!$A$5', not the new common value. The way I am doing it is to create a new row, make it '=info!$A$5' (the new common value is now in the created row) and move it to replace the original cell. Am I doing something wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting data from one Worsheet to Another Worksheet with common link value | Excel Discussion (Misc queries) | |||
| Identifying/Eliminating Worksheet References | Excel Discussion (Misc queries) | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
| Worksheet name and Backward compatibility | Excel Discussion (Misc queries) | |||
| Excel-value in a range of cells for two cross references | Excel Worksheet Functions | |||
Linear Mode
