Question for OneNote users

< Next Topic | Back to topic list | Previous Topic >

Posted by Stephen Zeoli
Mar 28, 2007 at 08:06 PM

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.

Posted by Gorski
Mar 28, 2007 at 09:11 PM

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.

Posted by Jack Crawford
Mar 28, 2007 at 09:46 PM

Also woks for me.

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

Jack

Posted by Stephen Zeoli
Mar 28, 2007 at 10:21 PM

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.

Posted by Jack Crawford
Mar 28, 2007 at 11:44 PM

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

Back to topic list