#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Copy Paste problem

I have received a workbook from a colleague and require to copy cells from it
into another workbook. I got the "copy and paste areas differ" message but I
had selected a single destination cell. I have even tried to copy one cell,
not a merged one, into the other workbook to no avail.
I can paste the copied data into other cells in the same workbook. If I open
two copies of excel and put one workbook in each I have no problem. There are
no macros in either workbook just colour formatting. The cells contain values
not formulae. If I open a new workbook and try to paste to that the problem
remains. This workbook I have received and want to copy from seems to have
some strange characteristic.

We have tried it on two totally different PCs - no difference. I am using
Excel 2003 SP3 on WIndows XP Professional.

Anyone any ideas?
Thanks Ian
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Copy Paste problem




Sounds like you've analyzed it pretty well.........I have no clue what could
be wrong.

But for expediency,
"Ian_Add" wrote:
If I open two copies of excel and put one workbook in each I have no

problem.

I would just do that to the entire workbook and SaveAs a new filename and
check it........if the problem is gone, do as you will with the old file.

Vaya con Dios,
Chuck, CABGx3




I have received a workbook from a colleague and require to copy cells from it
into another workbook. I got the "copy and paste areas differ" message but I
had selected a single destination cell. I have even tried to copy one cell,
not a merged one, into the other workbook to no avail.
I can paste the copied data into other cells in the same workbook. If I open
two copies of excel and put one workbook in each I have no problem. There are
no macros in either workbook just colour formatting. The cells contain values
not formulae. If I open a new workbook and try to paste to that the problem
remains. This workbook I have received and want to copy from seems to have
some strange characteristic.

We have tried it on two totally different PCs - no difference. I am using
Excel 2003 SP3 on WIndows XP Professional.

Anyone any ideas?
Thanks Ian

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Copy Paste problem

Unfortunately we are not in control of the offending workbook which is
updated monthly and sent out. I expect that we can get them to fix it if we
can describe the solution.

"CLR" wrote:




Sounds like you've analyzed it pretty well.........I have no clue what could
be wrong.

But for expediency,
"Ian_Add" wrote:
If I open two copies of excel and put one workbook in each I have no

problem.

I would just do that to the entire workbook and SaveAs a new filename and
check it........if the problem is gone, do as you will with the old file.

Vaya con Dios,
Chuck, CABGx3




I have received a workbook from a colleague and require to copy cells from it
into another workbook. I got the "copy and paste areas differ" message but I
had selected a single destination cell. I have even tried to copy one cell,
not a merged one, into the other workbook to no avail.
I can paste the copied data into other cells in the same workbook. If I open
two copies of excel and put one workbook in each I have no problem. There are
no macros in either workbook just colour formatting. The cells contain values
not formulae. If I open a new workbook and try to paste to that the problem
remains. This workbook I have received and want to copy from seems to have
some strange characteristic.

We have tried it on two totally different PCs - no difference. I am using
Excel 2003 SP3 on WIndows XP Professional.

Anyone any ideas?
Thanks Ian

  #4   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Copy Paste problem


"Ian_Add" wrote:

I expect that we can get them to fix it if we
can describe the solution.


Well, if you can't, I would just do as I suggested and use THAT one as your
working copy each month. It could be set up with macros and done
automatically.

Vaya con Dios,
Chuck, CABGx3


"Ian_Add" wrote:

Unfortunately we are not in control of the offending workbook which is
updated monthly and sent out. I expect that we can get them to fix it if we
can describe the solution.

"CLR" wrote:




Sounds like you've analyzed it pretty well.........I have no clue what could
be wrong.

But for expediency,
"Ian_Add" wrote:
If I open two copies of excel and put one workbook in each I have no

problem.

I would just do that to the entire workbook and SaveAs a new filename and
check it........if the problem is gone, do as you will with the old file.

Vaya con Dios,
Chuck, CABGx3




I have received a workbook from a colleague and require to copy cells from it
into another workbook. I got the "copy and paste areas differ" message but I
had selected a single destination cell. I have even tried to copy one cell,
not a merged one, into the other workbook to no avail.
I can paste the copied data into other cells in the same workbook. If I open
two copies of excel and put one workbook in each I have no problem. There are
no macros in either workbook just colour formatting. The cells contain values
not formulae. If I open a new workbook and try to paste to that the problem
remains. This workbook I have received and want to copy from seems to have
some strange characteristic.

We have tried it on two totally different PCs - no difference. I am using
Excel 2003 SP3 on WIndows XP Professional.

Anyone any ideas?
Thanks Ian

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
Copy and paste problem Germano Excel Discussion (Misc queries) 1 August 24th 07 12:45 PM
Copy/ Paste Problem DanielSP Setting up and Configuration of Excel 4 January 25th 07 02:42 AM
Copy/Paste Problem Seti Excel Worksheet Functions 0 August 31st 06 05:10 PM
copy paste problem? Neil22 Excel Discussion (Misc queries) 5 January 10th 06 05:32 PM
Excel cut/Paste Problem: Year changes after data is copy and paste Asif Excel Discussion (Misc queries) 2 December 9th 05 05:16 PM


All times are GMT +1. The time now is 10:19 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"