If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
formula will not work, has changed or disappeared
Dave,
sorry for the delay in responding to your answer. I have been out of town doing of all things, , , , "Work",, (sorry for the use of the 4 letter word). First of all, thanks for the help and info. I looked at Debra's web pages and it gave me more info on how things work. But it was not the problem. The sheets had a lot of errors in the formula cells and I learned the it was because they did not turn on any protection for any of the formula cells. Over time, whoever was using the sheet would input information in, it would not show up in the summary sheet, so they would type over the formula cell. I had to go back several month before I learned what they were doing wrong. Every error they had started in an =countif cell where someone was adding a space behind the information. When you looked at the information it look correct, but car was car{space}, 4 letters, not 3. I had to check every formula and then I protected everything but the info input cell. Everything works for now. Thanks again, Ray On Mon, 19 Apr 2004 21:55:20 -0500, Dave Peterson wrote: Does this mean that you can't find it, but it may still exist--or you looked and it doewsn't exist? If it's the first, Debra Dalgleish has some pictures at: http://www.contextures.com/xlfaqMac.html#NoMacros that may help locate macros. If it's the second, I don't have another guess. Ray wrote: On Fri, 16 Apr 2004 22:27:49 -0500, Dave Peterson wrote: I've never seen excel do this. Any chance your friend has a macro "helping out"? Good idea, but I can not find any macro. ray |
Thread Tools | |
Display Modes | |
|
|