tag:blogger.com,1999:blog-71083057410351930242024-10-07T08:49:20.649+03:00Notes from my daily work involving SharePoint, Excel and other Office applications.Unknownnoreply@blogger.comBlogger50125tag:blogger.com,1999:blog-7108305741035193024.post-21030707856235952272015-08-27T07:57:00.004+03:002015-08-27T07:59:55.342+03:00

Surely you have already installed the Office 2016 Preview - check out this post about Excel 2016 and Power BI features on Office Blogs.

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-73822806145841710352015-08-27T07:56:00.000+03:002015-08-27T07:57:07.195+03:00

Microsoft has released Office 2016 Preview. Check it out!

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-64555437865872791642013-04-18T15:31:00.001+03:002013-04-18T15:31:16.971+03:00

Just thought of sharing links to those Excel forums I have found useful: stackoverflow Microsoft Answers MrExcel Message Board I know there tons of others too; please share your favorite Excel forum in the comments and I'll add all quality sites to a new post!

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-75898039147871646232013-04-18T10:06:00.000+03:002013-04-18T10:06:01.334+03:00

Here's my two cents for the GTD idea bucket: Remove all message arrival notifications. If you are using Microsoft Outlook, here's how to do this in Outlook 2010: Go to File -> Options Open Mail tab Uncheck all options under Message Arrival

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-51712204383776335132013-03-01T11:02:00.003+02:002013-03-01T11:02:52.601+02:00

Heres a tip how to sum value of the same cell across multiple worksheets: =SUM(Sheet1:Sheet3!B3) This sums cell B3 from Sheet1, Sheet 2 and Sheet 3 - voilá!

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-24519883642554627682012-11-05T14:00:00.002+02:002012-11-05T14:00:33.194+02:00

Scary Excel Horror Stories here.

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-66359656791394487712012-10-24T11:21:00.004+03:002012-10-24T11:21:50.985+03:00

Want to make a masked password dialog for your workbook? Check this tip from Microsoft.

Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-7108305741035193024.post-39072130536586782722012-09-28T11:48:00.001+03:002012-09-28T11:48:15.270+03:00

Chandoo posted a thorough article on tips to rounding numbers using Excel.

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-63682536075654591172012-09-19T10:37:00.000+03:002012-09-19T10:37:24.735+03:00

  I'm a big fan of week numbers. I've always had the week number visible as it's how things often are scheduled. The pics at the right demonstrate how Outlook shows the week numbers when they are set visible. However, a while ago the week numbers mystically went missing. Instead of the week number the month view showed date range (pic at the right) - which is

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-1260616523828368622012-08-20T14:04:00.003+03:002012-08-20T14:04:45.366+03:00

Since Excel 2007 we've had the "Big Grid" available - meaning over 1000 times the amount of cells than in older Excel versions. This brings challenges in keeping the performance good while amount of data and formulas increase. Read Microsoft's article Excel 2010 Performance: Improving Calculation Performance to get a better understanding of the calculation logic and how to improve you

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-7356568828868903802012-07-23T12:20:00.002+03:002012-07-23T12:20:33.714+03:00

The new Office Web Apps http://

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-84142741872263057162012-06-09T16:53:00.000+03:002012-06-26T20:12:06.816+03:00

Need help fixing or updating your Excel workbook - or perhaps a completely new tool for your business? Call or email an Excel expert at hello@excelstudio.fi or +358 45 854 3003 Visit the website at http://excelstudio.fi (site currently only in Finnish)

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-10310614085769425992012-06-08T09:37:00.003+03:002012-06-08T09:37:46.004+03:00

Ah the number of time's you've hoped that the VBA Editor's Immediate window could be attached to Excel's own window. That's not going to happen soon I think, so here's a tip how to quickly open and activate the Immediate window with some shortcut keys: Alt + F11 Ctrl + G Alt + F11 opens VBA Editor and Ctrl + G activates the Immediate window. Convenient way to help your spreadsheet editing

Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-7108305741035193024.post-29011448298626379672012-06-08T09:30:00.000+03:002012-06-08T09:30:04.005+03:00

Here's a tip how to break all external links from a workbook: Sub BreakAllLinks()     Dim arrStrLinks As Variant          ' Read workbook links to an array.     arrStrLinks = ActiveWorkbook.LinkSources(Type:=xlLinkTypeExcelLinks)          ' Loop through whole array -> all links.     For i = 1 To UBound(

Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-7108305741035193024.post-5024832316377445472012-05-30T21:08:00.002+03:002012-05-30T21:08:56.355+03:00

To quickly add current date to active cell press CTRL + SEMICOLON (i.e. CTRL + ; ) To add current time press CTRL + COLON (i.e. CTRL + : )

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-90152042765050009052012-05-28T13:30:00.003+03:002012-05-28T13:30:42.122+03:00

To remove all shapes from a sheet, use the below snippet: Sub RemoveShapes()     Dim s As Shape     For Each s In ActiveSheet.Shapes         s.Delete     Next s End Sub

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-38535808450572967982012-05-11T15:29:00.001+03:002012-05-11T15:29:38.107+03:00

To count the unique number values in a range, say for example column A, you can use a combination of SUM, IF and FREQUENCY formulas. Example: =SUM(IF(FREQUENCY(A:A;A:A)>0;1)) Check the help for more details on FREQUENCY formula.

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-12994119165667875162012-04-27T14:15:00.001+03:002012-04-27T14:15:34.490+03:00

Read Microsoft's tips how to repair a corrupted workbook. For Excel 2002 and Excel 2003.

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-53259225931972610742012-04-27T14:13:00.002+03:002012-04-27T14:14:16.604+03:00

Read Microsoft's tips how to repair a corrupted workbook. For Excel 2007 and Excel 2010.

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-66096053346131253612012-04-26T08:31:00.002+03:002012-04-26T08:45:10.093+03:00

"It worked yesterday..." Ever recall using this sentence when working with your Excel and macros? Even worse, saying this to your boss when he's looking your cool Excel dashboard you just sent him. Check the post When Good Excel Macros Go Bad from Debra Dalgleish @ Contextures for one similar journey - and how she fixed it!

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-49230372193523266142012-04-25T15:41:00.000+03:002012-04-26T08:46:26.336+03:00

To open the Save As... dialog press F12

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-58982317907066716192012-03-20T18:49:00.005+02:002012-03-20T18:49:39.104+02:00

Here's a tip from Microsoft how to import data from SQL Server into Excel, check this links

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-65132188875729572092012-03-03T21:31:00.002+02:002012-03-03T21:31:22.532+02:00

Many of us use Skype have more than one Skype accounts. The common situation is that we have one for private use and one for work. With Skype we can use multiple accounts at the same computer - though it's not an obvious thing how. Here's the tip for Windows: Start a new instance of Skype: Start -> Run, type "C:\Program Files\Skype\Phone\Skype.exe" /secondary" and click OK. Log in with your

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108305741035193024.post-34477370849093752512012-02-22T10:27:00.001+02:002012-02-22T10:33:26.746+02:00

When you need to delete rows in your spreadsheet programmatically, start from the last row and head towards the first one. This can be accomplished by using Step -1 in the For loop, see example below: For lRow = lLastRow To lFirstRow Step -1     ActiveSheet.Rows(lRow).Delete Next lRow If we would loop starting from the first row, our lRow counter would be pointing incorrectly at the

Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-7108305741035193024.post-31109771924204536702012-02-10T16:00:00.000+02:002012-02-10T16:00:11.947+02:00

If worksheet contains data, Ctrl + A selects the current region. To select entire worksheet press Ctrl + A a second time.

Unknownnoreply@blogger.com0