Merged Cell Error
From: Kent (anonymous_at_discussions.microsoft.com)
Date: 02/19/04
- Next message: Debra Dalgleish: "Re: Pivottable PageField Dropdowns Disappear"
- Previous message: Frank Kabel: "Re: Copying Cell Values"
- In reply to: Tracey: "Merged Cell Error"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 19 Feb 2004 15:17:49 -0800
Try the same thing to a new blank workbook. If it's the
same result the problem may actually lie with the Access
side. You could then try to copy and paste to a new book a
column at a time to find the troublemaker.
Ok, if it works in a clean blank book, you are back to
selecting the entire area the Access data covers and
checking the Formt->Cells->Alignment has no hint of a
check in the "merge cells" checkbox.
Kent@CanHelpYou.com
-----------------------------------------------------------
-----------
Every member of the CanHelpYou team holds at least a
Microsoft Level 1 Excel certification. In addition, we
have experts in PowerPoint, Word and other products such
as IIS, SQL Server 2000, network connectivity.
>-----Original Message-----
>When copying columns of data from Access and pasting into
Excel, I receive an error stating "cannot change part of a
merged cell" and I'm not allowed to paste. But the cells
are not marked as merged! What do I do?
>.
>
- Next message: Debra Dalgleish: "Re: Pivottable PageField Dropdowns Disappear"
- Previous message: Frank Kabel: "Re: Copying Cell Values"
- In reply to: Tracey: "Merged Cell Error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
