A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel 2007 not showing "previous data"



 
 
Thread Tools Display Modes
  #1  
Old October 27th, 2008, 02:56 PM posted to microsoft.public.excel.links
Andy Clark
external usenet poster
 
Posts: 1
Default 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  
Old October 27th, 2008, 05:51 PM posted to microsoft.public.excel.links
Andy Clark[_2_]
external usenet poster
 
Posts: 1
Default 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  
Old October 31st, 2008, 11:16 AM posted to microsoft.public.excel.links
ShaneDevenshire
external usenet poster
 
Posts: 2,232
Default 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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:22 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.