Category Archives: Uncategorized

Word: This document contains links that may refer to other files

If Thor had an office job, his desk would be a pile of splinters….Possibly one of the most annoying warnings in Microsoft Word is the warning “This document contains links that may refer to other files” when you open a document. It doesn’t matter if you choose Yes or No, you will continue to be prompted every time you open the file.



You can turn off the warning altogether…by going to the File menu, Options, Advanced, then scroll down to the General section and untick the box beside “Update automatic links at open”.



Whilst this won’t resolve the cause, it will stop the warning from popping up next time, for any Word document.  The gotcha is every user must set the same option in their installation of Microsoft Word.

To identify links used in your document you can expose the “Edit Links to Files” function.  You can expose this by going through File, Options, Quick Access Toolbar, select “File Tab” in the “Choose Commands From” dropdown, find the function “Edit Links to Files” and select “Add”.


This will explose the following icon in the Quick Launch Menu where you can view links to other files.





The Mosdal Support Kit

Mosdal is not the name of the Android in the current Star Trek film, rather it is a support kit useful for troubleshooting issues with Microsoft Online Services.

Try it here … a quick download and install on your local PC, then enter your Microsoft Online account, perform your intended operations, then wait a few minutes while the tool goes and collects data and presents you with some detailed test results.

A tool in this style, would be great for troubleshooting Kerberos issues….

Pass Summit 2012 – BI Session Snap !

With just over a week now until Pass Summit 2012, its time to review some of the cool sessions to go to in the Business Intelligence track ! 

Around the World with the SharePoint BI Toolbelt (BID-212-S)
BI Information Delivery
Brian Knight (Pragmatic Works)

Dashboard Design: Making Reports Pop (BID-305)
BI Information Delivery
Paul Turley (SolidQ)

Building Self-Service BI Apps Using PowerPivot and Excel (BID-205-M)
BI Information Delivery
Diego Oppenheimer (Microsoft)

BI Architecture with SQL Server 2012 and SharePoint 2010 (BIA-318)
BI Platform Architecture, Development & Administration
Rod Colledge (StrataDB)

Dashboards: When to Choose Which MSBI Tool (BID-206)
BI Information Delivery
Melissa Coates (Intellinet)

Mobile BI with SSRS and SharePoint (BID-200)
BI Information Delivery
Angel Abundez (DesignMind)

Mobile Business Intelligence (BID-302-M)
BI Information Delivery
Jen Underwood (Microsoft)
Carolyn Chau (Microsoft)
John Sirmon (Microsoft)

Mobile Business Intelligence for Everyone, Now! (BID-102)
BI Information Delivery
Jen Stirrup (Copper Blue Business Intelligence)

Zero to BI Semantic Model with SQL Server 2012 (BID-399-P)
BI Information Delivery
Peter Myers (Bitwise Solutions)

10 Extraordinary Things to Achieve with Integration Services 2012 (BIA-322-S)
BI Platform Architecture, Development & Administration
Peter Myers (Bitwise Solutions)
Matthew Roche (Microsoft Corporation)

Configuring Kerberos for SharePoint 2010 BI in 7 Steps (BIA-304-M)
BI Platform Architecture, Development & Administration
Chuck Heinzelman (Microsoft)


Add a Secondary Y Axis to Your SSRS Charts


Add a secondary Y Axis to your Reporting Services Chart quickly and easily as follows….

First, add the 2nd value to your chart as another series.  Now right click on the new series in the chart area, and select Series properties.  In the Axes and Chart Area tab, under Vertical Axis select “Secondary”.


What is the latest service pack or cumulative update for SQL Server ?



Previously I had published a link to my favourite SQL Server version site but it seems the boys at SQL Team no longer have the latest and greatest link.

Check out this link that provides a nice pivot table view of all the latest service packs for each edition of SQL Server. The page includes a detailed view of the cumulative updates for each major edition.  If you click on each service pack edition, and you will go straight to the official Microsoft page where you can find out more detailed information about the relevant KB for the release.

There is also a blow by blow list of updates in chronological order you can check regularly if you get bored of

Happy patching !