Drop down box dissappeared

[poleuser]

I created a spreadsheet and used several Validation lists with drop down boxes. I then decided to add this particular spreadsheet to another work book using Edit, Move or Copy sheet. I moved the sheet to a another open work book. I lost all my drop down boxes although the lists are still there. Is there anyway to get the drop down boxes back?

 

[Jan De Messemaeker]

Hi,

It is more likely you get an answer in an Excel Newsgroup; this one is for
MS project.

Greets,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620

I created a spreadsheet and used several Validation lists with drop down

boxes. I then decided to add this particular spreadsheet to another work
book using Edit, Move or Copy sheet. I moved the sheet to a another open
work book. I lost all my drop down boxes although the lists are still
there. Is there anyway to get the drop down boxes back?

 

[Gérard Ducouret]

Hello,

This is a Microsoft Project news group. You would have better post to the
Excel news group.
Nevertheless, I tried 2 differents ways to do that, and they work both :
- Select All then Copy, switch to the other workbook and Paste.
- Drag and Drop of the sheet tab from a file to another

Hope this helps,

Gérard Ducouret

I created a spreadsheet and used several Validation lists with drop down

boxes. I then decided to add this particular spreadsheet to another work
book using Edit, Move or Copy sheet. I moved the sheet to a another open
work book. I lost all my drop down boxes although the lists are still
there. Is there anyway to get the drop down boxes back?