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

How to paste this down? 3
Embed the same Excel multiple times 0
Paste to excel from word - auto format problem 1
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Pasting HTML script to Excel 2007 converts the cells format to 'General' 0
Linking data in MS Word into Excel 5
Default format type HTML Outlook 2013 0
Merging from an Excel file with graphics 1

Top