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?