Excel, Copy formulae and paste - Will not paste!!!

  compumac 01 Apr 12
Locked

I have been doing spreadsheets for years and suddenly my mind has gone blank. Problem: The values of 'A, B and C' are totalled in column 'D' I insert a formula in 'D' and it totals A. B and C' I then copy the formula in 'D' downwards and receive the message "Data on the clipboard is not the same shape and size as the selection, do you want to paste the data anyway"

My actual problem is more convoluted than above but has been shown to simplify the situation.

Reason???

  compumac 01 Apr 12

Update: I tried to copy and paste on other tabs on the same spreadsheet with the same result I then opened a fresh spreadsheet and tried the copy and paste within in that - the same result. I looked on the web for others with the same problem and despite there being a fair number of posts relating to the problem there did not appear to be an answer. However I shut down and then restarted Excel and lo and behold all is working as it has done for the past 20+ years!!

How?

  Simsy 02 Apr 12

That is typical of the message you receive if, somewhere in the range(es) concerned, you have some merged cells.

I'd bet next weeks lottery ticket that's where the issue is!

(I must add the caveat that I'm often wrong!)

Regards,

Simsy

  compumac 02 Apr 12

simsy This particular problem was displayed on one spreadsheet that is in use every day and the copied range does not include any merged cells at all. The particular copy and paste data is something that has been done on this spreadsheet has been done for the past eight years without this problem showing.

  Simsy 02 Apr 12

In which case I stand corrected... and have to suspect a corrupted file!

Have you tried it on a different machine, in case it's a machine problem, rather than a file problem?

Regards,

Simsy

  compumac 02 Apr 12

simsy.

I thought it might be a corrupted file, but whilst it was open I created a new spreadsheet and the problem existed within that new spreadsheet. The difficulty is that it has happened just twice, both in the last two or three days and when restarting Excel it does not not reproduce the same problem. I have also copied the data into a fresh spreadsheet and it was OK. But unless the problem is there every time it is nigh impossible to determine the cause.

Advertisement

This thread is now locked and can not be replied to.

Should I upgrade to Windows 10? 8 reasons why you should upgrade to Windows 10... and 2 why you…

We are being sold the ability to spend money we don't have. And we love it

Encore creates eerie effects for Spielberg's new TV show The Whispers

How to use Apple Music in the UK: Complete guide to Apple Music's features

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message