(Msg. 1) Posted: Wed Apr 23, 2008 7:10 am
Post subject: Excel 2007 data link update prompt Archived from groups: microsoft>public>excel>links (more info?)
A user has recently upgraded from office 2003 to office 2007 on a Windows XP
SP2 machine.
This user used to receive a spreadsheet from a client via email to display
items ands costs, etc.
When opening up the file, the user received a message saying...
--------------------------------------------------
This workbook contains links to other data sources.
-If you update the links, Excel will attempt to retrieve the latest data.
-If you don't update the links, Excel will use the previous information.
Note that data links can be used to access and share confidential
information without your permission and possibly perform other harmful
actions. Do not update the links if you do not trust the source of this
workbook.
Update Don't Update Help
--------------------------------------------------
After clicking on Don't Update, the file opens up fine with all of the
correct data in.
However, we have upgraded this computer to office 2007. When opening up the
same email as before and the same excel attachment, no "data source link
update" prompt appears, and in place of the majority of where information
used to be, is cells filled with #NAME?
When highlighting each cell with these contents the formula bar states...
='C:\Program Files\Microsoft
Office\Office12\LIBRARY\pcas97.xla'!prodlookup("per",A22)
Why? What is causing this?
One other confusing thing is if the email is opened up, and we preview the
attachment in the email, the correct data is displayed, just like it was in
Office 2003, but this document needs to be printed out. If this is attempted
it opens up Excel and prints the file with #NAME? in the cells.
I've had a look in the options of Excel (i'm quite new to office 2007) to
find something to do with this link update prompt that appeared in 2003. I
found something that i thought was it, but it didn't work.
Any ideas on getting around this without reverting back to office 2003?
(Msg. 2) Posted: Thu Apr 24, 2008 5:03 pm
Post subject: Re: Excel 2007 data link update prompt [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Seems to me that you probably had an add-in installed in 2003 called
pcas97.xla, but that you haven't installed the same add-in in 2007.
Alternatively, if the ProdLookup function is actually a macro within
the workbook then you may need to change the security settings in Excel
2007.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
(Msg. 3) Posted: Wed Apr 30, 2008 6:32 am
Post subject: Re: Excel 2007 data link update prompt [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thanks for the reply.
I've set Excel to allow all macros, this doesn't correct the problem.
The add-in was what I expected it to be also. I attempted to access terminal
services (office 2003) and using a similar file path, locate the add-in which
I had presumed was with the other add-in files under...
The pcas97.xla file wasn't there (even checked hidden files, and checked the
folders in the Library directory). I also checked in the ADDINS folder in the
OFFICE11 directory.
I believe the file may have been created by the originator of the
spreadsheet who is the external party mailing this to us.
I still don't understand how it can work on Office 2003 when i'm unable to
find the add-in where Office 2007 says it should be.
(Msg. 4) Posted: Thu May 01, 2008 12:01 am
Post subject: Re: Excel 2007 data link update prompt [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I know that the treatment of links is different in 2007 than in 2003
and there are some features that I consider to be bugs (e.g. if you
have links to C:\Folder1\File.xls in an open workbook and you open
C:\Folder2\File.xls the links will be redirected to that opened
File.xls workbook).
One reason for different behaviour in 2007 from 2003 would be if the
sender had saved it in 2003; on opening it in 2007 a full recalculation
is performed and these formulas will not be able to be computed because
the add-in is not present. When you were opening it in 2003 there was
no need for the full recalc and so the previously computed values were
used in the absence of the add-in.
Potential solutions:
- get the sender to give you a copy of the add-in
- get the sender to convert formulas to values before sending the
workbook
- get the sender to save the workbook in 2007 before sending it.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
(Msg. 5) Posted: Thu May 08, 2008 3:58 am
Post subject: Re: Excel 2007 data link update prompt [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Just received the spreadsheet with the values converted!
Thank you for this.
"Bill Manville" wrote:
> I know that the treatment of links is different in 2007 than in 2003
> and there are some features that I consider to be bugs (e.g. if you
> have links to C:\Folder1\File.xls in an open workbook and you open
> C:\Folder2\File.xls the links will be redirected to that opened
> File.xls workbook).
>
> One reason for different behaviour in 2007 from 2003 would be if the
> sender had saved it in 2003; on opening it in 2007 a full recalculation
> is performed and these formulas will not be able to be computed because
> the add-in is not present. When you were opening it in 2003 there was
> no need for the full recalc and so the previously computed values were
> used in the absence of the add-in.
>
> Potential solutions:
> - get the sender to give you a copy of the add-in
> - get the sender to convert formulas to values before sending the
> workbook
> - get the sender to save the workbook in 2007 before sending it.
>
> Bill Manville
> MVP - Microsoft Excel, Oxford, England
> No email replies please - respond to newsgroup
>
>
(Msg. 6) Posted: Mon May 26, 2008 7:57 am
Post subject: Re: Excel 2007 data link update prompt [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Bill,
Thank you very much for the work around provided to this issue.
Not every sender is that much cooperative to do something on my behalf since
I migrated to Office 2007. It would be great if you provide some alternate
solution to preview the attached XL file and get them printed as you see with
values.
Awaiting your resposne.
Thanks and Regards,
Dasan
"Bill Manville" wrote:
> I know that the treatment of links is different in 2007 than in 2003
> and there are some features that I consider to be bugs (e.g. if you
> have links to C:\Folder1\File.xls in an open workbook and you open
> C:\Folder2\File.xls the links will be redirected to that opened
> File.xls workbook).
>
> One reason for different behaviour in 2007 from 2003 would be if the
> sender had saved it in 2003; on opening it in 2007 a full recalculation
> is performed and these formulas will not be able to be computed because
> the add-in is not present. When you were opening it in 2003 there was
> no need for the full recalc and so the previously computed values were
> used in the absence of the add-in.
>
> Potential solutions:
> - get the sender to give you a copy of the add-in
> - get the sender to convert formulas to values before sending the
> workbook
> - get the sender to save the workbook in 2007 before sending it.
>
> Bill Manville
> MVP - Microsoft Excel, Oxford, England
> No email replies please - respond to newsgroup
>
>
(Msg. 7) Posted: Tue Jul 15, 2008 4:43 am
Post subject: Re: Excel 2007 data link update prompt [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"Bill Manville" wrote:
> I know that the treatment of links is different in 2007 than in 2003
> and there are some features that I consider to be bugs (e.g. if you
> have links to C:\Folder1\File.xls in an open workbook and you open
> C:\Folder2\File.xls the links will be redirected to that opened
> File.xls workbook).
>
> One reason for different behaviour in 2007 from 2003 would be if the
> sender had saved it in 2003; on opening it in 2007 a full recalculation
> is performed and these formulas will not be able to be computed because
> the add-in is not present. When you were opening it in 2003 there was
> no need for the full recalc and so the previously computed values were
> used in the absence of the add-in.
>
> Potential solutions:
> - get the sender to give you a copy of the add-in
> - get the sender to convert formulas to values before sending the
> workbook
> - get the sender to save the workbook in 2007 before sending it.
>
> Bill Manville
> MVP - Microsoft Excel, Oxford, England
> No email replies please - respond to newsgroup
>
>
I have the same problem with:
-all the files that I created with excel 2003. I changed the computer and I
have a new address to the source files or some source files are missing.
- and the sent files that I have created in excel 2007 using links. The
receiver gets an file with #VALUE! cells
(Msg. 8) Posted: Tue Jul 15, 2008 10:06 pm
Post subject: Re: Excel 2007 data link update prompt [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Anonymus wrote:
> I have the same problem
>
Then I suggest the same solution
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office