98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training day courses near kent - Consolidation of several workbooks.
microsoft excel training day courses near kent - Consolidation of several workbooks.
Resolved · Low Priority · Version Standard
Katie has attended:
Excel Advanced course
Consolidation of several workbooks.
If I create a folder which includes workbooks and then workbook which consolidates the other workbooks, can I move this folder to elsewhere on my Pc without disrupting the consolidation (i.e could I copy from a share drive to my personal drive and work on the workbooks and update the consolidation, would the links still work?
RE: consolidation of several workbooks.
Hi Katie,
1) If you copied those files from your share drive, then you are only working on an IMAGE and not the original. You can copy the revised version back on the share drive, to overwrite the original.
2) Links will be updated as you copy them over to your PC.
3) If you MOVE instead of copy, then the originals will no longer be available. Links are still updated and you will be only working with 1 version without a backup.
Hope this helps.
Regards,
Katie
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Creating Quick Column ChartsSelect the information you want to appear in the chart and press F11. This creates a new chart on a seperate worksheet. |