Hello,

I'm hoping to get a little help from one of the other OneNote fans on this site. I recall seeing something, perhaps on the Microsoft web site, about pasting a spreadsheet into ON and having it flow directly into table, but that's not the result I get. When I copy a spreadsheet and paste it into ON, I just get the text and tabs with no table, just as if I'd pasted it into a plain text editor. Am I doing something wrong, or is this the expected result?

Thank you in advance for any insights you can provide.

Steve Z.

Do you have OneNote set to Keep Text Only or Keep Source Formatting? (you'll see that little icon like a clipboard when you paste something which you can click to change from one to the other)

You have to Keep Source Formatting to get the table when pasting from Excel. Works for me.

Also woks for me.

Which version of OneNote are you using? Tables are only in ON 2007.

Jack

Mark and Jack,

Thank you for the responses. I am using OneNote 2007, and I did try the various options in the paste options menu. However, my version of Excel is Office 97... perhaps that is the problem.

Steve Z.

Stephen Zeoli wrote:

However, my version of Excel is Office
97... perhaps that is the problem.

I would expect so. Excel is now in its third iteration since then. Office XP should be available cheaply now that the 2007 version has been released.

Having said that, I can't see any mention of the issue in the OneNote 2007 system requirements.

Jack