Hi!
I created a worksheet which is linked to two different "source" workbooks to
consolidate data. I am using this workbook for several consolidations (same
format and i just save the changed data under a file "source 1" and "source
2" for then automatically obtaining the sums in my CONSOLIDATION workbook)
and that works fine.
But after consolidating different workbooks and obtaining 3 different
CONSOLIDATED files (which i save under another name after consolidation) for
year1, year2 and year3, the values in those files change as soon as i open
another one!!! I switched off the automatic update and the source files are
in another folder (so Excel can't find them).
Example: I open the new consolidated file year1 and the values are all okay,
i.e. the sums of source1 one and source2. But as soon as i open the workbook
year2 the values in year1 change and the values for year2 seem to be random,
too.

Anyone had this problem before? How to solve it (without changing all cells
to value only manually)?