Problem with fully accessing Microsoft Excel drop-down file

Asked By Maureen Austin 0 points N/A Posted on - 01/21/2012

 

I have a certain drop-down loaded file which was filled out and created in Excel 2007, and is also accessible in Excel 2010. Currently, I have Excel 2007. When the file was sent back to me, the values I entered are accurate and are in the right cell rows and columns.

But I’ve noticed a problem that I can’t resolved. The drop-downs on the Excel file no longer works. I’ve attempted to save it as a 2007 file. It didn’t work. Next, I tried to email it but still it didn’t work.

Lastly, I’ve done flash driving but I got the same outcome.

Do you have any idea to make the drop downs become active once again?

Please help me. Thank you so much! 

• Status: Open
• Question Views: 1061
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Abe Bryan 20 points N/A #110711

Problem with fully accessing Microsoft Excel drop-down file

Hello Maureen,

My first guess was to see if the file is locked but on a second thought, i realized that you wouldn't be able to work with the file in first place if it were locked, right ?

You might want to have a look here on this forum. Could it be the case that the person you sent this file to, mistakenly froze the dropdown panes ?

In that case, as suggested on the forum, you can simply unfreeze the panes from the window menu. Also i assume that the person you sent the file to, has a copy of it, in email or on hard drive. You can also check if your excel program has a bug.

You can check that by opening other excel files with dropdown menu on your desktop. 

I hope that helps.

Abe.

About Abe Bryan

Questions
0

Answers
40

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 01/23/2012
• Question Category: MS Excel