Solved How do I make an Excel 2007 worksheet work in Excel 2013?

October 31, 2014 at 09:32:04
Specs: Windows 7
I have a spreadsheet that I put on a group drive for another region of the state to use. This spreadsheet was done in Excel 2007. It was working fine until the other region updated their Excel to 2013. Now the other region is having trouble with the spreadsheet; namely the drop-down boxes are showing that there are no values, but there should be a list of people in the list. When I open the spreadsheet it works fine. Because the other region is four hours away, I can't just go and look at it on their computer. Is there something that the other region (or that I) need to do to make the spreadsheet compatible with Excel 2013?

See More: How do I make an Excel 2007 worksheet work in Excel 2013?

Report •


#1
October 31, 2014 at 10:54:41

Report •

#2
October 31, 2014 at 11:10:59
Thank you for the link; however, my problem is the opposite of what was described. My spreadsheet was actually started in 2007 but won't work correctly in 2013. I think that I might have already done what this answer suggests:
"If you name the ranges of the lists you are using and then use those names when sourcing the lists for the cells."
My source for the drop-down box says this: "=names!A1:A28". Is this what the previous answer suggests by "naming the range"? As you can see, the list is on another sheet


Report •

#3
October 31, 2014 at 11:50:49
✔ Best Answer
To answer your specific question:

"My source for the drop-down box says this: "=names!A1:A28". Is this what the previous answer suggests by "naming the range"? "

What they mean by "naming the range" is to select the range (names!A1:A28) and then click in the name box above Column A. Enter a name for the range, such as MyRng and press Enter. Make sure you press Enter to set the Name. Don't just click out of the name box because the Name won't stick.

Now, instead of using =names!A1:A28 as your source in Data Validation, you would use =MyRng

Anytime you refer to MyRng in a formula within that workbook, you will actually be referring to names!A1:A28.

Do some Google searches on Named Ranges for more info on the feature.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

Related Solutions

#4
October 31, 2014 at 12:03:36
thank you for your help. I'll try to name the range

Report •

#5
October 31, 2014 at 12:24:56
Well I just named the range and it worked perfectly. Thanks!

message edited by Secretary


Report •

#6
October 31, 2014 at 12:42:11
thank you so much. This worked perfectly!

Report •

Ask Question