Microsoft Office Forums Importing Data from Excel - Format of table messed up in Word Table

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-13-2015, 01:20 PM
epsulliv epsulliv is offline Importing Data from Excel - Format of table messed up in Word Table Mac OS X Importing Data from Excel - Format of table messed up in Word Table Office for Mac 2011
Novice
Importing Data from Excel - Format of table messed up in Word Table
 
Join Date: Aug 2015
Posts: 4
epsulliv is on a distinguished road
Angry Importing Data from Excel - Format of table messed up in Word Table

I have an .xls file that contains 3 long columns of data - "Item #" , "Description", and "Quick Ship". The goal is to take this data and insert into an already formatted Word table.

So, I select all the data in the Word table, and I paste special (Unformatted text is the only option that will work, the others lock and freeze up) the data from excel.



Everything looks fine, until I scroll down and notice the formatting (see picture) is wonky for a few of the rows throughout. The picture shows two pages, the first is exactly how I wish everything to look, and the second shows the formatting issue. Any idea how to fix that? It is driving me nuts!

Update: I noticed the issue was occurring with the rows of data that did not contain any description, so in Excel I painfully scrolled through that column of data and filled in "No Description" in the blank cells. I recopied the updated data but the issue was still there, only this time, like in the picture, the description cell was filled in just off kilt from the rest of the table.
Reply With Quote
  #2  
Old 08-13-2015, 02:30 PM
JimP JimP is offline Importing Data from Excel - Format of table messed up in Word Table Windows 8 Importing Data from Excel - Format of table messed up in Word Table Office 2013
Experienced User
 
Join Date: Jun 2010
Location: Virginia Beach, VA
Posts: 742
JimP will become famous soon enough
Default

There was no picture attached...
Reply With Quote
  #3  
Old 08-13-2015, 07:41 PM
epsulliv epsulliv is offline Importing Data from Excel - Format of table messed up in Word Table Mac OS X Importing Data from Excel - Format of table messed up in Word Table Office for Mac 2011
Novice
Importing Data from Excel - Format of table messed up in Word Table
 
Join Date: Aug 2015
Posts: 4
epsulliv is on a distinguished road
Default

Not sure why that image didn't link.

Try this - http://imgur.com/HVYJCFk

This is still drivin me mad! I STILL NEED HELP- just not a clue what is going on with the formatting. Anybody out there? I'll buy you a cheap dinner, seriously!
Reply With Quote
  #4  
Old 08-16-2015, 10:21 PM
macropod's Avatar
macropod macropod is online now Importing Data from Excel - Format of table messed up in Word Table Windows 7 64bit Importing Data from Excel - Format of table messed up in Word Table Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,664
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

You say you pasted using 'unformatted text', but that paste option doesn't produce (or fill) a table. The only way you'd get a table out of Excel data pasted as 'unformatted text' is if you then used Word's 'convert to table' process, in which case (assuming you used Word's defaults), I'd expect to see the entire table displaying three equal-width columns all the way down, including for empty cells.

As for Word freezing, that suggests you have a faulty Office installation, which will require uninstalling & reinstalling to fix.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 08-17-2015, 06:41 AM
epsulliv epsulliv is offline Importing Data from Excel - Format of table messed up in Word Table Mac OS X Importing Data from Excel - Format of table messed up in Word Table Office for Mac 2011
Novice
Importing Data from Excel - Format of table messed up in Word Table
 
Join Date: Aug 2015
Posts: 4
epsulliv is on a distinguished road
Default

I went through the paste special options and the unformatted text was the only one that worked! I just tried (again, I've tried everything!!) copying one column of data to word. Then I click 'Convert to Table' - hoping that I could then add an additional two columns but the problem is I have 12,751 rows of data, and the dialog box prompts I can only have a MAX of 4000.

As for pasting 'unformatted text' - it DID work, somehow, someway it filled the existing table with the new data. It just left this dreadful formatting error in a few spots.
Reply With Quote
  #6  
Old 08-19-2015, 06:49 PM
macropod's Avatar
macropod macropod is online now Importing Data from Excel - Format of table messed up in Word Table Windows 7 64bit Importing Data from Excel - Format of table messed up in Word Table Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,664
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Why are you trying to insert 12,751 rows of data into Word anyway? Word really isn't designed for such large tables and its performance will really suffer with one that big!

Depending on the tools available on the Mac, you may be able to address the column issue via the 'Distribute Columns' tool, which is supposed to make all columns the same width.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
Old 08-24-2015, 07:29 AM
epsulliv epsulliv is offline Importing Data from Excel - Format of table messed up in Word Table Mac OS X Importing Data from Excel - Format of table messed up in Word Table Office for Mac 2011
Novice
Importing Data from Excel - Format of table messed up in Word Table
 
Join Date: Aug 2015
Posts: 4
epsulliv is on a distinguished road
Default

Yes Mac you're right - I am asking way too much from MS Word!

I have decided to take a different approach - breaking the initial data up in to sub tables and so on..

Thanks for the help! Case closed.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
font of excel table gets messed up in visio 2013 Strumpfhose Visio 0 10-01-2014 02:40 AM
Importing Data from Excel - Format of table messed up in Word Table VBA Code to take data from a table in word document and place it in a summary table VBLearner Word VBA 1 03-09-2014 08:42 PM
Copy Excel data into an existing Word Table JJG Word 1 12-18-2013 05:41 PM
Importing Data from Excel - Format of table messed up in Word Table data from Excel into Word table ragesz Word Tables 1 09-29-2013 06:14 PM
Importing Data from Excel - Format of table messed up in Word Table Excel data to Word table Jaymond Flurrie Word VBA 2 02-27-2011 07:42 PM


All times are GMT -7. The time now is 06:24 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft