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