A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Too Few Rows to copy sheet to another book



 
 
Thread Tools Display Modes
  #1  
Old April 19th, 2010, 04:21 PM posted to microsoft.public.excel.worksheet.functions
snowboardbaltimore
external usenet poster
 
Posts: 4
Default Too Few Rows to copy sheet to another book

What is the deal with the error message that I have too few rows to copy/
move one of my worksheets to another worksheet using the right-click
function? Is there a way to get around this or to resolve the problem? And to
top it off, when I attempt to copy and past the data to another sheet, I
receive an error message that excel must now quit!

Is there any way possible to get this data copied over to another sheet
somehow?
  #2  
Old April 19th, 2010, 04:41 PM posted to microsoft.public.excel.worksheet.functions
Pete_UK
external usenet poster
 
Posts: 8,780
Default Too Few Rows to copy sheet to another book

Are you trying to copy it from an .xlsx file (with 1,000,000+ rows) to
an .xls file (with 65,532 rows)?

Hope this helps.

Pete

On Apr 19, 4:21*pm, snowboardbaltimore
wrote:
What is the deal with the error message that I have too few rows to copy/
move one of my worksheets to another worksheet using the right-click
function? Is there a way to get around this or to resolve the problem? And to
top it off, when I attempt to copy and past the data to another sheet, I
receive an error message that excel must now quit!

Is there any way possible to get this data copied over to another sheet
somehow?


  #3  
Old April 19th, 2010, 05:36 PM posted to microsoft.public.excel.worksheet.functions
snowboardbaltimore
external usenet poster
 
Posts: 4
Default Too Few Rows to copy sheet to another book

No, I am not. it is an xls file to xls file. I formatted all of the workbooks
to be compatable excel 97-2003 compatable even though I am running 2007.

"Pete_UK" wrote:

Are you trying to copy it from an .xlsx file (with 1,000,000+ rows) to
an .xls file (with 65,532 rows)?

Hope this helps.

Pete

On Apr 19, 4:21 pm, snowboardbaltimore
wrote:
What is the deal with the error message that I have too few rows to copy/
move one of my worksheets to another worksheet using the right-click
function? Is there a way to get around this or to resolve the problem? And to
top it off, when I attempt to copy and past the data to another sheet, I
receive an error message that excel must now quit!

Is there any way possible to get this data copied over to another sheet
somehow?


.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:07 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.