View Single Post
  #7   Report Post  
Old August 4th 06, 12:15 AM posted to microsoft.public.excel.misc
SimonCC SimonCC is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 79
Default Links won't update unless files are actually opened

My only guess is that the export file is not the exact proper excel format
even though it has an .xls extension. How about opening one of the exported
files, and save it over as type Microsoft Office Excel Workbook with the same
name. Then close that export file and open your summary report file to see
if it would update. If that doesn't work I don't really know what else to


"BretJacobs" wrote:

The export file is an excel worsksheet (the result of a Crystal Reports
export to excel), and it has an .xls extension.

"SimonCC" wrote:

The export file from Crystal Reports, is it an Excel file? or is it like csv
file and such? I think if it's not an Excel file, it wouldn't recognize the
cell structure until opened.


"BretJacobs" wrote:

Yes I have, and to the other reply, yes the Update dialog box shows when the
file is first opened.

If I try "Edit Links Update Values", with the source files unopened, all
of the values go to #Ref, and from the "Edit, Links" menu, the status shows
"Error: Source not found".

Opening the source workbooks then causes all of the references to update,

The source workbooks are Exports from Crystal Reports, could that have
anything to do with it?

"Michael" wrote:


In your linked work book, have you tried

Edit Links Update Values



"BretJacobs" wrote in message
Having a tough time working with a linked file. I created a summary
that links to multiple unique separate worksheets. Links will not
(even if all varieties of F9 are tried [shift, ctrl, etc]) unless the
individual files are open also. All files are stored on my laptop's hard
drive, and are not mapped to any network drive.

I know that is NOT the way the links are supposed to work, as I have used
links many many times before. However, is there some trick to Office 2003
that I am missing?