This was working fine a few minutes ago then all the sudden it
stopped. None of the drop down lists are working. I have multiples set
up on a sheet. some are accessed locally on the sheet and some draw
from another sheet in the workbook using =Address1 as the Name. But I
can't get any of them to work now! Please Help I have to finish this
project tonight!!!

I'm not an expert and others may advise better, but I think having your data
on another workseet may be the problem

Rob

wrote in message
ups.com...
This was working fine a few minutes ago then all the sudden it
stopped. None of the drop down lists are working. I have multiples set
up on a sheet. some are accessed locally on the sheet and some draw
from another sheet in the workbook using =Address1 as the Name. But I
can't get any of them to work now! Please Help I have to finish this
project tonight!!!

Shouldn't matter if i'm calling it by defined name



On Apr 18, 2:26 am, "Rob" wrote:
I'm not an expert and others may advise better, but I think having your data
on another workseet may be the problem

Rob

wrote in message

ups.com...

This was working fine a few minutes ago then all the sudden it
stopped. None of the drop down lists are working. I have multiples set
up on a sheet. some are accessed locally on the sheet and some draw
from another sheet in the workbook using =Address1 as the Name. But I
can't get any of them to work now! Please Help I have to finish this
project tonight!!!

Well you may be right, but I'm not convinced. I just have a memory of
reading in previous newsgroup answers that this was a problem.

Rob


wrote in message
ups.com...
Shouldn't matter if i'm calling it by defined name



On Apr 18, 2:26 am, "Rob" wrote:
I'm not an expert and others may advise better, but I think having your
data
on another workseet may be the problem

Rob

wrote in message

ups.com...

This was working fine a few minutes ago then all the sudden it
stopped. None of the drop down lists are working. I have multiples set
up on a sheet. some are accessed locally on the sheet and some draw
from another sheet in the workbook using =Address1 as the Name. But I
can't get any of them to work now! Please Help I have to finish this
project tonight!!!

Check out Debra Dalgleish's site:
http://contextures.com/xlDataVal01.html#Name

Then you can test it.

Rob wrote:

Well you may be right, but I'm not convinced. I just have a memory of
reading in previous newsgroup answers that this was a problem.

Rob

wrote in message
ups.com...
Shouldn't matter if i'm calling it by defined name



On Apr 18, 2:26 am, "Rob" wrote:
I'm not an expert and others may advise better, but I think having your
data
on another workseet may be the problem

Rob

wrote in message

ups.com...

This was working fine a few minutes ago then all the sudden it
stopped. None of the drop down lists are working. I have multiples set
up on a sheet. some are accessed locally on the sheet and some draw
from another sheet in the workbook using =Address1 as the Name. But I
can't get any of them to work now! Please Help I have to finish this
project tonight!!!



--

Dave Peterson

Checked out the site, Dave. I think I used to have similar problems with
Office 97 and I thought it was due to the data being on another sheet. Ever
since I change that I had no more problems. I think too that naming ranges
tends to slow down calculations, but again that was on an early version.
Maybe the later versions handle this better and I'll test that for sure.

Rob

"Dave Peterson" wrote in message
...
Check out Debra Dalgleish's site:
http://contextures.com/xlDataVal01.html#Name

Then you can test it.

Rob wrote:

Well you may be right, but I'm not convinced. I just have a memory of
reading in previous newsgroup answers that this was a problem.

Rob

wrote in message
ups.com...
Shouldn't matter if i'm calling it by defined name



On Apr 18, 2:26 am, "Rob" wrote:
I'm not an expert and others may advise better, but I think having
your
data
on another workseet may be the problem

Rob

wrote in message

ups.com...

This was working fine a few minutes ago then all the sudden it
stopped. None of the drop down lists are working. I have multiples
set
up on a sheet. some are accessed locally on the sheet and some draw
from another sheet in the workbook using =Address1 as the Name. But
I
can't get any of them to work now! Please Help I have to finish this
project tonight!!!



--

Dave Peterson

wrote
This was working fine a few minutes ago then all the sudden it
stopped. None of the drop down lists are working.

Recollect a recent posting by Bob Phillips to try "Open and Repair" in
XL2003. Click File Open, navigate to folder, select the file, then click
the arrow dropdown on the right of the "Open" button choose "Open and
Repair". Good luck !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

On Apr 18, 4:13 am, "Max" wrote:
wrote
This was working fine a few minutes ago then all the sudden it
stopped. None of the drop down lists are working.

Recollect a recent posting by Bob Phillips to try "Open and Repair" in
XL2003. Click File Open, navigate to folder, select the file, then click
the arrow dropdown on the right of the "Open" button choose "Open and
Repair". Good luck !
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---

I'm on a mac and I don't have this option

Weird things can happen if your cells with data|validation are merged.

Are they?



wrote:

This was working fine a few minutes ago then all the sudden it
stopped. None of the drop down lists are working. I have multiples set
up on a sheet. some are accessed locally on the sheet and some draw
from another sheet in the workbook using =Address1 as the Name. But I
can't get any of them to work now! Please Help I have to finish this
project tonight!!!

--

Dave Peterson

No, they're not. Oddly enough, I sent this to my boss and asked him to
check it and he says everything is working fine...???? but it still
isn't on my computer



On Apr 18, 8:06 am, Dave Peterson wrote:
Weird things can happen if your cells with data|validation are merged.

Are they?

wrote:

This was working fine a few minutes ago then all the sudden it
stopped. None of the drop down lists are working. I have multiples set
up on a sheet. some are accessed locally on the sheet and some draw
from another sheet in the workbook using =Address1 as the Name. But I
can't get any of them to work now! Please Help I have to finish this
project tonight!!!

--

Dave Peterson

Have we established what "not working" means?

The DV dropdowns are there but cannot change selection?

The DV dropdown arrows don't show?

Maybe you have turned on ToolsOptionsViewObjects "hide all"


Gord Dibben MS Excel MVP

On 18 Apr 2007 08:53:58 -0700, wrote:

No, they're not. Oddly enough, I sent this to my boss and asked him to
check it and he says everything is working fine...???? but it still
isn't on my computer



On Apr 18, 8:06 am, Dave Peterson wrote:
Weird things can happen if your cells with data|validation are merged.

Are they?

wrote:

This was working fine a few minutes ago then all the sudden it
stopped. None of the drop down lists are working. I have multiples set
up on a sheet. some are accessed locally on the sheet and some draw
from another sheet in the workbook using =Address1 as the Name. But I
can't get any of them to work now! Please Help I have to finish this
project tonight!!!

--

Dave Peterson

Not working means the drop down arrows show, but when clicked the list
doesn't pop up. I might as well be clicking air.
I'm using excel 2004 for mac and something keeps triggering it. I
figured out 1 of them.

If you have a column of data valitdation cells and you click
autofilter, it disables the lists. Even if you unclick autofilter. I
had to copy and paste the work book to a new workbook and fix all the
formulas.


On Apr 18, 12:14 pm, Gord Dibben <gorddibbATshawDOTca wrote:
Have we established what "not working" means?

The DV dropdowns are there but cannot change selection?

The DV dropdown arrows don't show?

Maybe you have turned on ToolsOptionsViewObjects "hide all"

Gord Dibben MS Excel MVP

And what version of excel are you using (where it fails) and what version of
excel is your boss using?

If you're using xl97 and have the data|validation above the frozen panes line,
this could cause trouble.

wrote:

No, they're not. Oddly enough, I sent this to my boss and asked him to
check it and he says everything is working fine...???? but it still
isn't on my computer

On Apr 18, 8:06 am, Dave Peterson wrote:
Weird things can happen if your cells with data|validation are merged.

Are they?

wrote:

This was working fine a few minutes ago then all the sudden it
stopped. None of the drop down lists are working. I have multiples set
up on a sheet. some are accessed locally on the sheet and some draw
from another sheet in the workbook using =Address1 as the Name. But I
can't get any of them to work now! Please Help I have to finish this
project tonight!!!

--

Dave Peterson

--

Dave Peterson

On Apr 18, 1:22 pm, Dave Peterson wrote:
And what version of excel are you using (where it fails) and what version of
excel is your boss using?

If you're using xl97 and have the data|validation above the frozen panes line,
this could cause trouble.



wrote:

No, they're not. Oddly enough, I sent this to my boss and asked him to
check it and he says everything is working fine...???? but it still
isn't on my computer

On Apr 18, 8:06 am, Dave Peterson wrote:
Weird things can happen if your cells with data|validation are merged.

Are they?

wrote:

I'm using excel 2004 (mac) and he's using 2003

This was working fine a few minutes ago then all the sudden it
stopped. None of the drop down lists are working. I have multiples set
up on a sheet. some are accessed locally on the sheet and some draw
from another sheet in the workbook using =Address1 as the Name. But I
can't get any of them to work now! Please Help I have to finish this
project tonight!!!

--

Dave Peterson

--

Dave Peterson