Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 1st 04, 03:06 PM
Barb Reinhardt
 
Posts: n/a
Default Merge and Center Disabled in Excel 2003 Document

I have copied several tables from Word 2003 into Excel 2003 and I am no
longer able to merge and center within the document. What disabled that
option and how do I re-enable it?

Thanks in advance,
Barb Reinhardt



  #2   Report Post  
Old December 1st 04, 03:12 PM
Barb Reinhardt
 
Posts: n/a
Default

I just found that if the Workbook is shared, merge is not allowed. The
document is currently shared. Is this the problem?

"Barb Reinhardt" wrote in message
...
I have copied several tables from Word 2003 into Excel 2003 and I am no
longer able to merge and center within the document. What disabled that
option and how do I re-enable it?

Thanks in advance,
Barb Reinhardt




  #3   Report Post  
Old December 1st 04, 03:18 PM
Barb Reinhardt
 
Posts: n/a
Default

I'm also finding that in the same document, when I enter an HTML URL, it
won't be displayed as a hot link. Is this also because the document is
shared?

"Barb Reinhardt" wrote in message
...
I have copied several tables from Word 2003 into Excel 2003 and I am no
longer able to merge and center within the document. What disabled that
option and how do I re-enable it?

Thanks in advance,
Barb Reinhardt




  #4   Report Post  
Old December 5th 04, 07:54 PM
Jon Peltier
 
Posts: n/a
Default

Barb -

Shared workbooks suffer by having many normal features suppressed. You can't put a
chart into one, either, or delete a sheet. I've always tried to avoid sharing of
workbooks.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Barb Reinhardt wrote:

I'm also finding that in the same document, when I enter an HTML URL, it
won't be displayed as a hot link. Is this also because the document is
shared?

"Barb Reinhardt" wrote in message
...

I have copied several tables from Word 2003 into Excel 2003 and I am no
longer able to merge and center within the document. What disabled that
option and how do I re-enable it?

Thanks in advance,
Barb Reinhardt






  #5   Report Post  
Old December 6th 04, 05:19 PM
Barb Reinhardt
 
Posts: n/a
Default

Jon,

I discovered a lot of this while playing around with the document. My
original goal was to set up a workbook so that several individuals in the
office could update their personal capability information without having to
wait for the document to be available. I had no plans for putting in
charts, but I discovered that if we weren't using the workbook purely for
data entry, it wasn't of much use.

Thanks for the additional feedback.

Barb

"Jon Peltier" wrote in message
...
Barb -

Shared workbooks suffer by having many normal features suppressed. You

can't put a
chart into one, either, or delete a sheet. I've always tried to avoid

sharing of
workbooks.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Barb Reinhardt wrote:

I'm also finding that in the same document, when I enter an HTML URL, it
won't be displayed as a hot link. Is this also because the document is
shared?

"Barb Reinhardt" wrote in message
...

I have copied several tables from Word 2003 into Excel 2003 and I am no
longer able to merge and center within the document. What disabled

that
option and how do I re-enable it?

Thanks in advance,
Barb Reinhardt










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



All times are GMT +1. The time now is 02:44 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017