How do I erase a formula that affect all spreadsheets in a workboo

L

lgreen

There is a formula that is changing every row 14 on all of the spreadsheets
in my workbook. I can't find the formula, and have tried to look for it by
viewing the formulas in all the spreadsheets. Any suggestions?
 
D

Doug Kanter

lgreen said:
There is a formula that is changing every row 14 on all of the
spreadsheets
in my workbook. I can't find the formula, and have tried to look for it by
viewing the formulas in all the spreadsheets. Any suggestions?
Click to expand...

How do you know it's a formula?
 
D

Doug Kanter

We'll need to know what you mean by "changing every row 14". Changing it in
what way?
 
L

lgreen

All of the spreadsheets list job titles, with each spreadsheet having
different job titles listed on it. However now, every spreadsheet, on row
14, says "VP" instead of what was originally on that line. The first
spreadsheet in the workbook is supposed to say "VP" on row 14, but now all of
them do. I have manually corrected it and saved those corrections, but if I
close it and open it up later, it has reverted back to saying "VP" on row 14
 
Top