A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

formula will not work, has changed or disappeared



 
 
Thread Tools Display Modes
  #1  
Old April 26th, 2004, 02:08 AM
Ray
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:49 AM.


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