Use Excel 2013 this instance!

BY J. CARLTON COLLINS, CPA
May 1, 2013

Q: When I open two Excel files in two instances of Excel and display them on two monitors, I find that I cannot then copy formulas back and forth between the files—only the formula’s calculated value is pasted to the other instance of Excel. What’s happening here, and what can I do about it?

A: This particular question was asked and answered in the May 2011 topic “An Excellent Arrangement,” (page 70) but I am revisiting this topic to inform you that Excel 2013 now opens each Excel file in its own instance of Excel (just like Word has always done), making it easier to display separate Excel files on separate monitors and to copy data back and forth between files with formulas intact.

PROFESSIONAL DEVELOPMENT: EARLY CAREER

Making manager: The key to accelerating your career

Being promoted to manager is a key development in a young public accountant’s career. Here’s what CPAs need to learn to land that promotion.

PROFESSIONAL DEVELOPMENT: MIDDLE CAREER

Motivation and preparation can pave the path to CFO

CPAs in business and industry face intense competition to land a coveted CFO job. Learn how to best prepare yourself for the role.

PROFESSIONAL DEVELOPMENT: LATE CAREER

Second act: Consulting

CPAs are using experience to carve out late-career niches. Learn how to successfully make a late-career transition to consulting, from CPAs who have done it.