OneNote with Excel

M

MSnoobie

If I embed an Excel spreadsheet with a pivot table, will it work? I need to
share a spreadsheet with a remote colleague and wonder whether OneNote can
help me achieve this?
 
P

Patrick Schmid [MVP]

Yes and no. OneNote doesn't support OLE, which means you can't just copy
& paste the sheet from Excel into OneNote.
However, if you both use OneNote 2007, then you can embed an actual
Excel file into OneNote and it will be synced properly. However, if you
both make changes to the file at the same time, you are in trouble.
If it's just one file, why not use email?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
Office 2007 Beta 2 Technical Refresh (B2TR):
http://pschmid.net/blog/2006/09/18/43
***
Customize Office 2007: http://pschmid.net/office2007/customize
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed
 
M

MSnoobie

I'm a solo physician and use a spreasheet to track my patient accounts, I
wish I knew enough about SQL databases to write a simple database I can host
on a secure site to track, I use a spreadsheet at the moment and cannot
access it from other than the office, hence my desire for a mechanism of
hosting the spreadsheet some place online, thought Onenote might be the
alternative, doesn't sound like
 
M

MSnoobie

Sorry for those whomay find this a bit off topic, I'd ideally like to be able
to edit from more than one location, but happy to have READ-ONLY for everyone
else if that is not too complicated
Cheers
 
B

Ben M. Schorr - MVP

Aloha MSnoobie,

Well...there are a few ways to do it, none of them especially easy. SharePoint
might be the most elegant solution; especially if you use SharePoint 2007
with the Excel Services component.

Otherwise you might look at a web-based file sharing solution -- with Office
2003 I seem to recall that you get some storage space on MSN. Do a File
| Save As and chose My Network Places for the location. When that opens
see if you have a "My Web Sites on MSN" that you can navigate into.

-Ben-
Ben M. Schorr - MVP
Roland Schorr & Tower
http://www.rolandschorr.com
Microsoft OneNote FAQ: http://www.factplace.com/onenotefaq.htm
 
C

Chris H.

Sounds like you're struggling to produce something already available on the
market, Doc. Take a look at the offerings from Tablet PC MVP Fritz Switzer
at www.abletfactory.com, including his SOAP Toolkit. It includes drag and
drop lists, ICD9 and drug codes, new patient and existing patient templates,
ROS capabilities, along with PH, PMH, SH and allergies. The SOAP Toolkit
also includes the OneNote EMR, eScript and Nurses toolkits. He's also got
some very fine medical dictionaries available.
--
Chris H.
Microsoft Windows MVP/Tablet PC
Tablet Creations - http://nicecreations.us/
Associate Expert
Expert Zone -
 
F

Fritz Switzer

Thanks Chris,

I even get confused about this sometimes, but:

OneNote EMR Toolkit
OneNote eScript Toolkit
OneNote Nurses Toolkit
OneNote SOAP Toolkit
OneNote EMR WorkBench = OneNote EMR Toolkit + OneNote eScript Toolkit

All products work in conjunction with our SuperMedical Special Interest
Dictionary (SPID) for enhancing handwriting and speech recognition.

Hope this helps,

Fritz
 

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

Autonumber field in Excel that behaves the same as Access 0
OneNote and MS Forms 0
Need Help with Macro Security 1
Dealing with a Pivot Table (when I don't want to) 0
Embed the same Excel multiple times 0
Email notifications without opening application 1
Excel does not accept text format! 0
Excel - Wich Function should I use? 1

Top