moving worksheets

  • Thread starter Thread starter house boy
  • Start date Start date
H

house boy

i have office 2007.

Ever since i installed this I can't move worksheets from spreadsheet to ss.
I get an error message saying that the destination worksheet has fewer rows
and columns. This function worked effortlessly in office 2003. What gives.
My operating sys is vista home premium!
 
You are getting that message because you're trying to move an Excel07
worksheet with over 1M rows into an earlier version that only supports 65
thousand rows.

If you make sure that both workbooks are in the same file format you'll have
no trouble. Somewhere there is a setting in 2007 to create new workbooks in
compatibility mode - meaning they'll only have 65k rows and 256 cols. If
that's not an issue, it may eliminate the issue in the future.
 
Thanks Duke. I guess I'm still struggling. I saved both spreadsheets as
excell macro enabled worksheets and still have the same problem. Can you
expand on the compatibility mode a little more?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I get an error message while copying worksheets between workbooks 1
Copy or Move a spreadsheet 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Copying Worksheets 2
Increasing columns 1
Excel 2007 Move or Copy worksheet 2
Copy sheet to different workbook sizing error message 2
move a worksheet from one workbook to another 1

Back
Top