Is Paste Special HTML broken in Excel/Office 2007?

N

new2money

In older versions of Office, I was able to copy/paste HTML tables into Excel
(and Word), and have the format preserved... most importantly, the data
pasted in rows and columns exactly as seen in the HTML version.

In Office 2007, however, HTML tables paste in one cell in Excel (or one long
text string, in Word). Even if I use Paste Special and choose HTML, all the
data ends up in one cell and plain text. This is happening in Excel and Word
2007. Powerpoint 2007 keeps the table format but doesn't keep the formatting
(colors, fill, etc.).

Any suggestions?
 
F

FinRazel

rather than copy/pasting into excel, try creating a web query (Data tab-> get
external data -> from the web) then go to the website you want in the browser
that opens and click the table you want. I don't think this will preserve
the formatting, but at least you'll avoid pasting everything into one cell
 

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

Excel 2007 and Paste Special with HTML and data from the web 3
No "Comments" in Paste Special 5
Copy paste special 5
Paste Special Help (Excel 2003) 5
Excel 2007 Problem Paste/Enter Key 0
Copy-Paste Chart into Word from Excel 2007 3
Paste Special Values 2
Paste Special Formula Multiply feature doesn't work anymore 2

Top