Hi Bob

What formulae are being used in each case?

--
Regards
Roger Govier

Bob L wrote:
I have a few spreadsheets that are linked to other workbooks. Everyone
says that you cannot get data from a closed workbook. Here is what I
have. I have workbook called Journal. In that I have cells that have
data in them and are totaled at the bottom of the sheet. I have 4 other
workbooks called Quarter's 1 through 4. Once I put the data in the
journal and save and close it the data is transferred to the appropriate
cells in the workbooks. Even if the journal is closed the quarter still
has the data in the cells. I have another one called Budget. That is
linked to the quarter workbooks. The only way that it shows the totals
in the workbooks is if the Quarter workbooks are open. Why do the
quarter workbooks collect their data from a closed Journal but the
budget will not get its data from the quarter books?