| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing worksheet references
After copying worksheets from one workbook into a new one the cell references
in the new workbook refer to values in the old workbook A typical cell reference in the new workbook might look like ='C:\Some Directory\[SomeWorkbook.xlsm]SomeWorksheet'!$AQ$4'. The correct reference in the new workbook should be =SomeWorksheet!$AQ$4. There must be several hundred such references in the new workbook. Is there some way, other than manually, to correct the references to the current workbook? TIA, Ken |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing multiple worksheet references in formulae | Excel Discussion (Misc queries) | |||
| Chart data references not changing to new tab when worksheet is co | Charts and Charting in Excel | |||
| Changing Cell References To a Different Worksheet in the Same Cell | Excel Worksheet Functions | |||
| changing cell references | Excel Discussion (Misc queries) | |||
| Excel references keep changing | Excel Discussion (Misc queries) | |||
![Ken Warthen[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
