• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel 2003 Format Question

B

BDawg

Lifer
One of my users is complaining that on random Excel spreadsheets Excel is calculating wrong.

I did some investigating and figured out that she's created a column of formulas. When she highlights the column and then drags the handle to the right it's copying the content of the cells and not the fomulas.

You can then click the options on the bottom right and change it to copy formatting and it's right, but this shouldn't be the default action.

I took her workbook and duplicated the problem on Excel 2003 and XP. If I create a new spreadsheet, I don't see the problem.

Therefore, I think she's inadvertantly changed a setting that makes copy the data the default action.

Where would I go to change this back for this workbook?
 
Can you explain this more? What is the user's preferred outcome for the copied columns? Does she want the formulas to copy over (ie, a column with A1+A2 in cell A3 should copy over to column B as B1+B2 in cell B3). And you're saying all she sees in cell B3 is just the VALUE that was in A3?

Very weird problem. I'm not able to recreate it.
 
In this example, she would copy the formula from A1 all the way through A4. Then, she would copy the column of formulas from the As to the Es.

She was seeing the value from A1 copied and not the formula.

She did find what the problem is though. She somehow changed options/calculation so it was set to manual from automatic. I wonder if there's a key combination she could've hit to change that.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top