Use Excel 2013 this instance!

BY J. CARLTON COLLINS, CPA

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.

SPONSORED REPORT

Time to prepare for overtime changes

As an employer, trusted business adviser, or HR professional, you will need to be aware of exemption guidance, record requirements, advice for clients, and typical problems in applying overtime pay.

QUIZ

News quiz: Points awarded and points made

Take this short quiz to see how much you know about recent news, including an index that gauges Americans’ financial outlook and a survey that provides insight into the use of credit card travel rewards.

CHECKLIST

Bolster your data defenses

As you weather the dog days of summer, it’s a good time to make sure your cybersecurity structure can stand up to the heat of external and internal threats. Here are six steps to help shore up your systems.