Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

"Cannot change part of merged cell"

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ExcelHelpNeeded - 06 Jul 2006 14:00 GMT
Need help!

I have created a pivot table in Excel and now trying to add another field
that appears in the field list.  When I drag it over the pivot table to drop
it, I get this error: "cannot change part of merged cell", I did not receive
this error message for the other fields that I had selected.

Please help.  Thanks in advance.
silver - 06 Jul 2006 18:33 GMT
ExcelHelpNeeded Wrote:
> Need help!
>
[quoted text clipped - 7 lines]
>
> Please help.  Thanks in advance.

Is it indeed merged? Click on the cell you're wanting to paste to, go
to Format Cells then Alignment and uncheck the Merge box.

Signature

silver


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.