Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training day courses near kent - Consolidation of several workbooks.
|
|
|
The UK's most regular 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. |
microsoft excel training day courses near kent - Consolidation of several workbooks.
Resolved · Low Priority · Version Standard
Reply Wed 16 Jan 2008, 09:03Delegate Katie said...
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?
For upcoming training course dates see: Pricing & availability
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
|