excel course - consoldiation workbooks

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course - Consoldiation of workbooks

excel course - Consoldiation of workbooks

resolvedResolved · Low Priority · Version Standard

Katie has attended:
Excel Advanced course

Consoldiation of workbooks

If I want to consolidate several workbooks, do they all need to be saved in the same folder (including the 'consolidation' workbook?

RE: 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

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Paste with Live Preview in Excel 2010

Did you know you can preview what you are about to paste? Here's how to do it.

Copy what you are about to paste
Position the cursor where you want to paste
Right click to display the shortcut menu
Place the cursor over the Paste Options and this will give you a preview of the what you are about to paste.

View all Excel hints and tips


Server loaded in 0.11 secs.