ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I erase a formula that affect all spreadsheets in a workboo (https://www.excelbanter.com/excel-discussion-misc-queries/73704-how-do-i-erase-formula-affect-all-spreadsheets-workboo.html)

lgreen

How do I erase a formula that affect all spreadsheets in a workboo
 
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?

Doug Kanter

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

"lgreen" wrote in message
...
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?


How do you know it's a formula?



lgreen

How do I erase a formula that affect all spreadsheets in a wor
 
I don't. I guess I was assuming. What else could it be?

"Doug Kanter" wrote:


"lgreen" wrote in message
...
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?


How do you know it's a formula?




Doug Kanter

How do I erase a formula that affect all spreadsheets in a wor
 
We'll need to know what you mean by "changing every row 14". Changing it in
what way?

"lgreen" wrote in message
...
I don't. I guess I was assuming. What else could it be?

"Doug Kanter" wrote:


"lgreen" wrote in message
...
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?


How do you know it's a formula?






lgreen

How do I erase a formula that affect all spreadsheets in a wor
 
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
on every spreadsheet.

"Doug Kanter" wrote:

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

"lgreen" wrote in message
...
I don't. I guess I was assuming. What else could it be?

"Doug Kanter" wrote:


"lgreen" wrote in message
...
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?

How do you know it's a formula?








All times are GMT +1. The time now is 02:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com