OneNote 2010: RTM Upgrade

I upgraded to the final release version of Office 2010 yesterday and opened up my newly installed RTM version of OneNote this morning, to be greeted by this message:


This didn’t cause me any issues as I haven’t been syncing OneNote and I imagine that people who do would usually sync everything each day so this wouldn’t really come up.

However I can also imagine that this would be really annoying if it DID affect you as you’d need to:

  1. Uninstall Office 2010 RTM
  2. Re-Install Office 2010 Beta
  3. Sync One Note
  4. Uninstall Office 2010 Beta
  5. Re-Install Office 2010 RTM


which is quite a long winded process!

So, moral of the story is:

If you’re going to move up to the Office 2010 RTM, SYNC ONENOTE FIRST! 🙂

I hope that helps someone…

Office 2010 New Feature Videos

One of the main things I did in preparation for BETT 2010 was create a bunch of videos showing some of the new features in Office 2010. I can talk about them ‘til the cows come home, but it’s always better to see things where possible. The videos were very well received and Office 2010 got a LOT of positive feedback…June should be an exciting time 🙂

Anyway, I thought I’d put the videos up on here too and hopefully you’ll find them just as interesting & useful as our stand visitors did last week…enjoy!

Background Removal:

This is a great feature in Word 2010, making in nice and easy to remove all or part of a picture’s background.


Broadcast PowerPoint:

This feature lets you “broadcast” your presentation over the net by giving you a link to share with whoever you need to…allowing people to see your .pptx as long as they have an internet connection:

Insert Web Video:

Inserting videos from sites such as YouTube has always been a bit of a pain in Powerpoint…but no more! Powerpoint 2010 makes it super easy…teachers loved this at BETT.

Edit video inside Powerpoint:

Inserting videos into Powerpoint has been available for ages, but any editing you needed to do-even basic stuff-has required a 3rd party product. Again, Powerpoint 2010 makes it easier by enabling you to edit the video without leaving the program. Here I’m trimming a bit of Shooting Stars 🙂

Powerpoint Video Effects:

More built in video editing here with shadows, borders, reflections and more being easily applied within Powerpoint 2010.

Create a Video:

You’ve made a presentation and now you need to make it available as a video file, rather than a slideshow. I believe most people use Windows Movie Maker to do this currently but, with 2010, it’s again all done inside Powerpoint.

Save to Skydrive/Sharepoint:

This is a great new feature. It lets you save to your Live Skydrive (25GB free storage!) directly from the Office applications…no more save to folder then upload to Skydrive…it’s all one nice, smooth action 🙂 I don’t do it in the video but you can see there is also exactly the same thing to save to Sharepoint, which should really help drive adoption of Sharepoint in schools. From various discussions I’ve had, many people see Sharepoint as an extra step so:

Create Document > Save to Folder > Upload to Sharepoint

and this leads to many people just not bothering as it’s more work and they perhaps don’t see the point of it. Having the ability to save directly to their MOSS site will cut that out and make it just as easy as it’s always been 🙂

Word Navigation Pane:

This is quite a small new feature, but I love it! The navigation pane picks up all the  headings, sub-headings etc and enables you to use them to navigate documents; making large documents much less painful!

A deeper look @ PowerPivot

PowerPivot for Excel

PowerPivot for Excel supports self-service business intelligence in the following ways.

  • Current row-and-column limitations in Excel are removed so that you can import much more data. This goes far beyond 1,000,000 rows!
  • A data relationship layer lets you integrate data from different sources and work with all of the data holistically. You can enter data, copy data from other worksheets, or import data from corporate databases. You can build relationships among the data to analyze it as if it all originated from a single source.
  • Create portable, reusable data. Data stays inside the workbook. You do not need manage external data connections. If you publish, move, copy, or share a workbook, all the data goes with it.
  • PowerPivot data is fully and immediately available to the rest of the workbook. You can switch between Excel and PowerPivot windows to work on the data and its presentation in PivotTables or charts in an interactive fashion. Working on data or on its presentation are not separate tasks. You work on both together in the same Excel environment.

PowerPivot lets users build relationships between completely different data sources and still have all the data held entirely within the workbook.

Try it out:

You can download PowerPivot for Excel here. Note: It requires Office 2010 beta.


3 tier diagram of client, middle, backend add-ins


PowerPivot for Sharepoint:

“PowerPivot for SharePoint adds services and infrastructure for loading and unloading PowerPivot data”. The PowerPivot System Service tracks usage of PowerPivot workbooks across the app servers on the farm and deals with “setting up new connections to data that is already loaded in memory, and caching or unloading data if it is no longer used or when there is contention for system resources.” It then presents server health and usage data in reports, enabling admins to see how well the system is performing.

Excel Services renders the Presentation layer of a Pivot workbook  while the Analysis Services instances detect, extract and process the Pivot data. Here’s a diagram showing how a query request is processed:

Data processing request diagram

You can see a full overview over on the MSDN site here.

Try it out:

You can download PowerPivot for Sharepoint here. Note: It requires the CTP of SQL 2008 R2  AND Sharepoint 2010 beta.

Installing PowerPivot for Sharepoint

There are a number of pre-requisites and steps to installing the product, and they can all be found here:

Microsoft Office 2010 beta: A Look

The beta of Office 2010 is available now from MSDN and Technet and this is a look at what’s new, what’s fixed and what caused me problems…hopefully it will be interesting and useful for you 🙂

Installation and some issues:

The first thing to note is that you can’t upgrade from the 2010 Technical Preview; this means you’ll need to uninstall and do a reboot. I had a bit of a hairy moment where I logged in after the reboot and was presented with a guest account…I had a little “oh dear” moment thinking I’d managed to screw up my machine! Thankfully it was just a little glitch, I logged out and back in and all was well.

I double clicked the .exe and…I got the “cannot upgrade from previous versions” message again! I had a little stress and then started looking for the culprit…turns out it was the Office Outlook Connector that was getting in the way. If you’ve got that installed so you can access Hotmail from Outlook, make sure you uninstall it 🙂

After the install was complete, which took about 20 minutes, I started up OneNote…and got a warning box that I had possibly counterfeit software! It told me it was for “corporate or institutional use” only and that I had to connect it my corporate domain…WHAT?! I was told on Twitter that it had worked fine for other people so I tried again…added the key & clicked “Install Now” again. The next time I opened up OneNote it asked me to activate it online, which thankfully worked!

So now I’ve got it all installed and activated but it was a bit of a rollercoaster ride! To be fair, this machine has had a few issues with various iterations of Office over the years so I guess there is something not quite right in the registry!

What’s New?

The first thing I notice is that the Office components have all got new icons:



The Outlook Connector doesn’t recognise the beta and installation fails; however as you’re setting up Outlook, it offers to go off and install the Connector for you. I gave it a try and it pulls down a different beta file…clearly made for Office 2010 as it installed without a problem.

Having said that, the Outlook setup wizard doesn’t recognise that it’s installed, which is pretty annoying, and so goes off to find the settings online. After checking and double checking my account details to no avail, I tried another reboot…lo and behold, this time, it recognised that the connector was installed and went through with the account setup 🙂

Web test:

The folder structure on the left looks different than the Technical Preview and I noticed this:


See Web test at the bottom…what could it be? Let me show you:


That’s right, Twitter inside Outlook as default…that’s pretty cool 🙂 Once you’ve logged in, you can leave the Web Test folder and still be logged in when you come back.

Social Media Integration:

At the bottom of a new email, you now get this:


If you expand it using the arrow on the right, you get:


Click to add networks and you get:


Which hints at the social networking features present in Sharepoint 2010 🙂 It says there are more providers available online, but the link just takes you to a general Office site at the moment 😦 Once this is up & running, it will be pretty awesome…having, and I’m guessing at which will be included, Twitter, FaceBook & LinkedIn info and profiles available inside Outlook will be great. I’m not on Facebook (I know!) but I use the other two, especially Twitter, quite heavily for networking with suppliers, customers and colleagues.

Blurring the divide between “Social Media” and “Corporate Resources” is a great move, one aimed at this “New World of Work” that will resonate with the graduates coming into the workplace as well as us cool, hip (!) people that get it too. I can imagine some managers/directors being a bit unsure about this but I’m confident they’ll quickly see the benefits…just like corporate IM.

I’ve linked one of my Live Accounts into Outlook and just sent my first test email. It asked me to complete a “captcha” to verify my account before it would send it…something I don’t remember 2007 doing? You only need to do it once 🙂

New network pane:

Once you open up a new mail to someone who has emailed you, you get a message that Outlook wants to run an add-on. Click to run it and then Outlook starts showing you related mails and items.


I have to say that it takes quite a while for new mails to show up in the networking pane…hopefully this will be improved in the final version.

Also, I’m finding that I’m needing to close and re-open Outlook for all the changes to take place and, while it’s showing emails, attachments aren’t showing up in the pane. Again, I think this is down to it’s beta status.

This is very much a work in progress…I posted early so people could see the screenshots 🙂

The Backstage Icon look a bit different too, a bit more boring:


Was there the option to swap colour schemes in 2007 and/or the 2010 tech preview? I’m quite liking the black:


This leads me onto something I realised the other week. I’ve been paying much more attention to the ins & outs of Office 2010 than I ever did 2007 and so finding all kinds of great new features. However, I can’t be 100% sure if they’re new to Office or just new to me 🙂 There are a few in Outlook where I think this may be the case…if so, feel free to let me know in the comments!

Options –> Proofing –> AutoCorrect Options

That takes you to the section that shows you what things are replaced with what. There are things such as “yuor = your” but it also shows you how to make the sign for Pi and much more…pretty interesting:



Another feature I like the look of is “Keep track of formatting”:



As for the other components:

  • Word
  • Excel
  • Powerpoint
  • OneNote

I have to say that they all look pretty much the same to me, at least at this early stage!

%d bloggers like this: