Count the Number of Open Excel Workbooks
This may be the shortest post on Excel Hints to date. There are many times when you are working on your project that you may need to know the number of open workbooks open on your desktop. There is a simple way you can use a built-in Excel feature to have it do the counting for you. Take a look at the example below:
Run a Macro When Opening a Workbook
There may be a time when you want a macro to run automatically every time you open a workbook. Excel has a built in way to help with this – the Auto_Open subroutine (Workbook_Open achieves a similar result). Each time Excel opens, Auto_Open() will run only once when the workbook is open. Let’s go ahead and take a look at an example.
Read More
What Are You Looking for Help With?
As a follow up to the poll How Often Do You Use Excel Macros, to further lead the direction of Excel Hints, we asked you the question:
Are you looking for more help with Macros or Formulas?
Organize Documents with Office Live
Microsoft has a free service they offer as a solution to store, organize and share your documents online. They’ve actually just made many updates to the service, so I decided to give it a try. I just recently signed up for Microsoft® Office Live Small Business and am planning on writing a review later on the quality of the service.
Read More
Functions or PivotTable?
Microsoft’s Excel Blog has an interesting post breaking down the advantages of using either functions or pivotTables to do your analysis. There present the differences with a small example. Check out the comparison here: Analyzing Data: Functions or PivotTables
Loading ...