If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
excel name only refreshes after clicking equation button
I have a cell that references a named cell on another worksheet within
the same workbook. I save and retrieve the first worksheet for storage. Upon retrieval the cell value is set to "#NAME?" even though the formula says it is set to the named cell. When I double-click the cell or click the equation button it then updates appropriately, but I will have many cells that should be doing this automatically. What should I do? |
#2
|
|||
|
|||
excel name only refreshes after clicking equation button
Hi
is automatic calculation enabled? -- Regards Frank Kabel Frankfurt, Germany "Timothy Golden" schrieb im Newsbeitrag m... I have a cell that references a named cell on another worksheet within the same workbook. I save and retrieve the first worksheet for storage. Upon retrieval the cell value is set to "#NAME?" even though the formula says it is set to the named cell. When I double-click the cell or click the equation button it then updates appropriately, but I will have many cells that should be doing this automatically. What should I do? |
#3
|
|||
|
|||
excel name only refreshes after clicking equation button
Timothy Golden wrote:
Upon retrieval the cell value is set to "#NAME?" even though the formula says it is set to the named cell. Which version of Excel? Is it a straight reference to a named cell ( e.g. =MyName ) or something more complicated? Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#4
|
|||
|
|||
excel name only refreshes after clicking equation button
"Frank Kabel" wrote in message ...
Hi is automatic calculation enabled? Hi Frank. Yeah, even if I explictily go to the calculate option within options and tell it to calculate the value stays with the error message. Automatic calculation is enabled in my settings. -- Regards Frank Kabel Frankfurt, Germany "Timothy Golden" schrieb im Newsbeitrag m... I have a cell that references a named cell on another worksheet within the same workbook. I save and retrieve the first worksheet for storage. Upon retrieval the cell value is set to "#NAME?" even though the formula says it is set to the named cell. When I double-click the cell or click the equation button it then updates appropriately, but I will have many cells that should be doing this automatically. What should I do? |
#5
|
|||
|
|||
excel name only refreshes after clicking equation button
Bill Manville wrote in message ...
Timothy Golden wrote: Upon retrieval the cell value is set to "#NAME?" even though the formula says it is set to the named cell. Which version of Excel? Is it a straight reference to a named cell ( e.g. =MyName ) or something more complicated? Bill Manville I am using Excel 2000 ( 9.0.3821 ) on windows XP. The reference is straghtforward : "=SubjectStreet" What is not straightforward is the storage and retrieval of the worksheet. The whole architecture of doing this involves copying the individual worksheet to a temporary file which is stored off in a database as a binary. I then retrieve the sheet and copy it back into the workbook with a new worksheet name, whereupon the cell values come up "#NAME?" for no apparent good reason. The process is reliable, though full of architectural questions as to what to do with the names and formula references. This is the simplest case reference. I have found that setting the formula value of the cell to itself causes the value to be updated. This is a long operation to perform on every cell in the sheet. Is there a spec somewhere on how excel reference syntax works? I am getting bogged down in experimentally figuring this out. Thanks Bill. Tim Golden |
#6
|
|||
|
|||
excel name only refreshes after clicking equation button
Timothy Golden wrote:
I am using Excel 2000 ( 9.0.3821 ) on windows XP. The reference is straghtforward : "=SubjectStreet" It MIGHT help to apply the various service packs. Current version is 9.0.6926 SP-3. If you look in Insert / Name / Define what do you see SubjectStreet refering to? Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|