| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Cell Reference updating
I have created a excel file and in it there is a sheet that is copied each
month and then it data is filled in during the month, the data is charted as it's entered, and all is well. This same excel file is in use on a different computer. The file was originally created with excel 97-2003 and updated to 2007 on both computers (stand alones). On one computer, when the page is copied, the cell references automatically update to reflect the new sheet name, which is what we want. On the other, they do not. The cell references remain the original sheet. I've checked all options, and they are the same. What am I missing? What do I need to do to the second computer so the cell references DO automatically update? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating a reference ROW | Excel Discussion (Misc queries) | |||
| Updating Indirect Reference(s) | Excel Worksheet Functions | |||
| Updating cells which reference a defined name | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Linear Mode
