Troubleshooting MS Office Install issues (MSI & Click-to-Run)

Here’s a shortlist of some useful troubleshooting techniques, divided into two sections according to the two main types of MS Office Installations:

MSI: “Traditional” Windows installer
Click-to-Run: Office 365 installed MS Office

MS Office MSI Install Troubleshooting

“Verbose logging” is a setting that exposes more information during the installation process. It will capture “warning” as well as “error” messages that provide us with clues to your problem. To do onetime verbose logging:

Diagnosing When Setup Stops Responding At times, Office Setup stops responding (hangs), and you do not receive any error message. The best thing to do in this situation is to restart your computer, and run Office Setup again with complete verbose logging turned on (with one additional option). To do this, start Office Setup. To do so, follow these steps:

  1. Click Start, and then click Run.
  2. In the Open box, type the following command line, and then click OK:

pathSetup.exe /L*v! C:Verboselog.txt

Note that Path is the full path of your Office source location.

To enable Windows Installer logging yourself, open the registry with Regedit.exe and create the following path and keys:

HKEY_LOCAL_MACHINE\SoftwarePolicies\Microsoft\WindowsInstaller

Reg_SZ: Logging Value: voicewarmupx

The letters in the value field can be in any order. Each letter turns on a different logging mode. Each letter’s actual function is as follows for MSI version 1.1:

v – Verbose output
o – Out-of-disk-space messages
i – Status messages
c – Initial UI parameters
e – All error messages
w – Non-fatal warnings
a – Start up of actions
r – Action-specific records
m – Out-of-memory or fatal exit information
u – User requests
p – Terminal properties
+ – Append to existing file
! – Flush each line to the log
x – Extra debugging information. The “x” flag is available only on Windows Server 2003 and later operating systems, and on the MSI redistributable version 3.0, and on later versions of the MSI redistributable.
“*” – Wildcard, log all information except for the v and the x option. To include the v and the x option, specify “/l*vx”.

Note This should be used only for troubleshooting purposes and should not be left on because it will have adverse effects on system performance and disk space. Each time you use the Add/Remove Programs tool in Control Panel, a new Msi*.log file is created.

When looking through the MSI logs we will typically want to look for a value 3 entry in the logs. Windows installer returns codes during the install which will indicate if a particular function was successful or not.

Value 1 = Success
Value 2 = Cancel
Value 3 = Error

Note: make sure to turn off verbose logging after you are done.

Enable verbose logging before collecting the log files.

  1. Click on Start -> All Programs
  2. Accessories -> RUN
  3. Type reg add HKLMSOFTWARE\Microsoft\ClickToRun\OverRide /v LogLevel /t REG_DWORD /d 3
  4. Click on OK.

Now try to install Microsoft Office 2016 to get the error message so that the log files get created.

Follow the steps below to access the ‘Temp’ folder.

  1. Click on Start -> All Programs
  2. Accessories -> RUN
  3. Type %temp%  -> Click on OK

The following are the log files that may be present in the %windir%temp folder (c2r is for Click to Run):

Bootstrapper*.log
c2r_*.log
C2RIntegrator*.log
Firefly*.log
Integratedoffice.exe_c2r*.log
Interceptor*.log
*.exe.log
*_c2rdll*

For MSI, “Normal”, installations the log files will look like MSI****.LOG

Further References:
http://support.microsoft.com/kb/2545723 – “Fix Its” to turn logging on and off
http://blogs.technet.com/b/odsupport/archive/2010/12/30/trouble shooting-office-installation-failures.aspx Office 2003-2010, analyse log
http://support.microsoft.com/kb/223300 – “Fix It” enable XP, Server 2003-8
http://support.microsoft.com/kb/826511 – help interpretting logs
http://technet.microsoft.com/en-us/library/cc978342.aspx

MS Office Click-To-Run Install Troubleshooting

The following steps show you how to enable verbose logging to help you troubleshooting Office 365 install/update failures.

To enable verbose logging, launch cmd as administrator and run the following command:

reg add HKLM\SOFTWARE\Microsoft\ClickToRun\OverRide /v LogLevel /t REG_DWORD /d 3

ULS log file is created both in the %temp% folder and the %windir%\temp folder.  The file name is of the following format:

<machinename>-<date>-<time>.log

For example Keith-201420141610-1434.log.  Once these logs have been retrieved and analyzed, verbose logging should be disabled by running the following command from an administrative command-prompt:

reg delete HKLM\SOFTWARE\Microsoft\ClickToRun\OverRide /v LogLevel /f

The log output is in ULS format.  Opening the log file in Excel will help you with filtering the data.  First, you want to look for is the term “unexpected”.  You can look for “Fail” and /or “Error”

When Attempting to Install Office 365 Directly from the Office Portal

Most end user issues with installing/activating Microsoft Office 365 from the Office Portal are proxy/firewall related.  Follow the steps above to review log files.

Process Monitor and Fiddler are also great tools to use for troubleshooting Office 365 ProPlus installation and activation errors. If possible, try to test using a less restricted proxy/firewall.  If the activation is successful on another network, you may need make adjustments to your proxy/firewall settings.

The following article can help you with determining the IP address and URL exceptions you might need to add:

Start by white listing or adding exceptions for the IP addresses and URLs under “Office 365 ProPlus”.  If you continue to have problems, add the URLs under the “Office 365 portal and identity” section.

If still have problems, try the following:

MS Office MSI Install Troubleshooting

“Verbose logging” is a setting that exposes more information during the installation process. It will capture “warning” as well as “error” messages that provide us with clues to your problem.

To do onetime verbose logging:

Diagnosing When Setup Stops Responding At times, Office Setup stops responding (hangs), and you do not receive any error message. The best thing to do in this situation is to restart your computer, and run Office Setup again with complete verbose logging turned on (with one additional option). To do this, start Office Setup. To do so, follow these steps:

  1. Click Start, and then click Run.
  2. In the Open box, type the following command line, and then click OK:

pathSetup.exe /L*v! C:Verboselog.txt

Note that Path is the full path of your Office source location.

To enable Windows Installer logging yourself, open the registry with Regedit.exe and create the following path and keys:

HKEY_LOCAL_MACHINE\SoftwarePolicies\Microsoft\WindowsInstaller

Reg_SZ: Logging Value: voicewarmupx

The letters in the value field can be in any order. Each letter turns on a different logging mode. Each letter’s actual function is as follows for MSI version 1.1:

v – Verbose output
o – Out-of-disk-space messages
i – Status messages
c – Initial UI parameters
e – All error messages
w – Non-fatal warnings
a – Start up of actions
r – Action-specific records
m – Out-of-memory or fatal exit information
u – User requests
p – Terminal properties
+ – Append to existing file
! – Flush each line to the log
x – Extra debugging information. The “x” flag is available only on Windows Server 2003 and later operating systems, and on the MSI redistributable version 3.0, and on later versions of the MSI redistributable.
“*” – Wildcard, log all information except for the v and the x option. To include the v and the x option, specify “/l*vx”.

Note This should be used only for troubleshooting purposes and should not be left on because it will have adverse effects on system performance and disk space. Each time you use the Add/Remove Programs tool in Control Panel, a new Msi*.log file is created.

When looking through the MSI logs we will typically want to look for a value 3 entry in the logs. Windows installer returns codes during the install which will indicate if a particular function was successful or not. Value 1 = Success Value 2 = Cancel Value 3 = Error

Note: make sure to turn off verbose logging after you are done.

Enable verbose logging before collecting the log files.

  1. Click on Start -> All Programs
  2. Accessories -> RUN
  3. Type reg add HKLMSOFTWARE\Microsoft\ClickToRun\OverRide /v LogLevel /t REG_DWORD /d 3
  4. Click on OK.

Now try to install Microsoft Office 2016 to get the error message so that the log files get created.

Follow the steps below to access the ‘Temp’ folder.

  1. Click on Start -> All Programs
  2. Accessories -> RUN
  3. Type %temp%  -> Click on OK

The following are the log files that may be present in the %windir%temp folder (c2r is for Click to Run):

Bootstrapper*.log
c2r_*.log
C2RIntegrator*.log
Firefly*.log
Integratedoffice.exe_c2r*.log
Interceptor*.log
*.exe.log
*_c2rdll*

For MSI, “Normal”, installations the log files will look like MSI****.LOG

Open the command prompt (run as administrator), and use the following command to import the manual proxy settings from IE:

netsh winhttp import proxy source=ie

Now rerun the install/update

To reset winhttp back, run the following command:

netsh winhttp reset proxy

Most failed installs directly from the Office portal that are proxy related, usually fail pretty quick and usually with an error like this:

“Sorry, we ran into a problem Go online for additional help. Error Code: 30174-4.”

Or When attempting to update a client that is looking to the Office portal for updates will get something like this:

“Something went Wrong: We’re sorry, we ran into a problem while downloading updates for Office. Please check your network connection and try again later. Error Code: 30088-28 or 30088-27”

Retract Outlook emails the effective way – Before they get sent

Do you have fat fingers? Trying to format some picture in a draft email and you press “Send” by mistake? Do you regularly YELL SAILOR-WORTHY SWEARING in your email draft and then retract what you write? (that last one can be fixed with therapy btw)

Sounds like you need some risk mitigation – an ability to un-send an accidental email transmission that works a bit better then the generally ineffective Exchange-powered “Retract Email” functionality.

sailor

Enter: Delay or schedule sending email messages
http://office.microsoft.com/en-ca/outlook-help/delay-or-sche…

Email messages are sent immediately when you click Send. In Microsoft Outlook, you can delay sending a single email message or use rules to delay the delivery of all messages. These messages are held in the Outbox for a specified time after you click Send.

 Delay the delivery of all messages

1.Click the File tab.
2.Click Manage Rules & Alerts.
3.Click New Rule.
4.In the Step 1: Select a template box, under Start from a Blank Rule, click Apply rule on messages I send, and then click Next.
5.In the Step 1: Select condition(s) list, select the check boxes for any options that you want, and then click Next.

If you do not select any check boxes, a confirmation dialog box appears. If you click Yes, the rule that you are creating is applied to all messages that you send.
6.In the Step 1: Select action(s) list, select the defer delivery by a number of minutes check box.
7.In the Step 2: Edit the rule description (click an underlined value) box, click the underlined phrase a number of and enter the number of minutes for which you want the messages to be held before it is sent.

Delivery can be delayed up to 120 minutes. < Keith’s note: I find 1 minute to be just right to be able to strike the balance between “Oh crap I messed up with that message” and getting impatient with emails stuck in the Outbox.
8.Click OK, and then click Next.
9.Select the check boxes for any exceptions that you want.
10.Click Next.
11.In the Step 1: Specify a name for this rule box, type a name for the rule.
12.Select the Turn on this rule check box.
13.Click Finish.

After you click Send, each message remains in the Outbox folder for the time that you specified.

 

Note that these rules are performed only when you are sending from your desktop or web-based Outlook client- currently mobile device Outlook clients do not support running rules of this nature.

Using the built-in Windows Problem Steps Recorder to document user woes

I’m re-introducing the Windows PSR (Problems Steps Recorder) as one of those cool tools we come across, get distracted, forget about, and then come back to as “wow that’s hot”.

Problem Steps Recorder (PSR.exe), is shipping on all builds of Windows 7, Windows 8, Windows 8.1, Windows 8.1.1, Windows Server 2008 R2, Windows Server 2012 & Windows Server 2012 R2. Unfortunately, there is no equivalent Microsoft provided program available for Windows Vista, Windows XP, or other Microsoft operating systems prior to Windows 7. This feature enables the collection of the actions performed by a user while encountering a crash or running through the things they are trying to do, so that we as Consultants, Developers, Support Technicians & Admins can figure out what exactly is going south.

To begin creating their documentation, the user would press the Start Record button.

They would then begin going through the steps that took them towards their question or problem. At any point during this process, they can press the Add Comment button to highlight a problem area and add comments. Once they are done, they click the Stop Record button. Once they stop recording, a Save As window appears letting them browse to the location they want to save the documentation. A zip file is created and saved to that location. Inside the zip file is a .mht file containing the documentation. You will need to use Internet Explorer to view the MHT file.

Opening the documentation will present the help desk, admin, or family tech guy with a step-by-step walkthrough of what the user did, complete with screenshots and any comments made by the user.

Click here for a sample of what the recorded output looks like:
Windows-PSR-SharePoint-Problem-Steps-Recorder-Debugging

In addition to the screenshots, at the bottom of the report file the PSR generates you’ll find a copy & pastable (plain text) output of the events, like the following:

Recording Session: ‎2014-‎05-‎29 7:35:48 PM – 7:36:51 PM

Recorded Steps: 4, Missed Steps: 3, Other Errors: 0

Operating System: 9600.17041.amd64fre.winblue_gdr.140305-1710 6.3.0.0.2.48

Step 1: User left click in “Sites – Internet Explorer”
Program: Internet Explorer, 11.00.9600.16384 (winblue_rtm.130821-1623), Microsoft Corporation, IEXPLORE.EXE  SCODEF:13064 CREDAT:1782837 /PREFETCH:2, IEXPLORE.EXE
UI Elements:

Step 2: User mouse wheel down in “Pages – Engineering – Internet Explorer”
Program: Internet Explorer, 11.00.9600.16384 (winblue_rtm.130821-1623), Microsoft Corporation, IEXPLORE.EXE  SCODEF:13064 CREDAT:1782837 /PREFETCH:2, IEXPLORE.EXE
UI Elements:

Step 3: User left click in “Pages – Engineering – Internet Explorer”
Program: Internet Explorer, 11.00.9600.16384 (winblue_rtm.130821-1623), Microsoft Corporation, IEXPLORE.EXE  SCODEF:13064 CREDAT:1782837 /PREFETCH:2, IEXPLORE.EXE
UI Elements:

Step 4: User Comment: “This is where it breaks”
Program:
UI Elements:

How to Use the PSR

Notes

  • When you record steps on your computer, anything you type will not be recorded. If what you type is an important part of recreating the problem you’re trying to solve, use the comment feature described below to highlight where the problem is occurring.

    Some programs, like a full-screen game, might not be captured accurately or might not provide useful details to a support professional.

To record and save steps on your computer

  1. Open Problem Steps Recorder by clicking the Start button, and then typing psr. In the list of results, click psr.

  2. Click Start Record. On your computer, go through the steps on your computer to reproduce the problem. You can pause the recording at any time, and then resume it later.

  3. Click Stop Record.

  4. In the Save As dialog box, type a name for the file, and then click Save (the file is saved with the .zip file name extension).

    To view the record of the steps you recorded, open the .zip file you just saved, and then double-click the file. The document will open in your browser.

To send the problem steps in e‑mail

  • After recording and saving a .zip file, click the help down arrow , and then click Send to E‑mail recipient. This will open an e‑mail message in your default e‑mail program with the last recorded file attached to it.

    Note

    • You won’t be able to click the Send to e‑mail recipient option until you’ve recorded and saved a file.

To annotate problem steps

  1. Open Problem Steps Recorder by clicking the Start button , and then typing psr. In the list of results, click psr.

  2. Click Start Record.

  3. When you want to add a comment, click Add Comment.

  4. Use your mouse to highlight the part of the screen that you want to comment on, type your text in the Highlight Problem and Comment box, and then click OK.

  5. Click Stop Record.

  6. In the Save As dialog box, type a name for the file, and then click Save.

    To view the record of the steps you recorded, open the .zip file you just saved, and then double-click the file. The document will open in your browser.

To adjust settings

When you adjust settings for Problem Steps Recorder, they’re only saved for your current session. After you close and reopen Problem Steps Recorder, it will return to the regular settings.

  1. Open Problem Steps Recorder by clicking the Start button , and then typing psr. In the list of results, click psr.

  2. Click the help down arrow , and then click Settings.
  3. You can change the following settings for Problem Steps Recorder:

    • Output Location. If you don’t want to be prompted to save a file after recording, click the Browse button to set a default output file name.

    • Enable screen capture. If you don’t want to capture the screen shots along with the click information, select No. This might be a consideration if you are taking screen shots of a program that contains personal information, such as bank statements, and you are sharing the screen shots with someone else.

    • Number of recent screen captures to store. While the default is 25 screens, you can increase or decrease the number of screen shots. Problem Steps Recorder only records the default number of screen shots. For example, if you took 30 screen shots during a recording but only had 25 screen shots as the default, you would be missing the first five screen shots. In this case, you would want to increase the number of default screen shots.

What about the other screenshot tool <X>?

As usual in software-type things, there’s more than one product around that does the same type of thing. For screenshots, even just in the Microsoft stack there’s:
OneNote Screen Clipping – http://www.youtube.com/watch?v=r6yutoKDZLE
Office Screen Clipping – http://office.microsoft.com/en-ca/word-help/insert-a-screenshot-or-screen-clipping-HA010355185.aspx

On the general market, there’s:

I use the great SnagIt on a daily basis to make screenshots (just trying out version 12 this week myself) however, it’s more for us as Consultants to create content for consumption by others. The Problem Steps Recorder has the advantage over SnagIt for particular scenarios where you need the user to show you what’s going on:

– Free
– Built into most Windows environments you’ll encounter these days
– Can be run by end users with very little instruction
– Can be used on workstations where remote desktop’ing in isn’t available, performed autonomously by end users
– Handles all the screenshot’ing, layout, description of user interaction events
– Provides detailed descriptions of interaction events that would be otherwise time-consuming/difficult for a human to collect manually

Final Victory of the PSR

2014-05-29_20-24-13
The final advantage I see in the PSR in general (as a troubleshooting tool), is a huge one:
By empowering the user to document their own grief, with their own mouse button and on their own time, you are creating a purer user story:

– they are not being influenced by weird remote desktop software running on their workstation
– they don’t have to worry that the visiting technician invading their desktop is going to discover what kinds of oddball websites they visit while poking around
– there’s less time constraints as the user can run this on their own time, again without someone breathing down their neck
– there’s less chance of their user story being tainted as there’s no one coaching them, directly or indirectly

References:

http://blogs.msdn.com/b/patricka/archive/2010/01/04/using-the-secret-windows-7-problem-step-recorder-to-create-step-by-step-screenshot-documents.aspx
http://technet.microsoft.com/en-us/windows/problem-steps-recorder-overview.aspx
http://windows.microsoft.com/en-CA/windows7/How-do-I-use-Problem-Steps-Recorder
http://www.maximumpc.com/article/how-tos/how_use_windows_7_problem_steps_recorder_make_easy_pc_guides
http://msdn.microsoft.com/en-us/library/dd371782%28v=vs.85%29.aspx
http://www.7tutorials.com/easy-troubleshooting-and-problem-solving-problem-steps-recorder
https://www.youtube.com/watch?v=z6EgLm3-XcQ

List of Issues & Bugs Patched by Service Pack 1 (SP1) in Office and SharePoint 2013

Correlating bugs to the fixes indicated for the SharePoint 2013 / Office 2013 Service Pack 1 can be a bit tricky since the actual change list is served in the form of an Excel spreadsheet on the Microsoft KB page. I’m not convinced that the major search engines surface Excel data in the same way as regular web page content – so here’s the change list in HTML form in the hopes that this helps someone surfing around for general symptoms in the search engines match up their symptom with the fixes described.

Key References

Update center for Office, Office servers, and related products
Description of Microsoft Office 2013 Service Pack 1 (SP1) KB 2817430
List of all Service Pack 1 (SP1) updates for Microsoft Office 2013 and related desktop products KB 2850036

Download: Microsoft Office and SharePoint 2013 Service Pack 1 Changes Excel XLSX Worksheet

Issues Fixed by Service Pack 1 (SP1) in Office and SharePoint 2013

Resources

List of all Service Pack 1 (SP1) updates for Microsoft Office 2013 and related desktop products (KB 2850036)
List of all Service Pack 1 (SP1) updates for Microsoft SharePoint Server 2013 and related server products (KB 2850035)

Table of Contents

Access
Audit and Control Management Server
Excel
Lync
Office Shared (Affects Multiple Applications)
Outlook
PowerPoint
Project
Publisher
SharePoint
Visio
Word
Notes
1. Service Pack 1 also includes a rollup of all Cumulative Updates through December 2013, and all Public Updates through January 2014. The list below is specific to changes shipping for the first time in SP1.
2. Text for some list items describes a problem now fixed by SP1, while other items describe both the problem and the new behavior after installing SP1. Despite variations in phrasing, SP1 fixes all of the issues listed.
3. SP1 also contains additional changes which are less visible, but improve various aspects of the product. This includes reducing crashes, improving security, and fixing other issues too specific to include in this list.

Fix Descriptions

Product KB Number Text
Access 2817430
Access 2817430 Currency values may become zero when importing an Excel file into Access.
Access 2817430 Access app developers can now upgrade the apps they have made available in the Store or a corporate catalog.
Access 2817430 A crash may occur when opening a new connection using the Data Access Objects (DAO).
Access 2817430 A crash may occur when using Access as a DDE server and closing a database while a DDE conversation is in progress.
Access 2817430 Exporting to an Excel spreadsheet that uses named ranges can sometimes fail.
Access 2817430 Lookups to text don’t have the expected field size.
Access 2817430 When creating an Access web app that uses currency fields on a computer with Windows 8.1 installed, the app may fail to load in the browser with the message “an error has occurred.”
Access 2817430 Access may crash when running a query that invokes a user-defined function.
Access 2817430 An error may occur when an Access app is refreshed in Internet Explorer 10.
Access 2817430 Access cannot open a linked table or Access Services 2010 web database when the server URL changes protocols from http to https.
Access 2817430 A generic “error has occurred” message appears when a database has exceeded its maximum size limit.
Access 2817430 Access may crash when a new form is created while another object is open.
Access 2817430 Access may crash when the navigation control in Layout view is used.
Access 2817430 Buttons do not appear correctly when the screen resolution is set to anything other than 100% DPI.
Access 2817430 Exporting a multi-page report to HTML results in a lot of blank pages.
Access 2817430 An error appears when the “Preview Datasheet” feature is used on Windows 8.1.
Access 2817430 A view can’t be duplicated if it contains an embedded query along with an embedded macro or an embedded named expression.
Access 2817430 A syntax error may appear if numbers containing trailing zeroes after the decimal point are entered into expressions in an Access app.
Access 2817430 Pressing CTRL+Arrow key on a tab control can cause Access to crash.
Access 2817430 Linking to SharePoint lists from an Access Services 2013 application fails if the list uses a locale other than English.
Access 2817430 When a Project file is saved as an Excel workbook, dates are saved in US English format instead of the user’s regional settings.
Audit and Control Management Server 2817430
Audit and Control Management Server 2817431 When monitoring files in a SharePoint document library, files are only tracked if they appear on the first page of the default view for the document library.
Excel 2817432
Excel 2817433 On some machines, when a user switches to Page Layout View and then enters and exits print preview, Excel will run very slowly, potentially to the point of completely freezing.
Excel 2817434 When a user opens an .xls file with an old password in it and then tries to assign another password to anything else in the workbook, like another sheet or a range, all of the existing passwords are overwritten with the new password.
Excel 2817435 Comment text written in Arabic, Hebrew, Hindi, or Thai is cut off and can only be fully viewed if it is edited.
Excel 2817436 At a high DPI setting, the checkbox in the filter menu does not appear.
Excel 2817437 Incorrect results are returned when the language is set to Japanese and JIS function is used on certain strings.
Excel 2817438 A runtime error occurs when the PageSetup.PrintArea property is set by string via a variable.
Excel 2817439 Data validation that uses relative references may not be correctly saved to HTML file formats, which causes data validation to be broken when the file is reloaded.
Excel 2817440 At a high DPI setting, the dashed border is hidden in the Borders tab of the Format Cells dialog box, and when it is applied to a cell, the border disappears.
Excel 2817441 Excel may crash when a password-protected XLS file is opened.
Excel 2817442 After inserting an IVS character (such as certain Japanese Kanji characters with slight differences from base characters), deleting the IVS character using the backspace key requires pressing the backspace key twice.
Excel 2817443 FILTERXML parses numbers between 1900 and 9999 as the day before that year.
Excel 2817444 A file may become corrupted if there are many merged cells and the user sorts the worksheet.
Excel 2817445 At a high DPI setting, showing the print gridlines by either going into Print Preview or Print Layout and then going back to normal view, causes the gridlines to be drawn in white.
Excel 2817446 A crash may occur when a shared, Information Rights Management (IRM) protected Excel workbook is saved.
Lync 2817447
Lync 2817448 When the Lync client is used by a 3rd party application as an out-of-proc COM server showing no Lync UI (“UI suppression mode”), the Lync process does not exit after the app is closed.
Office Shared 2817449
Office Shared 2817450 List templates can’t be retrieved using the Office client object model.
Office Shared 2817451 It’s not possible to move the cursor using only the keyboard when adding an Organizational ID in the Sign-in screen.
Office Shared 2817452 EPS images are not properly embedded when they are inserted using the “Insert and Link” feature.
Office Shared 2817453 JNLP file types are now blocked in Outlook, InfoPath, and SharePoint. OneNote warns users attempting to open JNLP files.
Office Shared 2817454 Users who are not joined to a domain cannot configure Information Rights Management.
Office Shared 2817455 A crash may occur when creating a digital signature in Word, Excel or PowerPoint, when the SignatureHashAlg, InvalidHashAlg, LegacyHashAlg values contain uppercase letters or don’t match the expected list of values.
Office Shared 2817456 By default, every Office user has the ability to activate/deactivate any add-in. However, there are some enterprise scenarios where an organization may want to require certain non-admin users to always have some specific add-ins activated. The Registry Key ‘DisableLMAddinOverwrite’ can be set in order to prevent non-admin users from activating/deactivate add-ins loaded by an admin.
Office Shared 2817457 When a digital signature is added to a Word, Excel or PowerPoint file Office 2013 was not respecting the SignatureHashAlg registry key under HKCUSoftwareMicrosoftOffice15.0CommonSignatures. This prevents Office 2013 from creating digital signatures that Office 2007 can validate when using a certificate that contains a SHA256 hash.
Outlook 2817458
Outlook 2817459 When an exact match name resolution is attempted using the equal sign, Outlook resolves the wrong name.
Outlook 2817460 Unexpected text is added when properties are changed in a shared mailbox.
Outlook 2817461 Outlook may crash when IMAP is used with a custom add-in.
Outlook 2817462 Outlook downloads duplicate e-mails when a POP profile is used.
Outlook 2817463 Mail gets stuck in Outlook when SaveReplies and NoOST is set on a cached mode profile.
Outlook 2817464 Exchange export fails after Outlook is updated to KB 2687623.
Outlook 2817465 Outlook may freeze for 45-60 seconds on the initial account setup screen.
Outlook 2817466 A message may be stuck in the Outbox indefinitely when the length of the legacyExchangeDN + the length of the server name exceeds 245 characters.
Outlook 2817467 Outlook sometimes shows an incorrect value in Quota Thermometer.
Outlook 2817468 The object model event, dispidEventOnWriteWhen, is not fired when a reminder is dismissed.
Outlook 2817469 In Cached Mode, “last modified by” is not set correctly for exceptions.
Outlook 2817470 A meeting request from Lotus Notes can crash Outlook.
Outlook 2817471 The Read/Unread count may not update in the folder tree.
Outlook 2817472 Favorites of public folders will occasionally disappear.
Outlook 2817473 Attachments may not be sent with a read-only e-mail.
Outlook 2817474 Custom Document Property values are not displayed in a SharePoint document library when saving an e-mail from Outlook.
Outlook 2817475 On high resolution screens, the LinkedIn entry in the Social Connector dialog box does not allowed the user to remove an account using the delete icon that appears on mouse hover.
Outlook 2817476 Quick Steps don’t fire off any Object Model events.
Outlook 2817477 Rich text is incorrectly formatted as plain text when a custom form is used to create a new e-mail.
Outlook 2817478 Outlook crashes when attempting to access a user property on an exception item.
Outlook 2817479 A deleted inline picture will become an attachment when you save a “Do not forward” mail before sending it.
Outlook 2817480 An error occurs when custom actions are performed on custom MAPI forms that don’t use IDispatch.
Outlook 2817481 The Zoom field in the Scheduling Assistant dialog box has no label for screen readers to read.
Outlook 2817482 A contact address field is overwritten instead of changed or appended. For example, if a street address is added to an address that already has a city and zip code, the city and zip code may be lost.
Outlook 2817483 A crash may occur if Ctrl + N is pressed when the Advanced Find dialog box is open.
Outlook 2817484 In Modeless Simple MAPI, if an e-mail is sent via a secondary Exchange account, Outlook will leave the e-mail in the wrong Sent Items folder.
Outlook 2817485 Outlook prompts for credentials if it is started in disconnected mode and then connects with a firewall public profile that blocks outbound traffic.
Outlook 2817486 Setting a resource(location) programmatically through the Outlook object model does not work properly.
Outlook 2817487 Default special folders may be duplicated if Outlook is started without an OST and while disconnected.
Outlook 2817488 When adding ambiguous names to the To: and Cc: fields and clicking between them on the custom form, the To: and/or Cc: box will shrink in size, making it impossible to add users or to see which users are there.
Outlook 2817489 A write event is not triggered properly when the “Mark as read” / “Mark as unread” commands are used.
Outlook 2817490 At high-DPI settings, images in e-mails may grow unexpectedly.
Outlook 2817491 Outlook crashes if a new e-mail containing a table with merged cells is left in the background.
Outlook 2817492 Outlook may crash when printing an e-mail with OLE objects in it.
Outlook 2817493 When using custom Outlook forms with plain-text, the user is prompted every time they send an e-mail, warning that formatting will be lost, even though there is no formatting in the e-mail.
PowerPoint 2817494
PowerPoint 2817495 PowerPoint may crash when the slide is advanced in slideshow mode, while another PowerPoint file is opened in protected view.
PowerPoint 2817496 A crash may occur when PowerPoint slides are previewed in the Windows Explorer preview pane.
PowerPoint 2817497 If a read-only PowerPoint file containing images is saved as another PowerPoint file, the images may be lost.
PowerPoint 2817498 When PowerPoint slides are copied and pasted into Word, the slide/page numbers change.
PowerPoint 2817499 It’s not possible to undo the addition of tags to a presentation.
PowerPoint 2817500 It’s not possible to switch to Reading View when a presentation is in protected mode.
PowerPoint 2817501 Presentations.Count may return incorrect value when trapping PresentationAdd, PresentationClose, PresentationOpen and PresentationClose events.
PowerPoint 2817502 Creating a presentation programmatically and attempting to save it, results in a .potx type file instead of the default type (which is usually .pptx).
PowerPoint 2817503 The preview pane in Windows Explorer does not show a PowerPoint slide show unless a Word document is previewed first.
PowerPoint 2817504 Presentation.Fullname does not return the full name (path and file name) when it is called from inside a PresentationSave event during shutdown.
PowerPoint 2817505 Bulleted text doesn’t indent as expected when IndentLevel is set programmatically.
Project 2817430
Project 281743​2817434 If the view (resource or tasks) has one column that has a dependent read-only column, the paste action will try to override the read-only column and will generate an error message.
Project 281743 ​2817434 Close Tasks to Updates view disappears when switching to Project Server Permissions mode.
Project 281743 ​2817434 When migrating projects with project-level calendars to Project 2013 from earlier versions, in some instances the default Project calendar can conflict with the calendars in the MPP file, leading to unexpected scheduling discrepancies. Additionally, when expanding a subproject inside of a master project, rollup custom fields can display the value “#ERROR” or no value at all until the subproject is opened and a recalc is forced.
Project 281743 ​2817434 If a view uses an interactive filter, that filter will be removed from the view definition if a user cancels setting the filter when applying the view.
Project 281743 ​2817434 Importing a project from Excel may fail to properly set the task progress.
Project 281743 ​2817434 Documents, Issues, and Risks sections on the Task Details page don’t display links.
Project 281743 ​2817434 Certain tasks with very high work loads cannot be viewed in the Approval Center.
Project 281743 ​2817434 If a project with subprojects is opened before it is completely saved on the server, it may become corrupted.
Project 281743 ​2817434 Deleting a project created from the Project Ideas list can fail if the Project Ideas list was deleted.
Project 281743 ​2817434 In some cases, time phased cost and work values entered for a baseline in Project do not properly appear in the reporting database.
Project 281743 ​2817434 At a high DPI setting, the view names displayed on the left side of the screen may not appear correctly.
Project 281743 ​2817434 Users cannot edit a task’s work or remaining work in the Schedule Web Part when Protected Actuals is enabled on the server and the task already has actual work.
Project 281743 ​2817434 Out-of-the-box Project web parts do not function outside of the Project Web App site collection.
Project 281743 ​2817434 Resource costs are not calculated correctly when using the project update PSI for assignments that contain multiple cost rate table entries.
Project 281743 ​2817434 When projects are created in PWA using template-based EPTs, notes that are associated with tasks are lost when the project is opened in the Project client.
Project 281743 ​2817434 Project shows the error “The following job failed to complete. Job Type: Save. Error ID: 9000(0x2328)” when attempting to save changes in enterprise projects with more than 5000 tasks.
Project 281743 ​2817434 If the user selects one (or more) cells and then right-clicks in a cell that requires the grid to scroll, the right-click selection is lost.
Project 281743 ​2817434 When Project CSOM is used to return the collection of projects, the collection will now include subprojects.
Project 281743 ​2817434 If a textbox is added to a Gantt chart with a number in front of the text, the number shows up after the text in printing/print preview.
Project 281743 ​2817434 The Import Timesheets feature does not work properly when the language setting is not English.
Project 281743 ​2817434 If the Gantt chart is split with the resource graph view, Project may crash when the bar styles for the resource graph are edited.
Project 281743 ​2817434 When a baseline is saved from the context of a Master Project, Project may crash unexpectedly.
Project 281743 ​2817434 The number of calendar exceptions allowed for a single entity in Project has been increased.
Project 281743 ​2817434 The main Project icons will now be displayed correctly at a high DPI setting.
Project 281743 ​2817434 Project may not show the baseline data correctly if time phased baseline work and/or baseline cost is edited.
Project 281743 ​2817434 Baseline Work calculations sometimes do not update correctly while the user is in the Resource Usage view.
Project 281743 ​2817434 The Previous, Next and Select Period buttons are now enabled so that the user can move to a different period where there is an active time period.
Project 281743 ​2817434 When leveling granularity is set to a value greater than Days (Weeks and Months, for example), leveling does not properly resolve over allocation issues.
Project 281743 ​2817434 Saving and publishing a project on Project Server may take a long time.
Project 281743 ​2817434 Publishing a project, when resources in the project have assignments in many other projects, may take a long time to complete.
Project 281743 ​2817434 If the Office-wide profile setting turns off saving to either XPS or PDF, then the Project Save As dialog may not work correctly.
Project 281743 ​2817434 Earned value calculations do not work correctly in Project when any baseline other than Baseline0 is used.
Project 281743 ​2817434 Time phased Actual Cost and Baseline cost may not properly appear in the reporting database if there’s no associated time phased work/baseline work with the cost.
Project 281743 ​2817434 On some assignments with modified contours and small assignment unit values, it’s not possible to set the % Work Complete field to 100%.
Project 281743 ​2817434 Tasks deleted using the Gantt view on a SharePoint list do not go to the Recycle Bin of that site.
Project 281743 ​2817434 CustomFieldValueListAdd method cannot write values over 127 characters long.
Publisher 2817430
Publisher 2817430 Cursors, the ruler, and the Word Art gallery in Publisher appear pixelated on high DPI devices.
Publisher 2817430 The ruler is clipped in print preview when the user changes the display settings to view text at 200%.
SharePoint 2817430
SharePoint 2817430 Metadata is lost when documents that use a custom content type with a “Description” field are opened for editing.
SharePoint 2817430 When an item is deleted, restored from recycle bin, and then deleted again, there is a primary key constraint error.
SharePoint 2817430 An error occurs when files are moved between document libraries and the web time zone is behind that of the server.
SharePoint 2817430 Metadata filtering at list level always lists all metadata terms.
SharePoint 2817430 The hyperlink popup window drops the selected word to be linked when there is a delay of more than one second in opening the window.
SharePoint 2817430 Multiple-column, SummaryLinkWebParts with a group heading style of “Separator” are rendered incorrectly.
SharePoint 2817430 A hash tag that contains a full width space does not get created successfully.
SharePoint 2817430 Search schema compression is now enabled by default to allow larger search schemas.
SharePoint 2817430 Highlighting for FQL queries is now enabled for FQL as well as KQL.
SharePoint 2817430 Opening a custom SharePoint list in datasheet view and applying multiple custom filters, where each filter has more than one condition, can result in an incomplete set of list items.
SharePoint 2817430 When the “Export to Excel” button is clicked in a SharePoint document library that has the Content Type field displayed, the Content Type field does not appear in the Excel workbook.
SharePoint 2817430 An error occurs after changing the “Manager” property in EditProfile.aspx page when the My Sites WebApp is not in the same farm as the UPA.
SharePoint 2817430 SharePoint REST API does not return a well-defined error response for a duplicate key exception.
SharePoint 2817430 Developers are unable to specify a Content Type ID when creating Content Types in the client object model.
SharePoint 2817430 On list views in SharePoint sites, the Connect to Outlook button in the ribbon may be erroneously disabled.
SharePoint 2817430 In some non-English languages of SharePoint, the text displayed in the callout UI for a document or list item, describing who last edited the item, may not be grammatically correct.
SharePoint 2817430 Copy and Paste in a datasheet does not work correctly with Internet Explorer 11.
SharePoint 2817430 Pages do not render in Safari for iPad when private browsing mode is used.
SharePoint 2817430 When editing rich text fields in SharePoint, if the editing session exceeds 30 minutes, the edits may not be saved.
SharePoint 2817430 An error that says “SCRIPT12004: An internal error occurred in the Microsoft Internet extensions” may occur intermittently when users visit their SkyDrive Pro or other pages on their personal site.
SharePoint 2817430 InfoPath may crash when a form that points to a SharePoint list, with a lookup to another SharePoint list, is opened.
SharePoint 2817430 An InfoPath form with extended characters in its name fails to open.
SharePoint 2817430 An error that says “Security Validation for the form has timed out” may occur when an InfoPath form is digitally signed and hosted in a SharePoint site collection that uses the SharePoint version 2010 user experience.
SharePoint 2817430 “Show document icon” remains unchecked and the document icon does not show in Edit Properties for a list item.
SharePoint 2817430 A “Failed tagging this page” error occurs when the “I like it” button is clicked.
SharePoint 2817430 The wrong term is removed when manually editing a multi-valued taxonomy field.
SharePoint 2817430 When tagging list items using a language that is different from the term store default language, suggestions for labels are offered in multiple languages. The suggestions appear confusing because both language suggestions are listed without any identification of the language.
SharePoint 2817430 An error that says “There was an error processing this request” may appear when editing the user profile.
SharePoint 2817430 Times are missing from Date/Time results in certain filtered list web service calls.
SharePoint 2817430 Minimal and no metadata are now enabled as supported JSON formats.
SharePoint 2817430 Actions4 schema workflow actions can’t be deployed to SharePoint.
SharePoint 2817430 Using Client Object Model, Stream.Seek() to seek to a particular position doesn’t seek at the proper offset.
SharePoint 2817430 Refreshing a workflow status page generates the following error: “System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.”
SharePoint 2817430 Setting custom, non-English outcomes in web pages on tasks in a workflow fails to set the value.
SharePoint 2817430 Configurations of SharePoint using Azure Hybrid mode and Workflow Manager together can cause workflow callbacks to fail.
SharePoint 2817430 Workflow task processes on wiki pages won’t start.
SharePoint 2817430 Workflows won’t wait for changes to content approval status fields.
SharePoint 2817430 E-mails generated by workflow cannot be disabled for approvals in SharePoint workflows.
SharePoint 2817430 Workflows may fail to send an e-mail or send too many e-mails.
SharePoint 2817430 Association variables do not update correctly for auto-start workflows.
SharePoint 2817430 A KeyNotFoundException error may occur in a workflow when the associated task list uses unique permissions.
SharePoint 2817430 Incomplete tasks are deleted when workflow task activities complete.
SharePoint 2817430 Task activity is suspended when the task is completed using app-only credentials.
SharePoint 2817430 An error that says “This task could not be updated at this time” occurs when trying to complete a workflow task using the “Open this task” button in Outlook.
SharePoint 2817430 A workflow doesn’t respond properly when waiting for changes in specific types of list columns, such as Boolean, Date Time, and User.
Visio 2817430
Visio 2817430 Connectors in UML sequence diagrams don’t work properly. The message arrow shape gets converted into a return message arrow shape and vice versa, when the direction of the arrow is reversed.
Visio 2817430 CAD drawings are blurry at high magnification (zoom).
Visio 2817430 Certain BPMN diagram shapes may not render until the page is refreshed.
Visio 2817430 At a high-DPI setting, the ribbon icons and other user interface elements appear blurry.
Word 2817430
Word 2817430 Certain Word documents containing old diagrams can’t be saved in the ISO Strict format.
Word 2817430 The Y axis label text in a chart may become unreadable if it is rotated.
Word 2817430 Setting document protection via the object model will fail when the document’s current selection contains a grouped content control.
Word 2817430 When comparing documents with footnotes or endnotes that are formatted with custom styles, a whole footnote or endnote is incorrectly shown as being deleted and reinserted.
Word 2817430 Tables with merged cells may not render correctly when an 8-bit remote desktop connection is used to access Word.
Word 2817430 Word may freeze when opening a document that uses a font that is not available on the computer.
Word 2817430 If VBA is used to iterate through the revisions collection of a document, Word may get stuck in an infinite loop.
Word 2817430 When selecting multiple disjoint cells in a table, querying Selection.End via Word’s object model returns the character position of the first cell selected instead of the character position of the last cell selected.
Word 2817430 Printing documents in Booklet layout will cause some HP printers to print horizontal white lines across the content.
Word 2817430 Converting a document to PDF with Word Automatic Services could result in table indents being ignored in the PDF file partway through the document.
Word 2817430 Table captions with SEQ fields print incorrectly if the document is marked as final.
Word 2817430 Digits may fall outside the End of Ayah mark or other Arabic subtending marks, and the order of digits inside subtending marks is reversed.
Word 2817430 At high-DPI settings, the ruler and cursor appear pixelated.
Word 2817430 Word may become unresponsive when copy/pasting content with bullets, numbering, or styles on a touch screen device.
Word 2817430 The chevron of a collapsed heading is not fully visible.
Word 2817430 Text is duplicated with every keystroke when typing in a plain content control, where the text has range permissions on it and Track Changes is enabled.
Word 2817430 In the Japanese language version of Word, when a user creates or edits a paragraph style to have hanging indents and left indents defined in character units, the hanging indent is lost when the Modify Style, Paragraph dialog box is reopened.
Word 2817430 The bottoms of text boxes are cut off during printing, when those text boxes contain multiple paragraphs with horizontal borders applied to them.
Word 2817430 Converting a numbered list in a content control to plain text using the object model results in the number for the first list item falling outside of the content control.
Word 2817430 Using VBA to attach a template from a network share to a document, while populating a global variable, results in a run-time error.
Word 2817430 Users who are co-authoring a Word document are prompted to save too frequently.
Word 2817430 Opening quotation marks that are typed in Latvian are lowered incorrectly.
Word 2817430 Manipulating tables using Selection.Text takes too long to execute.
Word 2817430 Table of Figures does not update correctly after a user deletes tables or figures with sequential captions while Track Changes is enabled.
Word 2817430 A right-tab may incorrectly cause a line to break.
Word 2817430 Bookmarks near textboxes may not be loaded when opening RTF files.
Word 2817430 Programmatically setting the bounds of a floating shape results in incorrect bounds, when the document is in compatibility mode and when the “Show white space between pages in Print Layout view” checkbox in Options is unchecked.
Word 2817430 Getting or setting Document.PageSetup properties through VBA fails for documents that contain floating tables.
Word 2817430 When clicking on a hyperlink in the research pane for a location that is in the Local Intranet trusted zone in Internet Explorer’s Internet Options, Internet Explorer will no longer immediately disappear after opening the link.
Word 2817430 Attempting to use Document.Repaginate when the selection is within a locked Content Control or within a coauthoring lock results in an error.
Word 2817430 Documents may sometimes become corrupted when they contain equations.
Word 2817430 Using “Send as Attachment” results in the attached document having a duplicate extension, if the original document’s extension is uppercase.
Word 2817430 Performance is slow when copying large amounts of content into a content control.
Word 2817430 When there isn’t a good line break opportunity, Word sometimes breaks inside glyph clusters.
Word 2817430 Opening a document that contains a multi-line content control that itself contains a line break, results in digital signatures being declared invalid, as if edits were made to the document.
Word 2817430 Editing or undoing certain changes can change the way a run of text line-breaks.

Don’t forget: Win XP and Office 2003 support ends April 8 2014

http://www.microsoft.com/en-us/windows/endofsupport.aspx

WHY?

Why is Microsoft ending support for Windows XP and Office 2003?

            In 2002 Microsoft introduced its  Support Lifecycle policy based on customer feedback to have more transparency and predictability of support for Microsoft products. As per this policy, Microsoft Business and Developer products, including Windows and Office products, receive a minimum of 10 years of support (5 years Mainstream Support and 5 years Extended Support), at the supported service pack level.

Thus, Windows XP SP3 and Office 2003 will go out of support on April 8, 2014. If your organization has not started the migration to a modern desktop, you are late. Based on historical customer deployment data, the average enterprise deployment can take 18 to 32 months from business case through full deployment. To ensure you remain on supported versions of Windows and Office, you should begin your planning and application testing immediately to ensure you deploy before end of support.

Resources

Learn about other companies have benefitted from migrating to Windows 7 and Windows 8 Enterprise.

Next: What does end of support mean to customers?

WHAT?

What does end of support mean to customers?

It means you should take action. After April 8, 2014, there will be no new security updates, non-security hotfixes, free or paid assisted support options or online technical content updates.

Running Windows XP SP3 and Office 2003 in your environment after their end of support date may expose your company to potential risks, such as:

  • Security & Compliance Risks: Unsupported and unpatched environments are vulnerable to security risks. This may result in an officially recognized control failure by an internal or external audit body, leading to suspension of certifications, and/or public notification of the organization’s inability to maintain its systems and customer information.
  • Lack of Independent Software Vendor (ISV) & Hardware Manufacturers support: A recent industry report from Gartner Research suggests “many independent software vendors (ISVs) are unlikely to support new versions of applications on Windows XP in 2011; in 2012, it will become common.” And it may stifle access to hardware innovation: Gartner Research further notes that in 2012, most PC hardware manufacturers will stop supporting Windows XP on the majority of their new PC models.

Get current with Windows and Office. This option has upside well beyond keeping you supported. It offers more flexibility to empower employees to be more productive, while increasing operational efficiency through improved PC security and management. It also enables your organization to take advantage of latest technology trends such as virtualization and the cloud.

Resources

Download the free Microsoft Deployment Toolkit.

Visit the Springboard Series on TechNet for additional technical guidance.

Next: How do I begin my migration?

HOW?

How do I begin my migration?

Enterprise Customers: Microsoft offers large organizations in-depth technical resources, tools, and expert guidance to ease the deployment and management of Windows, Office and Internet Explorer products and technologies. To learn more about migration and deployment programs, please contact your Microsoft sales representative or Certified Microsoft Partner. Learn how to pilot and deploy a modern desktop yourself, download the free Microsoft Deployment Toolkit and begin your deployment today.

Small to Medium Business:  There are many options for small and medium businesses considering moving to a modern PC with the latest productivity and collaboration tools. Small to mid-size organizations should locate a Microsoft Certified Partner to understand the best options to meet their business needs. If your current PC meets the system requirements for Windows 7 or Windows 8, you can buy Windows 7 Professional or Windows 8 Pro from a local retailer or Microsoft Certified Partner. If your PC does not meet system requirements, consider purchasing a new business PC with Windows 8 Pro.

Resources

Download the free Microsoft Deployment Toolkit.

Get technical resources, free tools and expert guidance for Internet Explorer.

Visit the Springboard Series on TechNet for additional technical guidance.

Check out the latest recommended Windows devices.

What does end of support mean for my home PC?

Moving to Windows 7?

Moving to Windows 8?

Windows

Flash Fill Gives Excel a Smart Charge

This is cool:

http://research.microsoft.com/en-us/news/features/flashfill-020613.aspx
“In December 2009, Sumit Gulwani, a senior researcher at Microsoft Research Redmond, was flying home from a seminar after presenting his work devising ways to synthesize complex pieces of code.

Sitting next to him was a businesswoman. She was delighted to learn that Gulwani was both a Ph.D. in computer science and a Microsoft employee. She popped open her laptop and asked, “Is there a way to merge two columns in Excel, when one column has a first name, the other the last, so that a column has both first and last names?”

Gulwani paused.

“I had to admit to her that I knew next to nothing about Excel,” Gulwani recalls. “But when I got home, I opened my own laptop and looked for Excel search words. I found hundreds of help topics. And that made me think: Maybe this is the next problem I should solve.”

Solve it he did. In a collaborative effort that spanned both Microsoft Research and the Office 2013 team, Microsoft has introduced a feature in Excel 2013 called Flash Fill. Flash Fill earned enthusiastic reviews even before Office 2013 was released Jan. 29, and it is sure to be popular with users. Flash Fill takes tedious tasks now often performed manually in Excel—or by writing one-off programs—and executes them automatically. And it does so simply, requiring only the typing in an example of what the user wants.”

All About OneNote Synching & SharePoint

What is OneNote?

Has to be asked – a surprising number of people are not aware of what OneNote is for and how powerful it can be for keeping organized.

OneNote is a Digital notebook application that enables users to gather, organize, and search notes and other types of information, and to share those notes with others.

OneNote homepage: http://office.microsoft.com/en-ca/onenote/

What Are OneNote Documents?

Unsurprisingly, OneNote 2010 documents are XML documents not unlike .DOCX or .XLSX files. This means CRUD operations incur less complexity and overhead as they would if they were old school binary documents.

For collaboration, the open XML format that your OneNote “stuff” (including the hierarchy of Section Groups & Sections, text, styling, and embedded images and other media) follows makes it easy to synch across disparate devices such as desktops & mobile devices (non-Windows devices included).

That’s Great Keith, How About A Bunch of Code?

I knew you’d ask! Here you go, this is an update of a OneNote page, at the plumbing level:

static void UpdatePageContent()
    {
        OneNote.Application onApplication = new OneNote.Application();
        String strImportXML;
strImportXML = "<?xml version="1.0"?>" +
            "<one:Page xmlns:one="http://schemas.microsoft.com/office/onenote/12/2004/onenote"
            ID="{3428B7BB-EF39-4B9C-A167-3FAE20630C37}{1}{B0}">" +
            "    <one:PageSettings RTL="false" color="automatic">" +
            "        <one:PageSize>" +
            "            <one:Automatic/>" +
            "        </one:PageSize>" +
            "        <one:RuleLines visible="false"/>" +
            "    </one:PageSettings>" +
            "    <one:Title style="font-family:Calibri;
                 font-size:17.0pt" lang="en-US">" +
            "        <one:OE alignment="left">" +
            "            <one:T>" +
            "                <![CDATA[My Sample Page]]>" +
            "            </one:T>" +
            "        </one:OE>" +
            "    </one:Title>" +
            "    <one:Outline >" +
            "        <one:Position x="120" y="160"/>" +
            "        <one:Size width="120" height="15"/>" +
            "        <one:OEChildren>" +
            "            <one:OE alignment="left">" +
            "                <one:T>" +
            "                    <![CDATA[Sample Text]]>" +
            "                </one:T>" +
            "            </one:OE>" +
            "        </one:OEChildren>" +
            "    </one:Outline>" +
            "</one:Page>";
// Update the page content.
        onApplication.UpdatePageContent(strImportXML, System.DateTime.MinValue);
    }

My Brain Hurts, What Does that Crap Mean?

It means, that since we can see it’s a simple XML (text file) update method, then the access methods for performing these updates are also likely to be simple. That they be. Web Services are a fundamental backbone to the Office suite and SharePoint, and OneNote is no black sheep.

There are three methods used by OneNote for communicating:

HTTP Extensions for Web Distributed Authoring and Versioning (WebDAV):

File Synchronization via SOAP over HTTP Protocol Specification

Windows Live SkyDrive Save to Web SOAP Web Service

All three of these methods are simply communication over HTTP via XML.

What Protocol is Used When?

To transfer and synchronize files that are stored on a server running SharePoint Products and Technologies, OneNote 2013 or OneNote 2010 determine which Web authoring protocol to use by sending a SOAP call to the protocol server by using the File Synchronization via SOAP over HTTP Protocol (MS-FSSHTTP), and then processing the response as follows.

1. If the protocol server responds in the format that is defined by the File Synchronization via SOAP over HTTP Protocol, OneNote 2013 or OneNote 2010 use the File Synchronization via SOAP over HTTP Protocol to access the file.

2. If the protocol server does not respond in the format that is defined by the File Synchronization via SOAP over HTTP Protocol or it responds incorrectly, OneNote 2013 or OneNote 2010 use either of the following, depending on the version of the operating system on which it is running:

  • If it is running on Windows Vista operating system or Windows 7 operating system, OneNote 2013 or OneNote 2010 use the Web Distributed Authoring and Versioning (WebDAV) Protocol Client Extensions.
  • If it is running on Windows XP operating system, OneNote 2013 or OneNote 2010 uses the FrontPage Server Extensions Remote Protocol.

The following table describes the additional protocols used by OneNote 2013, OneNote 2010, or Office OneNote 2007 when synchronizing files with servers running Windows SharePoint Services.

Protocol Name Description Short Name
Hypertext Transfer Protocol — HTTP/1.1 Sends HTTP OPTIONS requests to the server to identify the server version and supported protocols. Sends HTTP HEAD requests to files and folders to validate their existence, invoke authentication, and check file modified times. [RFC2616]
Lists Web Service Protocol Enumerates Office OneNote 2007, OneNote 2010, or OneNote 2013 files in the document library folder, and efficiently enumerates changed files. [MS-LISTSWS]
Webs Web Service Protocol Maps file path URLs to document libraries for subsequent calls to the Lists Web Service Protocol [MS-LISTSWS]. [MS-WEBSS]

For a complete reference of Microsoft Office Protocols, check out http://msdn.microsoft.com/en-us/library/cc307282%28v=office.14%29.aspx

About OneNote Notebook Synching

When you work in notebooks that are stored on your computer, Microsoft OneNote 2010 continually and automatically saves your changes as you work. However, if you set up a shared notebook on the Web or your organization’s network in order to share the notebook on other computers or with other people, saving and managing changes occurs a bit differently.
OneNote keeps a local cached copy of a shared notebook on each computer that accesses it and then periodically synchronizes any changes with the notebook files that are stored in the shared location. You can adjust the settings that control this process.

OneNote 2010 does do incremental syncing on notebooks. But if a file is an embedded file, such as a video, if that file changes, then the entire file would need to be uploaded again.
There is not a way to change the syncing interval of notebooks.

Notes About SharePoint & OneNote

Unlike Microsoft Word and Microsoft PowerPoint, Microsoft OneNote stores version information within the file itself. For this reason, administrators should follow these recommended practices when storing OneNote notebooks in a SharePoint Server document library:

  • Do not enable minor versioning. This is the default setting in SharePoint Server 2010.
  • If major versioning is enabled, set a reasonable maximum number of versions to store. By default, major versioning is not enabled in SharePoint Server 2010.

It should be understood that in SharePoint 2010 there are at 8 methods of data manipulation possible. See http://nikspatel.wordpress.com/2012/08/05/sharepoint-2010-data-querying-options-server-om-vs-client-om-vs-rest-vs-linq-vs-search-api/

Considering this, when the question comes up “How is OneNote pegging my SharePoint server resource-wise and what can I do to limit that”, one needs to carefully review the SharePoint access methods in comparison to the particular mode OneNote is communicating in.

As synched OneNote content is delivered via Office Web Application, all the standard SharePoint Resource Throttling approaches will apply – including being able to offload heavy queries to certain times of day. This is also the same for SharePoint Workspace (although there are some other built-in limits at play in Workspace) and a variety of third-party apps such as SharePlus.

Notes About Office Web Application Service Limits

This includes the Word Web App, PowerPoint Web App and OneNote Web App. There are several different perspectives that you have to look at each of these. Specifically you should focus on viewing versus editing because the resources required are quite different.

The drivers for performance are expected concurrent users and what type of operations are going to be done. Microsoft’s initial recommendations are 100 daily users with average of 10 concurrent can be supported by 1 WFE and 1 App Server. Going to 1000 daily and 30 concurrent would require 2 WFE and 2 App servers. Going to 10,000 daily and 300 concurrent would require 4 WFE and 3 app servers.
Much of the limits associated to OneNote Services are directly tied to the limits for list and libraries. This is because each section in OneNote is stored as folders and documents in a library.
The maximum size for each section of an OneNote section is again driven by the file size limits for lists and libraries.

If there are embedded images, files, etc. in OneNote, that are greater than 100KB, they will be split out into their own binary files within the SharePoint library.

Error Codes

The full reference to possible OneNote errors can be found here: http://msdn.microsoft.com/en-us/library/ff966472.aspx

Large collection of Free Microsoft eBooks for you, including: SharePoint, Visual Studio, Windows Phone, Windows 8, Office 365, Office 2010, SQL Server 2012, Azure, and more.

Eric Ligman has assembled a nice little collection of free Microsoft ebook downloads:





Moving to Microsoft Visual Studio 2010


image
Programming Windows 8 Apps




Programming Windows Phone 7


643352_win Phone.indd

Programming Windows Phone 7 (Special Excerpt 2)




Office 365 – Connect and Collaborate virtually anywhere, anytime


9780735693876f
Microsoft Office 2010 First Look




Security and Privacy for Microsoft Office 2010 Users


image

Getting started with
Microsoft Office 2010 – For IT Professionals


image

Planning guide for Microsoft Office 2010 – For IT professionals


image

Deployment guide for Microsoft Office 2010 – For IT professionals


image

Operations guide for Microsoft Office 2010 – For IT professionals


image

Technical reference for Microsoft Office 2010 – For IT professionals


clip_image001

Understanding Microsoft Virtualization R2 Solutions


image

Introducing Windows Server 2012


image

Introducing Microsoft SQL Server 2012


image

Introducing Microsoft SQL Server 2008 R2




Configure Kerberos Authentication for SharePoint 2010 Products




Business continuity management for SharePoint Server 2010




Deployment guide for SharePoint Server 2010




Get started with SharePoint Server 2010




Governance guide for Microsoft SharePoint Server 2010




Profile synchronization guide for SharePoint Server 2010




Remote BLOB storage for Microsoft SharePoint Server 2010




Technical reference for Microsoft SharePoint Server 2010





Upgrading to SharePoint Server 2010


image

Getting Started with SharePoint Server 2010


image

Planning guide for sites and solutions for Microsoft SharePoint Server 2010, Part 1


image

Planning guide for sites and solutions for Microsoft SharePoint Server 2010, Part 2


image

Planning guide for server farms and environments for Microsoft SharePoint Server 2010


image

Capacity planning for Microsoft SharePoint Server 2010




SQL Server 2012 Tutorials: Analysis Services – Tabular Modeling




Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery




Transact-SQL Data Manipulation Language (DML) Reference




QuickStart: Learn DAX Basics in 30 Minutes




SQL Server 2012 Tutorials: Analysis Services – Data Mining




Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide




Data Analysis Expressions (DAX) Reference




SQL Server 2012 Upgrade Technical Guide




Backup and Restore of SQL Server Databases




SQL Server 2012 Tutorials: Analysis Services – Multidimensional Modeling




Master Data Services Capacity Guidelines


In The Classroom - Digital Storytelling

Digital Storytelling


In The Classroom - Free Tools

Free Tools in the Classroom


In The Classroom - Movie Maker

Windows Live Movie Maker in the Classroom


In The Classroom - Windows 7

Windows 7 in the Classroom


In The Classroom - Web Apps

Microsoft Office Web Apps Teaching Guide


In The Classroom - Office

Microsoft Office in the Classroom


Critical Thinking - In The Classroom

Developing Critical Thinking through Web Research Skills


In The Classroom - Bing

Bing in the Classroom




Moving Applications to the Cloud, 2nd Edition




Windows Azure Prescriptive Guidance




Windows Azure Service Bus Reference




Intro to ASP.NET MVC 4 with Visual Studio (Beta)




Deploying an ASP.NET Web Application to a Hosting Provider using Visual Studio



Getting Started with ASP.NET 4.5 Web Forms (Beta)




Introducing ASP.NET Web Pages 2


image

Own Your Future


W7PUG Cover-free

Windows 7 Power Users Guide


eBook

Deploying Windows 7 Essential Guidance


image

Welcome to Windows 7


image
What You Can Do Before You Call Tech Support (Windows 7)

Firefox Friday #2 – SharePoint & Firefox

​Firefox does have issues when being used with SharePoint, let’s ID the known issues and workarounds:

Feature

Limitation

Connect to Outlook, Connect to Office, and Sync to
SharePoint Workspace

Works with an
ActiveX control, but requires a Firefox control adaptor. Microsoft Office
2010 does not provide a Firefox control adaptor for this control. The feature
also requires an application that is compatible with the stssync:// protocol,
such as Microsoft Outlook.

Datasheet view

Requires an
ActiveX control, such as the one that is delivered in Microsoft Office 2010,
and a Firefox control adaptor. Microsoft Office 2010 does not provide a
Firefox control adaptor for this control.

Drag and Drop Web Parts

Cannot be moved by
using drag and drop on Web Part pages. Users must click Edit on the Web Part, select Modify Web Part, and then select the zone
from the Layout section of the Web Part
properties page. Web Parts can be moved using drag and drop on Pages.

Edit in Microsoft Office application

Requires an
ActiveX control, such as the one that is delivered in SharePoint Server 2010,
and a Firefox control adaptor. For more information about Microsoft Office
2010 Firefox Plug-in, see FFWinPlugin Plug-in
(http://go.microsoft.com/fwlink/p/?LinkId=199867).
If you install and configure the Office Web Applications on the server, the
Edit functionality works and you can modify Office documents in your browser.
This functionality only works with Microsoft Office 2010 or an equivalent
product together with a Firefox plug-in.

Explorer view

Removed in
SharePoint Server 2010. Libraries that have been upgraded from earlier
versions of SharePoint Server 2010 may still have Explorer views, and these
may not work. Explorer view requires Internet Explorer.

Export to Excel

Downloads a file
with an .iqy extension to the Web browser. If Microsoft Excel is not
installed, and if no other application is configured to open this file, then
this feature will not work.

File upload and copy

Requires an
ActiveX control, such as the one that is delivered in Microsoft Office 2010,
and a Firefox control adaptor. Microsoft Office 2010 does not provide a
Firefox control adaptor for this control.

Microsoft InfoPath 2010 integration

Requires an
ActiveX control, such as the one that is delivered in Microsoft Office 2010,
and a Firefox control adaptor. Microsoft Office 2010 does not provide a
Firefox control adaptor for this control.

Microsoft PowerPoint 2010 Picture Library
integration

Requires an
ActiveX control, such as the one that is delivered in Microsoft Office 2010,
and a Firefox control adaptor. Microsoft Office 2010 does not provide a
Firefox control adaptor for this control. The user can use the following
workarounds when no control has been installed:

  • If a user wants to upload
    multiple pictures in a picture library, the user must upload one picture
    at a time by using Upload.aspx.
  • If a user wants to edit a
    picture in a picture library, the user must download the picture, edit
    it, and then upload the picture to the picture library.
  • If a user wants to download
    more than one picture from a picture library, the user must download one
    picture at a time by clicking on the picture link.

Microsoft Visio 2010 diagram creation

Requires an
ActiveX control, such as the one delivered in Microsoft Office 2010, and a
Firefox control adaptor. Microsoft Office 2010 does not provide a Firefox
control adaptor for this control.

New Document

Requires an
ActiveX control, such as the one delivered in Microsoft Office 2010, and a
Firefox control adaptor. For more information about Microsoft Office 2010
Firefox Plug-in, see FFWinPlugin
Plug-in
(http://go.microsoft.com/fwlink/p/?LinkId=199867).
Although the New Document command may
not work, you can use the Upload Document functionality. If you install and
configure Office Web Applications on the server, the New Document command works, and you can create an Office
document in your browser.

Rich Text Editor – Basic Toolbar

A user can update
the Rich Text Editor basic toolbar to a Full Rich Text Editor that includes
the ribbon by changing the field’s properties, as follows: On the
FldEdit.aspx, in the List Settings
menu, select Specific Field Settings.
Next, under Columns, click Description. In the Additional Columns Settings section, under Specify the type of text to allow, select Enhanced rich text (Rich text with pictures, tables,
and hyperlinks)
.

Send To

Can leverage an
ActiveX control, such as the one that is delivered in Microsoft Office 2010,
and a Firefox control adaptor. Microsoft Office 2010 does not provide a
Firefox control adaptor for this control. Without the control, files cannot
be sent from one SharePoint farm to another SharePoint farm. However, files
can still be sent from one site to another site.

Signing Forms (InfoPath Form Services)

Requires an
ActiveX control, such as the one that is delivered in Microsoft Office 2010,
and a Firefox control adaptor. Microsoft Office 2010 does not provide a
Firefox control adaptor for this control.

Spreadsheet and Database integration

Require ActiveX
controls, such as those that are delivered in Microsoft Office 2010, and
Firefox control adaptors. Microsoft Office 2010 does not provide a Firefox
control adaptor for this control. The user can use the following workarounds
when no control has been installed:

  • If a user wants to edit a
    document, the user must download the document, edit it, and then save it
    back to the server.
  • In a list that requires a
    document to be checked out for editing, a user must use the
    Edit menu to check out the
    document, edit it, and then check it in by using the
    Edit menu.
  • Export to spreadsheet.
    Users can export a SharePoint list as a spreadsheet by clicking
    Export to
    Spreadsheet
    on
    the
    List
    tab on the ribbon.

Web Part to Web Part Connections

May require
deactivation of browsers pop-up blockers for SharePoint sites.

Slide library and PowerPoint 2010 integration

Require ActiveX
controls, such as those that are delivered in Microsoft Office 2010, and
Firefox control adaptors. Microsoft Office 2010 does not provide a Firefox
control adaptor for this control. The user can use the following workarounds
when no control has been installed:

  • Delete a slide. Users can
    delete a slide by first clicking the slide, and then clicking
    Delete
    Slide
    . Repeat
    for each slide.

The following
features do not work on this platform:

  • Copy a slide to a
    presentation. This feature enables users to add a slide to a PowerPoint
    2010 presentation.
  • Publish a slide. This
    feature enables users to upload a single slide from a PowerPoint 2010
    presentation to a slide library. Microsoft Office must be installed on
    the client computer.

 


The specified file is not a valid spreadsheet or contains no data to import

Trying to import an Excel file in as SharePoint 2010 List resulted in the error:

The specified file is not a valid spreadsheet or contains no data to import

Double-checked the spreadsheet for formula errors, consistency etc. everything looked good but still no importo. The solution is to go to Internet Explorer > Internet Options > Security > Trusted Sites and add your SharePoint site to the list of trusted sites. You can use a *. to avoid having to list multiple subdomains, e.g. “https://*.mySharePointSite.com

The specified file is not a valid spreadsheet or contains no data to import

Be sure to disable the HTTPS checkbox if it’s not a requirement for your deployment.