Microsoft Excel: Failure to launch

By J. Carlton Collins, CPA

Q. Recently, whenever I launch Excel, it no longer launches a blank workbook—only a blank screen appears (an example of which is pictured at right). How can I get Excel to open a new blank workbook upon launching the program?

A. Excel is opening a new blank workbook just fine, it's just that your workbook's worksheets are hidden. To correct this problem, from the View tab select Unhide. In the resulting Unhide dialog box, select the file labeled Book, and then click OK. Next, save the file as your default workbook as follows. From the File tab, select Save As, This PC, Documents; select Template from the Save as type box (this action will navigate the file save as location to the XLSTART folder); enter Book as the file name and click Save. Thereafter, this newly saved template will open by default whenever you launch Excel.

Bonus tip: While you are at it, you may also want to modify your file further before saving it as Excel's default template by inserting default footers with page numbers, changing the default font, adjusting column widths, adding more worksheets, turning off gridlines, and making other preference changes.

techqa4

About the author

J. Carlton Collins (carlton@asaresearch.com) is a technology consultant, a CPE instructor, and a JofA contributing editor.

Note: Instructions for Microsoft Office in “Technology Q&A” refer to the 2007 through 2016 versions, unless otherwise specified.

Submit a question

Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to jofatech@aicpa.org. We regret being unable to individually answer all submitted questions.

SPONSORED REPORT

How to make the most of a negotiation

Negotiators are made, not born. In this sponsored report, we cover strategies and tactics to help you head into 2017 ready to take on business deals, salary discussions and more.

VIDEO

Will the Affordable Care Act be repealed?

The results of the 2016 presidential election are likely to have a big impact on federal tax policy in the coming years. Eddie Adkins, CPA, a partner in the Washington National Tax Office at Grant Thornton, discusses what parts of the ACA might survive the repeal of most of the law.

COLUMN

Deflecting clients’ requests for defense and indemnity

Client requests for defense and indemnity by the CPA firm are on the rise. Requests for such clauses are unnecessary and unfair, and, in some cases, are unenforceable.