Excel startup errors and speed problems

There are several things that can affect the speed of Excel or cause startup problems. I've found five good sites that discuss these problems and offer solutions: Chip Pearson: Startup Errors In Excel Microsoft: How to troubleshoot startup problems in Excel David McRitchie: Slow Response, Memory Problems, and Speeding up Excel JKP: Fixing Startup problems Contextures: Answers to Frequently Asked Questions ...

New version: August 29, 2006

A new version of ASAP Utilities is available: 4.0.3 (August 29, 2006). Major reason for this release are a few bugfixes, two new worksheet functions and an expanded description of the utilities. New worksheet function: =ASAPExtractNumbers(ref) This function extracts the numbers from a given range or value. New worksheet function: =ASAPStripNumbers(ref) This function strips the numbers ...

ASAP Utilities has a new website and a logo

ASAP Utilties new logo

ASAP Utilities has a new website and a logo. The previous website has been used from 2001 until august 2006. We are really enthusiastic about the new website. And we hope you are as excited about the new look of the ASAP Utilities website as we are. About new logo After thinking for a long time we have ...

Problems after a recent Microsoft upgrade?

After installing a recent Microsoft upgrade a few people have been unable to use the ASAP Utilities. This is because somehow Excel has put ASAP Utilities on the "disabled items" list. To solve this to: "Help" > "About" in the Excel menu. Then click on the disabled items button and when ASAP Utilities is listed there, enable ...

New version: 3 august 2006

list filenames

A new version of ASAP Utilities is available: 4.0.2 (3 august 2006). Major reason for this release is an added funtionality to the "Insert filename..." utility, overall accelerator keys (hotkeys) in the menu and a few bugfixes. Fill » List filename... When creating a list of all filenames in a folder you can now choose whether you ...

New version: 31 july 2006

A new version of ASAP Utilities is available: 4.0.1 (31 july 2006). I have also updated the User Guide. Major reason for this release is a few bugfixes. New worksheet formula: =ASAPSheetName() Returns the name of the sheet the formula is placed on. System » Rename current file If you specified a filename of a ...

New version: 29 june 2006 – end of beta!

A new version of ASAP Utilities is available: 4.0.0 (29 june 2006). Major reasons for this release were a few bugs that have been reported the past week. I've also use the opportunity to remove the beta status. I have not officially released this new version on the main ASAP Utilities website. However I do believe it is ...

New version: 22 june 2006

A new beta version of ASAP Utilities is available: 3.11.ab beta (22 june 2006). Major reason for this release were problems in combination with Excel 2000. The merge files or import Excel file made Excel 2000 produce errors or crash. I have created a workaround for this. (the command workbooks.open makes Excel 2000 crash if it is ...

New version: 21 june 2006

A new beta version of ASAP Utilities is available: 3.11.aa beta (21 june 2006). Last week version 3.11.z was silently released. I updated the download page but couldn't find the time to write a post about it. So here are the major changes in comparison to version 3.11.y in the new 3.11.aa. These are the major changes: Sheets » ...

Comments are open again

I'm back from a few days of mountainbiking in the Dutch Mountains (hills...). Comments are no longer held for moderation, unless the spam filter holds them. The past days 184 spam-comments have been placed. If I have some spare hours I will update the comment-module with better spam-protection. WordPress already has some nice tools: codex.wordpress.org/Combating_Comment_Spam. Tommorrow I'm ...