Stop autocorrecting

Occasional Visitor

Hello! I am trying to figure out how to do the following:


- i have a budget spreadsheet with 2 tabs.

The first is where my employees enter their costs and the second is comprised of formulas that organize the costs


HOWEVER - when myself or anyone adds new costs, the outputs change in teh formulas sheet based on whatever cell was changed.


basically - i need the formulas to stay with whatever cell they were originally using rather than chang

1 Reply



Can you post copies of the spreadsheets in question (so long as they contain no proprietary information). It would help immensely to be able to see them as your descriptions leave a lot of questions to be answered. Use OneDrive or GoogleDrive if you can't post here in this forum; then post a link to the files here,