Pasting grid problems with Win 10

[jimbokea]

Hi
Have a look at the attached file "example of misalignment" on tab 'checksheet'
This was copied from another file and pasted on here.
Here it has pasted a new grid over everything
As a result nothing appears on the next tabs
Usually it just fills the grid showing underneath (as in file 'as it should look')
I have win 7 and cannot duplicate this problem (mine works as it should)
The people having the problem have win 10
Is this a win 10 problem or something in the settings
Cheers Jim

[jimbokea]

note - the file the original was copied from was closed before the new file was opened and pasted.
I tried this on win 7 and had no problem with it. It still worked properly.
They found if the didn't closed the original file it all worked properly.
Cheers Jim

[jimbokea]

Further info - The names were highlighted and copied on the original sheet ( just ordinary copy) and then pasted normally on to the other sheet.
It appears to have come across as an object or picture that can be highlighted and deleted.

[jimbokea]

Stranger things
My wife has just got a computer with win 10 professional and I tried to duplicate the problem 2 other people were having as described.
But it worked perfectly so I have no idea why they are having the problem.
cheers Jim

[jimbokea]

ok - SO 479 VIEWS BUT NO REPLIES FROM ANYONE ( EXCEPT ME). Has anyone been able to duplicate the problem. I know of 2 local people that had the same problem.
Please advise. cheers Jim

[Zizi64]

The pasted object is an embedded spreadsheet (a spreadsheet on a sheet), but not a simple pasting of the data and formatting properties of the copied cells. Try it by a double clicking on the pasted area.

I think, you need to choose an another method to transfer the data.

What you want to copy really? The data only, or the formatting properties, and the formulas, and the formatting properties together?


And you must WRITE your macros (based on the API functions) instead of the recording the macros - if you want work to more efficiently with the macros.

[John_Ha]

ok - SO 479 VIEWS BUT NO REPLIES FROM ANYONE ( EXCEPT ME). Has anyone been able to duplicate the problem. I know of 2 local people that had the same problem.
Please advise. cheers Jim

You have no right to an answer - everyone here is an unpaid volunteer user just like you.