Pasting ON table into Excel: Not possible? Jonathan 10/27/2008 8:20:02 AM A couple of searches in the Help files for both Excel and OneNote -- and several searches herein this forum turn up no guidance on how to paste a OneNote table into Excel. I was sure I'd seen Ben Shorr and Rainald T. write here about working with info in tables in OneNote that would have to go "out to Excel" for math, functions, formatting, sorting, etc., after creation in OneNote. I just assumed it was pasted into Excel. I can't make that work. I tried importing. I just want to do some calculation: addition of a column. Looks like you can't do it. Surprising. As a side note... it was really annoying that there was nothing on this subject in either program's Help files, which are easy for Microsoft to change as they learn what questions are not answered (reading these forums would be a great source of additions to the Help files!)

Re: Pasting ON table into Excel: Not possible? "Rainald Taesler" <taesler[ at ]gmx.de> 10/27/2008 3:22:37 PM Jonathan wrote: [Quoted Text] > A couple of searches in the Help files for both Excel and OneNote > -- and several searches herein this forum turn up no guidance on > how to paste a OneNote table into Excel. I was sure I'd seen Ben > Shorr and Rainald T. write here about working with info in tables > in OneNote that would have to go "out to Excel" for math, > functions, formatting, sorting, etc., after creation in OneNote. I > just assumed it was pasted into Excel. I can't make that work. I > tried importing. I just want to do some calculation: addition of a > column. Looks like you can't do it. Surprising. Surprising indeed. I can not remember having g posted on this subject. But I just tried it out once more. Worked pretty fine. Way to go: 1.) mark *all* cells in ON, copy them to the clipboard (Ctrl+C or Copy-icon); 2.) Open excel, click on the upper left cell (A:1); 3.) Paste from the clipboard That's all. Excel is that clever that it even recognizes the type data and formats the cells (numeric values right justified). > As a side note... it was really annoying that there was nothing on > this subject in either program's Help files, which are easy for > Microsoft to change as they learn what questions are not answered > (reading these forums would be a great source of additions to the > Help files!) AFAICS the Help-files are a very special subject :-( :-( Mostly they are written far ahead of finalizing the application. And so most often the Help just is not up-to-date. And over the years I have hardly ever seen an update. No "Service Packs"/Patches for the HLP {siiigh}. And what is added on the website happens more or less at random :-( Rainald

Re: Pasting ON table into Excel: Not possible? Jonathan 10/27/2008 5:05:08 PM "Rainald Taesler" wrote: [Quoted Text] > Surprising indeed. > But I just tried it out once more. Worked pretty fine. > Way to go: > 1.) mark *all* cells in ON, copy them to the clipboard (Ctrl+C or > Copy-icon); > 2.) Open excel, click on the upper left cell (A:1); > 3.) Paste from the clipboard Yes, Rainald, this is just the way I expected it would work. I get a "message box" that says, "Microsoft Office Excel cannot paste the data." No error code. I tried matching the cell number and orientation as a se;lection in Excel before pasting. I use Excel2007 and Vista Business on this Lenovo machine. I should try this with Office2007 on my WinXP home desktop and see if it happens there. Help Files: You and I are in agreement, then. It's embarrassing -- I think -- that this method, which avoids the old costs of printing large numbers of manuals, is not used to advantage by the major (all?) software companies. The first one that creates and feeds truly dynamic (growing, edited) on-line Help files is going to increase the power of their brand. A lot. I used to work in the manual-printing business... > > AFAICS the Help-files are a very special subject :-( :-( > Mostly they are written far ahead of finalizing the application. And so > most often the Help just is not up-to-date. > And over the years I have hardly ever seen an update. > Rainald >

Re: Pasting ON table into Excel: Not possible? "Rainald Taesler" <taesler[ at ]gmx.de> 10/28/2008 3:12:15 AM Jonathan wrote: [Quoted Text] >> Surprising indeed. > >> But I just tried it out once more. Worked pretty fine. >> Way to go: >> 1.) mark *all* cells in ON, copy them to the clipboard (Ctrl+C or >> Copy-icon); >> 2.) Open excel, click on the upper left cell (A:1); >> 3.) Paste from the clipboard > > Yes, Rainald, this is just the way I expected it would work. I get a > "message box" that says, "Microsoft Office Excel cannot paste the > data." No error code. I tried matching the cell number and > orientation as a se;lection in Excel before pasting. Really strange! I have no idea on what might be the reason. I tried a number of other tables from ON. Placing the cursor in the cell "A1" was all needed. > I use Excel2007 and Vista Business on this Lenovo machine. I should > try this with Office2007 on my WinXP home desktop and see if it > happens there. It's Excel 2007 and Vista Business on my side too. The hardware should be no issue in so far. Sorry for not having any further ideas Rainald