Spreadsheet "A" runs a macro that opens spreadsheet "B". It gets data and
then closes "B" without saving (other spread sheets access "B" and deposit
data). A, then uses data for report.

However, when "B" opens it runs its own macros (the code doesn't ask it to
do this) and this creates a mess.