Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Excel 2007 not showing "previous data"
I have a lot of Excel 2003 spreadsheets that I cannot change from a
thirdparty. When I opened them in Excel 2003 as was able to not update the links and show the previous data. No matter what combination of settings I put in to Excel 2007 it is not showing me the previous data just #Name where the link would be. can anyone give me a pointer as to what I can do to resolve this. I get the security warning and reply Enable content I then get an alert abouts links that can't be updated - I reply continue and that is it. I have no option to Display Previous data as I did in Excel 2003 Many thanks |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
Excel 2007 not showing "previous data"
I have found my own solution to the problem. the details below actually refer
to an earlier version of Excel and it would appear that this problem has been in existence for about 10 years - permenant fix would be good: Jim Rech View profile (1 user) More options 7 Apr 2004, 17:48 Newsgroups: microsoft.public.excel.programming From: "Jim Rech" Date: Wed, 7 Apr 2004 13:47:26 -0400 Local: Wed 7 Apr 2004 17:47 Subject: Excel recalculates formulas when opening files last saved by an earlier version of Excel Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author You get this particular message only when you open a workbook that was already fully calced (as far as the earlier version of Excel was concerned) but Excel 2000 calced it anyway just because it was from an earlier version. To stop this you need to make a registry entry (Start-Run "Regedit" (no quotes)). Under: HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Ex cel\Options create a new DWORD item named: FullCalcOnLoadOldFile Leave its value at the default of 0. Thanks Jim Rech - excellent fix - works for Excel 2007 too. andy Clark "Andy Clark" wrote: I have a lot of Excel 2003 spreadsheets that I cannot change from a thirdparty. When I opened them in Excel 2003 as was able to not update the links and show the previous data. No matter what combination of settings I put in to Excel 2007 it is not showing me the previous data just #Name where the link would be. can anyone give me a pointer as to what I can do to resolve this. I get the security warning and reply Enable content I then get an alert abouts links that can't be updated - I reply continue and that is it. I have no option to Display Previous data as I did in Excel 2003 Many thanks |
#3
Posted to microsoft.public.excel.links
|
|||
|
|||
Excel 2007 not showing "previous data"
Hi,
Actually the solution is to NOT choose Enable content related to links. That is the equivalent of the old negative response to Update Links? You can just leave the security bar on screen it will do nothing unless you enable content. -- Thanks, Shane Devenshire "Andy Clark" wrote: I have a lot of Excel 2003 spreadsheets that I cannot change from a thirdparty. When I opened them in Excel 2003 as was able to not update the links and show the previous data. No matter what combination of settings I put in to Excel 2007 it is not showing me the previous data just #Name where the link would be. can anyone give me a pointer as to what I can do to resolve this. I get the security warning and reply Enable content I then get an alert abouts links that can't be updated - I reply continue and that is it. I have no option to Display Previous data as I did in Excel 2003 Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting the occurrence of "Y" & "N" in Excel 2007 | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
keyboard shortcut to return to previous cell after "find" or "got. | New Users to Excel | |||
how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions |