Hi All,

I've run into a bit of a weird problem in a master workbook I'm
creating. In essence, it's a roll-up of about 20 different
multi-departmental metrics, and links to nearly as many sources. Out of all
of these sources, two of them are CSV files converted to Excel format (and
saved as such). When the book autoupdates on opening, it is able to update
all sheets except for those updating from the CSV-converted-XLS
sources--unless the actual sources are opened at that time, I get a table
full of #VALUE! errors... and when I open the related files, it goes back to
the proper values. A key problem lies in the fact that the two sources which
return the bad values are for just one week of data. Each week, there's a
new source for both. So by end of year, I'd be looking at nearly 100 books
I'd have to open in order to properly update... obviously not an option. Has
anyone ever experienced this? I've linked to dozens of books in the past and
never incurred this problem; I suspect it's because these are converted from
..CSV files but I have no idea how to go about fixing it. Any ideas?

Appreciate any help anyone can provide.

Thanks

Jamie