Copying Worksheets

[Phil Wales]

When i try to copy a worksheet which has a large number of rows by using the
"right mouse button then move or copy function buttons "

1) It moves it ok into a brand new workbook. but

2) When i try to move it to a worksheet that has other sheets of data
already on it it says "Can not move as the new destination does not contain
enough rows or columns heading for the source destination"

Is there a way of increasing the default number of rows in my worksheets or
another way round this.. I don't want to just use the copy paste function
as not all the formulas copy correctly.

thanks in advance..

 

[Dave Peterson]

It sounds like you're copying a worksheet from a workbook that's been saved in
xl2007 format (1M rows x 16k columns) to a workbook that's not converted to
xl2007 format (64k rows x 256 columns).

Save the receiving workbook in xl2007 format. Close it and reopen it. Check to
see the number of rows. If you see one million, then try copying the worksheet.

 

[Phil Wales]

Thanks Dave- that's great - will save me some time