ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   merge workbooks (https://www.excelbanter.com/excel-worksheet-functions/122526-merge-workbooks.html)

FYF

merge workbooks
 
Whilel using the Microsoft Office Specialist Study Guide Office 2003 Edition:
I wanted to try using the €śMerge Workbooks€ť (ref. page 393 & 394) while in
my excel program from my home program and the program at work. Under €śTools€ť
Menu the €śCompare & Merge Documents€ť is shaded and I am unable to use or
practice with. I tried to use the both instructions showing in the MOS Excel
2003 Expert Exam and instructions listed in the HELP menu in Excel program
both instructions are little different. But neither function.
Thank You
fyf

Gord Dibben

merge workbooks
 
Compare and Merge is only available if the workbook is shared and you want to
merge multiple versions of same workbook.

See help on "merge workbooks".


Gord Dibben MS Excel MVP

On Wed, 13 Dec 2006 06:53:00 -0800, FYF wrote:

Whilel using the Microsoft Office Specialist Study Guide Office 2003 Edition:
I wanted to try using the “Merge Workbooks” (ref. page 393 & 394) while in
my excel program from my home program and the program at work. Under “Tools”
Menu the “Compare & Merge Documents” is shaded and I am unable to use or
practice with. I tried to use the both instructions showing in the MOS Excel
2003 Expert Exam and instructions listed in the HELP menu in Excel program
both instructions are little different. But neither function.
Thank You
fyf



FYF

merge workbooks
 
Does the File need to be sharded workbook before distributation to employees.
Was able to get two files (same info on both) into the SHARED Workbook but
could not merge. STOP BOX states: Copies made from same shared wkbk, & must
all maintain the change history for a sufficient amount of time." When I ask
for Help or OK radio buttons: Help pop-up window is blank (no info showing).

"Gord Dibben" wrote:

Compare and Merge is only available if the workbook is shared and you want to
merge multiple versions of same workbook.

See help on "merge workbooks".


Gord Dibben MS Excel MVP

On Wed, 13 Dec 2006 06:53:00 -0800, FYF wrote:

Whilel using the Microsoft Office Specialist Study Guide Office 2003 Edition:
I wanted to try using the €śMerge Workbooks€ť (ref. page 393 & 394) while in
my excel program from my home program and the program at work. Under €śTools€ť
Menu the €śCompare & Merge Documents€ť is shaded and I am unable to use or
practice with. I tried to use the both instructions showing in the MOS Excel
2003 Expert Exam and instructions listed in the HELP menu in Excel program
both instructions are little different. But neither function.
Thank You
fyf





All times are GMT +1. The time now is 07:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com