Pasting ON table into Excel: Not possible?

[Jonathan]

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!)

 

[Rainald Taesler]

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

 

[Jonathan]

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...

 

[Rainald Taesler]

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