Excelguru Help Site - Downloads

Knowledge Base Articles By Category

Access - ADO (4)

Access - SQL (4)

Access - VBA Programming (10)

Downloads - Games (1)

Downloads - Learning Aids (11)

Downloads - Utilities (6)

Excel - ADO (4)

Excel - Charts and Data Visualization (1)

Excel - Formulas (8)

Excel - General Tips (36)

Excel - Interactive Pages (9)

Excel - PivotTables (11)

Excel - PowerPivot (6)

Excel - SQL (4)

Excel - UDF (7)

Excel - User Interface Customization (2)

Excel - VBA Programming (48)

Excel - WebApp (4)

Internet Explorer - VBA Programming (1)

Novell Groupwise - VBA Programming (2)

Other - General (0)

Outlook - General Tips (5)

Outlook - VBA Programming (7)

PDF Creator - VBA Programming (11)

PowerPoint - VBA Programming (7)

Publisher - VBA Programming (7)

Syndicated Articles (7)

Training Products (3)

Word - VBA Programming (8)

Downloads - Utilities
XLG File Tools Add-in

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2012-04-04 05:36 AM Number of Views: 3234

XLG File Tools is a FREE add-in which was created to increase the functionality of Excel and address the plethora of extra clicks that were introduced begining in Excel 2007. It's current feature set is designed to make the job of opening existing files and creating new files more efficient.

XLG File Tools is easy to use, and is guaranteed to make you more efficient. In addition, it's a snap to install and requires no administrative priviledges to do so.
...

Read More
Data Validation in Excel Services

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2011-03-08 08:09 PM Number of Views: 547

I’m a huge consumer of Data Validation in Excel. At this point, however, Excel services (the Excel webApp) is still so new that there are very few of the techniques that we normally use in Excel which are web compliant. This article looks at ways that we can implement data validation into an Excel services solution.
...

Read More
Disable the Excel Compatibility Checker

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2008-09-25 05:14 AM Number of Views: 13789

I've received several comments on my blog that people dislike Excel 2007's Compatibility Checker, and would like to turn it off globally. While it's true that you can turn it off for each workbook, the main user interface seems devoid of a way to actually tell Excel that you never want to check your workbooks for compatibility when saving to 2003 or earlier versions. ...

Read More
Text to Speech Utility - Proof Reader for Excel 2007 (and higher)

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2008-05-06 08:52 PM Number of Views: 2805

Introduction
This is a very simple add-in that adds a button to the Review tab's Proofing group, allowing the user to have Excel read the selected cells back to them aloud. ...

Read More
XLG Favourites Add-in

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2006-09-20 08:41 PM Number of Views: 3273

XLG Favourites
This add-in was created to increase the functionality of Excel and address some shortcomings in the "Most Recently Used Files" listing. While we can increase the list to hold 9 items, I frequently use more than that many files during one of our month ends. It's also well known that long file names get abbreviated and difficult to read. This add-in addresses these issues, among other things. ...

Read More
UseTemplate Add-in

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2006-08-31 06:56 AM Number of Views: 1620

Templates Addin
This addin was created to increase the functionality of Excel, and make it easier to use templates in the MS Office system. I use a lot of templates, and got tired of having to make up to six clicks to open one. Now, I have a menu that holds all of my MS Office templates (not just Excel), only three clicks away. ...

Read More

Recent Forum Posts

Help with charting. How to use only last 15 rows after updating.

Ok, so I know how to make the chart update automatically when new data is entered, but how do I use only the last 15 rows as the data points? I don't...
Aaronp Today, 07:00 AM

Additional Questions

This looks awesome, however I realized I need to be more specific with how exactly the data is being pulled.

The container # is pulled into...
emartz Yesterday, 09:45 PM

IF AND Statement with ISBLANK and conditional

Hi
Sorry - I messed up trying to change the sheet from .xlsm to .xlsx. This new attachment should be OK....
Hercules1946 Yesterday, 05:56 PM

Attachment does not open

Hi There-

Can you re-send the attachment in a different format by any chance?
When I tried opening the file it gave me the...
emartz Yesterday, 05:17 PM

Error Message?

I get a message telling me 'Type Mismatch'. What am i doing or not doing right? As my user name would suggest i am a rookie at VBA and the more complex...
excelrookie Yesterday, 02:48 PM

Knowledge Base Articles By Category

Downloads - Utilities

Recent Forum Posts