ExcelBanter - Formula is being added automatically

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula is being added automatically (https://www.excelbanter.com/excel-discussion-misc-queries/155990-formula-being-added-automatically.html)

Andrew G

Formula is being added automatically

I have a spreadsheet that our office uses to calculate payroll hours. When
different users open it up (it is a shared worksheet) some formulas will
automatically copy. What would be causing this?

Pete_UK

Formula is being added automatically

Under Tools | Options | Edit (tab) there is an option "Extend list
formats and formulas". This is probably checked.

Hope this helps.

Pete

On Aug 27, 10:44 pm, Andrew G <Andrew
wrote:
I have a spreadsheet that our office uses to calculate payroll hours. When
different users open it up (it is a shared worksheet) some formulas will
automatically copy. What would be causing this?

All times are GMT +1. The time now is 08:54 PM.