Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Laura
 
Posts: n/a
Default Tools/Compare and Merge Workbooks - Excel 2003 Pro

Has anyone successfully used the "Compare and Merge Workbooks" option in
"Tools" in Excel 2003 (Professional)?
It is "unselectable" -- new technical term. :-)
I have tried opening one of the workbooks, both workbooks, no workbooks --
the option always appears to be unselectable.
This is not a "disabled item" on my system.
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

AFAIK this is for shared copies of the same workbook only, if you open the
shared workbook then you can select merge workbook but you can only open
copies of the same workbook. When you share the workbook you can allow other
users to change it at the same time. When you do this and open the shared
workbook this option becomes available. However you cannot open for instance
2 non shared workbooks and merge them using this.

Regards,

Peo Sjoblom

"Laura" wrote:

Has anyone successfully used the "Compare and Merge Workbooks" option in
"Tools" in Excel 2003 (Professional)?
It is "unselectable" -- new technical term. :-)
I have tried opening one of the workbooks, both workbooks, no workbooks --
the option always appears to be unselectable.
This is not a "disabled item" on my system.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
why can't I open my Excel data in Excel, but I can as a merge sour legalsec Excel Discussion (Misc queries) 3 January 8th 05 10:38 PM
mail merge from excel Vass Excel Discussion (Misc queries) 3 January 7th 05 05:36 PM
Merge and Center Disabled in Excel 2003 Document Barb Reinhardt Charts and Charting in Excel 4 December 6th 04 05:19 PM
how can i merge 2 workbooks using a formula? John F Excel Worksheet Functions 6 November 23rd 04 05:45 PM
compare and merge workbooks Lost in Excel Excel Worksheet Functions 1 November 23rd 04 02:43 PM


All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"