Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
lgreen
 
Posts: n/a
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Doug Kanter
 
Posts: n/a
Default 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?


  #3   Report Post  
Posted to microsoft.public.excel.misc
lgreen
 
Posts: n/a
Default 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?



  #4   Report Post  
Posted to microsoft.public.excel.misc
Doug Kanter
 
Posts: n/a
Default 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?





  #5   Report Post  
Posted to microsoft.public.excel.misc
lgreen
 
Posts: n/a
Default 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?






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Unable to set the Formula property of the Series class" with a tw PeterQ Charts and Charting in Excel 1 February 15th 06 07:37 PM
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 05:30 AM
adding row to forumla carrera Excel Discussion (Misc queries) 9 August 23rd 05 10:24 PM
How do I link 12 spreadsheets without exceeding the max formula l. Joseph E. Excel Worksheet Functions 1 February 12th 05 12:42 AM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 04:37 PM


All times are GMT +1. The time now is 07:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"