A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

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 » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Difficulty pasting Excel data into Word table only in XP versions



 
 
Thread Tools Display Modes
  #1  
Old February 28th 05, 01:33 AM
Digitonomy
external usenet poster
 
Posts: n/a
Default Difficulty pasting Excel data into Word table only in XP versions

I frequently update a set of data in Excel, reorder it and so forth, then cut
and paste those cells into a corresponding Word file. The table in Word has
several columns which are tightly spaced to take up half the page, and the
document itself has two columns, so that the table continues from the bottom
of the left side of the page to the top of the right side of the page.

Because of the snug fit of the data on the page, I occasionally have to
adjust the columns or fontsize slightly in Excel, and repaste into Word to
ensure that most cells take up only one line. By and large, though, the
Excel column widths have now been carefully set up to fit just right when the
data is pasted into Word.

A few months ago I switched from Office 97 to Office XP and Office 2003.
Now when I paste the Excel data into Word, the table never fits properly.
The main problem seems to be that margins are included at the left and right
side of every cell/column. I can laboriously go through and tweak the
margins, but it's still almost impossible to get it to look right.

The alternative is that I can take those very same Excel and Word files to
the machine that still runs Office 97, and copy the cells from the Excel file
I had modified in Office XP to the Word document I had recently modified in
Office XP. It works fine. So the problem is not with the files themselves,
but rather with the assumptions the newer programs make during this procedure.

It is nice that I can edit the Excel files from any machine, and that I can
print the Word document from any machine. But to paste the data from the
Excel to the Word document properly, I need to be using Office 97.

Any suggestions how i can overcome this obstacle?

Thanks.
Ads
 




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 On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
letters - ask/fillin Caroline H New Users 2 February 25th 05 09:19 PM
How do I extend an Excel table to another page in Word? Stubbler1969 Tables 1 February 1st 05 01:06 PM
Boiletplates from Word Perfect linda Microsoft Word Help 1 January 28th 05 06:37 PM
How do I create & merge specific data base & master documents? maggiev New Users 2 January 13th 05 12:30 AM
Excel Link: Adding rows in Excel does not add cells in Word Jameslp Tables 2 December 9th 04 08:18 PM


All times are GMT +1. The time now is 05:04 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.