MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Narrowing Down What Caused a Crash

January 22, 2018 - by Bob Umlas

Narrowing Down What Caused a Crash

Sometimes Excel simply gives a message along the lines of “Excel has stopped working. We are sorry for any inconvenience.”

When you get such a message, you might press Ctrl + Alt + Delete and open the workbook again (hopefully having saved whatever work you had done!), wanting to step through the code to find the offending statement. When you single-step through the code, all may work fine, but when you run it at full speed, once again it may crash. How can you find the offending statement?

continue reading »

More Reading

Can Word Hyperlink to a Specific Sheet and Cell in Excel?

Can Word Hyperlink to a Specific Sheet and Cell in Excel? »

January 19, 2018 - by Bill Jelen

Can a hyperlink in Word open a specific Excel file, jump to a sheet and jump to a cell? The syntax is fairly tricky, but it seems to work.

How to Pass Your Interview Excel Test

How to Pass Your Interview Excel Test »

January 17, 2018 - by Jennifer Feldman

Many job positions require candidates to have a mastery of Excel. Therefore, employers would like to test potential candidates during the interview process to ensure they can complete the Excel tasks that are required for the job. It is important to score high on your Pre-Employment Excel test and prove to you employer that you have what it takes to excel at the job.

read more news »

Featured Products

Supercharge Power BI

Supercharge Power BI »

If you want to be able to supercharge Power BI, you need to learn to write DAX. Data Analysis Expressions (DAX) is the formula language of Power BI and Power Pivot for Excel. This book prompts the reader to put your new skills to the test. Written to give you hands-on practice using Power BI Desktop and writing DAX.

Power Excel With MrExcel - 2017 Edition

Power Excel With MrExcel - 2017 Edition »

This is the print book edition of "Power Excel with MrExcel - 2017 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.

100 Excel Simulations

100 Excel Simulations »

Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook.

Your Excel Survival Kit

Your Excel Survival Kit »

This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.

Excel Video Medley

Excel Video Medley »

Excel Video Medley covers everything from Pivot Tables to VLOOKUP to VBA. Learn how to create scientific graphs. Use Excel for statistics.

Power Pivot and Power BI

Power Pivot and Power BI »

Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft’s tightly-related pair of revolutionary analytical tools – tools that are fundamentally changing the way organizations work with data.

see more products »