| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
when i select dont update I get #REF!
When I select dont update sheet, previous version should my figures. With 2k3
figure change to #REF! I'm puzzled, how do i prevent this from happening? |
|
#2
|
|||
|
|||
|
xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links prompt, the existing values are kept. In xl2002+, you get those errors. Jim Rech posted a registry tweak: http://groups.google.com/groups?thre...GP11.phx .gbl Maybe it'll work ok for you. mmollat wrote: When I select dont update sheet, previous version should my figures. With 2k3 figure change to #REF! I'm puzzled, how do i prevent this from happening? -- Dave Peterson |
|
#3
|
|||
|
|||
|
You are the man! That worked like a charm. Thanks for the quick reply!
"Dave Peterson" wrote: xl2002+ likes to recalculate any workbooks that were created in previous versions. In earlier versions of excel, if you answer No to the update links prompt, the existing values are kept. In xl2002+, you get those errors. Jim Rech posted a registry tweak: http://groups.google.com/groups?thre...GP11.phx .gbl Maybe it'll work ok for you. mmollat wrote: When I select dont update sheet, previous version should my figures. With 2k3 figure change to #REF! I'm puzzled, how do i prevent this from happening? -- Dave Peterson |
|
#4
|
|||
|
|||
|
Jim is very smart!
I'm sure he's happy you got it working. mmollat wrote: You are the man! That worked like a charm. Thanks for the quick reply! "Dave Peterson" wrote: xl2002+ likes to recalculate any workbooks that were created in previous versions. In earlier versions of excel, if you answer No to the update links prompt, the existing values are kept. In xl2002+, you get those errors. Jim Rech posted a registry tweak: http://groups.google.com/groups?thre...GP11.phx .gbl Maybe it'll work ok for you. mmollat wrote: When I select dont update sheet, previous version should my figures. With 2k3 figure change to #REF! I'm puzzled, how do i prevent this from happening? -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when i select dont update I get #REF!
I tried to do the same fix for the same error and was not sucessful! I do not
have the same registry entrys for Office 9.0 (no options folder). I tried to use the DWORD key in Options under Office 11 and in just Office 9.0 both with no effect... Anybody else have a fix to try? thanks, -- Dino "mmollat" wrote: When I select dont update sheet, previous version should my figures. With 2k3 figure change to #REF! I'm puzzled, how do i prevent this from happening? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update Links - Problem | Links and Linking in Excel | |||
| Update linked cells within a workbook??? | Links and Linking in Excel | |||
| select database | Excel Discussion (Misc queries) | |||
| Select all data, multiple rows | Excel Discussion (Misc queries) | |||
| Using excel to select only matching images... | Excel Discussion (Misc queries) | |||
Linear Mode
