Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Rebecca
 
Posts: n/a
Default Frustrating Problem

Hi. I'm using Excel 2003. I have a worksheet where I am trying to insert
data from a Word 2003 document. This long Word file consists of data in
three columns. When I copied and pasted the data into the Excel worksheet,
the data pasted neatly -- except for the last 60 rows or so. No matter how
hard I try to copy and paste the remainder, I keep getting an error message
saying this data cannot be inserted. This is incredibly frustrating, though
I'm sure there is a simple explanation, but being new to Excel I am at a loss
as to why this is happening. Could someone please give me a list of possible
reasons why this data cannot be inserted? I have not exceeded the Excel row
limit. I would deeply appreciate your help in this matter.
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

Is there room for it? Lets say you insert starting at row 5 and there are 20
rows of data to insert.
Does your worksheet have data in any of rows 6 to 25?
Try selecting these row and use Edit|Clear-All
Tell us if this helped.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Rebecca" wrote in message
...
Hi. I'm using Excel 2003. I have a worksheet where I am trying to insert
data from a Word 2003 document. This long Word file consists of data in
three columns. When I copied and pasted the data into the Excel
worksheet,
the data pasted neatly -- except for the last 60 rows or so. No matter
how
hard I try to copy and paste the remainder, I keep getting an error
message
saying this data cannot be inserted. This is incredibly frustrating,
though
I'm sure there is a simple explanation, but being new to Excel I am at a
loss
as to why this is happening. Could someone please give me a list of
possible
reasons why this data cannot be inserted? I have not exceeded the Excel
row
limit. I would deeply appreciate your help in this matter.



  #3   Report Post  
JulieD
 
Posts: n/a
Default

Hi Rebecca

do you mean "three columns" as in Format / Columns in Word or do you mean a
three column table? also what do you mean by "long" - 5 pages - 500
pages???

Cheers
JulieD

"Rebecca" wrote in message
...
Hi. I'm using Excel 2003. I have a worksheet where I am trying to insert
data from a Word 2003 document. This long Word file consists of data in
three columns. When I copied and pasted the data into the Excel
worksheet,
the data pasted neatly -- except for the last 60 rows or so. No matter
how
hard I try to copy and paste the remainder, I keep getting an error
message
saying this data cannot be inserted. This is incredibly frustrating,
though
I'm sure there is a simple explanation, but being new to Excel I am at a
loss
as to why this is happening. Could someone please give me a list of
possible
reasons why this data cannot be inserted? I have not exceeded the Excel
row
limit. I would deeply appreciate your help in this matter.



  #4   Report Post  
Mark Keith
 
Posts: n/a
Default

Rebecca wrote:
Hi. I'm using Excel 2003. I have a worksheet where I am trying to insert
data from a Word 2003 document. This long Word file consists of data in
three columns. When I copied and pasted the data into the Excel worksheet,
the data pasted neatly -- except for the last 60 rows or so. No matter how
hard I try to copy and paste the remainder, I keep getting an error message
saying this data cannot be inserted. This is incredibly frustrating, though
I'm sure there is a simple explanation, but being new to Excel I am at a loss
as to why this is happening. Could someone please give me a list of possible
reasons why this data cannot be inserted? I have not exceeded the Excel row
limit. I would deeply appreciate your help in this matter.

..
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Array Formulas and ISNUMBER Henrik Excel Worksheet Functions 1 February 10th 05 12:31 AM
Freeze Pane problem in shared workbooks JM Excel Discussion (Misc queries) 1 February 1st 05 12:04 AM
Row Autofit problem Excel 2003 Matthias Klaey Excel Discussion (Misc queries) 0 January 19th 05 05:33 PM
Formatting Cell problem Jacob Excel Discussion (Misc queries) 2 December 4th 04 09:33 AM
Paper Tray selection Problem, Michael Hoffmann Excel Discussion (Misc queries) 4 December 3rd 04 09:08 PM


All times are GMT +1. The time now is 01:25 AM.

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

About Us

"It's about Microsoft Excel"