Forum Discussion
Cell won't reference cell in other worksheet?
Sometimes I copy a worksheet from one workbook to another workbook. How do I do that without making the copy reference the original workbook? I want the worksheet to reference the other worksheet in the same workbook.
4 Replies
- The easiest is to:
- Save the file you just copied the sheet into
- Click the Data tab of the ribbon
- Click Edit links
- Select the other file in the list that appears
- Click "Change source"
- Navigate to the file you just saved and click Open.
- close the edit links dialog (the link to the original file should have been removed from the list)Thanks! So the other problem, that may not be connected to that is when I have a cell that won't reference another Worksheet in the same Workbook?
Ex:
I'll type "=" then click over to the other page and click on the cell I want to be referenced. Usually, that shows the value of the cell on the other sheet but in just these few cells it just shows "=Schedule!B1" which is the name of the cell I want referenced instead of the value? It's not like that everywhere on this Worksheet but just these few cells I need that information in. I've selected those cells and hit "Delete" to try and clear the cell but it doesn't seem to work? Suggestions?
Thank you.
- Change the format of those cells to something other than text. Then F2 enter the formula.
