Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm getting a bizarre error with a named cell.
The first tab has three cells named SN WO & DC. Three other tabs reference those cells directly: "=SN". But a fourth tab can't see it. If I type "=SN" into a cell Excel will popup a file browser expecting me to find a file with that name. If I copy a working "=SN" from another tab, I get an error saying that name is already on this tab. This particular tab was copied from another spreadsheet, but this does not appear to be linked back to that spreadsheet. Does anyone know what's going on here? Mike Henry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup - using a cell to reference a named array | Excel Worksheet Functions | |||
Copying a named range with a changing cell reference | New Users to Excel | |||
reference first cell in a named range | Excel Worksheet Functions | |||
Named Range reference via single Cell | Excel Discussion (Misc queries) | |||
referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions |