Search results for query: *

Hello, We have an excel'97/2000 worksheet that everyone needs to work in. We can not make it shared. Sometimes, one person opens it, works on it and leaves it open forever. Is there any way, we can force the worksheet to close automatically after a set interval of time? Thanks. Sushil S.

Hello, I am working in excel'97. One of the pre-defined values goes into each individual cell from A1 to A50. e.g. out of a list of values like- red, yellow, green, blue- every cell has to contain one of these colours(values). What I want is- instead of manually typing the value in each cell...

Hello, I work on an Excel 2000 sheet and I have to update this sheet every 15-30 minutes, so I always leave this sheet open on my PC (Excel sheet is worked and saved on a local shared drive). We have a local networking. But no one else updates this sheet except me. Is there a way that the...

Hello, I have an IBM NetVista 2284-48U, came preloaded with WinMe on AMD Duron. Trouble is- IBM has something in the BIOS, which won't let me use XP or W2K on the same pc. It gets installed but then pc freezes constantly. I have wasted numerous months experimening with that and now I am back...

Hello, I am using excel 2000 and have a range of cells from A1:E1, which needs to be compared with values in A2:E2 and then count the result. A1:E1 is- 21,24,18,19,25 A2:E2 is- 20,20,20,20,20 The formula I have is- =COUNTIF(A1:E1,">=A2:E2"), which returns 3. The above formula...