I have seen many issues about what formulas to use if you want to link to a closed workbook, but all i need is to copy the exact data. I haven't seen that topic.

I have been using the equal sign (=) to copy the exact data from several workbooks to a master workbook. If the workbooks are open, everything works fine. If only the master workbook is open, the links say they are "ok", but some of the data gives me an #N/A error. It seems to be completely random what data copies over and what data doesn't.

here is an example of one of the cells...

=[Machinist.xls]Monday'!F23

Anyone else have a similiar issue?