Hello db -
The Merge Workbooks feature only works if you have a workbook that is
Shared. It's primary purpose is to allow having separate copies of the same
file modified by different users, then combining the copies into the
original. Then you can either accept or reject the changes made by each of
the users in their respective copies. If you simply want to combine content
from workbook A with workbook B there are other ways to go about it.
If it's a matter of wanting the individual *sheets* from A (source) added as
identical sheets in B (target): Open both files with the source as the
active file & select one or more sheet using Shift+Click or Command+Click on
the tabs of the sheets to be included. Go to Edit> Move or Copy sheet (or
right-click a sheet tab & choose "Move or Copy"), open the top list & select
the target workbook, pick the sheet you want the other sheets positioned
ahead of (use the Create a Copy button if desired), then click OK.
If you actually want content from a sheet in the source added to content on
an existing sheet in the target, the easiest method is to select & Copy the
data from A then Paste to the appropriate location in B.
As far as the Help files, well, they should be a part of any normal
installation. What happens if you select Excel Help from the Help menu? Does
the dialog appear but just not provide the information you're looking for?
If that's the case take a look at the bottom left of the Help window to make
sure Online Help is displayed. The bulk of Help is accessed via the
internet, so if you don't have an active connection Help will be limited.
If Help is completely unavailable you may have to install it from the Office
CD. Is Help available in other Office apps? Take a look in:
HD/Library/Application Support> Microsoft
to see if there is a folder there called HV1.0 & if so that there is a file
called Microsoft Help Viewer within it. Reply back with your findings.
HTH |:>)
Bob Jones
[MVP] Office:Mac
