excel course - Consoldiation of workbooks

Hi Katie,

Thanks for your question.

When you consolidate several workbooks, both source & consolidated files don't necessary have to be stored under the same folder.

You can also print out the worksheet in formula view to see each file path.

Regards,

Katie Woo
Microsoft Certified Trainer