Notes from my daily work involving SharePoint, Excel and other Office applications.
Tuesday, April 26, 2011
Excel VBA: How to Break Links to External Workbooks
Back in 2007 one of the prettiest pieces of VBA code was given free to the people. If you have ever needed a good programmatic way to remove all external workbook links from a single workbook, check this link.
Thursday, April 14, 2011
Top Microsoft Twitter Accounts Every Cubicle Worker Shoud Follow
@MSExcel - Official Twitter account of the product team that brings to you a little piece of software we call Excel.
@msaccess - I am Ryan McMinn a Program Manager on the Access Team; email me at ryan.mcminn@microsoft.com
@Office - Tweets to help you do more with Office at work, home and school.
@OfficeBI - Covering Microsoft's Business Intelligence products on the Office Platform including SharePoint, Excel, & Excel Services.
@Office_Live - Tweets from the team at Microsoft Office Live
@SharePoint - The SharePoint Product Group
@ch9 - Channel 9 keeps you up to date with videos from people behind the scenes building products at Microsoft.
@msaccess - I am Ryan McMinn a Program Manager on the Access Team; email me at ryan.mcminn@microsoft.com
@Office - Tweets to help you do more with Office at work, home and school.
@OfficeBI - Covering Microsoft's Business Intelligence products on the Office Platform including SharePoint, Excel, & Excel Services.
@Office_Live - Tweets from the team at Microsoft Office Live
@SharePoint - The SharePoint Product Group
@ch9 - Channel 9 keeps you up to date with videos from people behind the scenes building products at Microsoft.
Excel VBA: Remove All Conditional Formatting From Sheet
At times you may experience issues with macros when having lots of conditional formatting rules on a sheet. Here's the magic with which you can remove all conditional formatting rules from a sheet:
Sheets("MySheet").Cells.FormatConditions.Delete
Friday, April 8, 2011
Show Details On-demand in Excel
Excellent sample of how to create an on-demand details chart - by Chandoo.org.
Subscribe to:
Posts (Atom)