Convert spreadsheet and VBA code to Excel 2013

I'm following the guidelines for the conversion, but without success. The conversion procedure keeps opening the file system and asking me for file references, that I see no reason for. Then when the macros run, they come up with Name and other errors and complain that the refs are in other files. Don't get that. Any ideas ?
LVL 17
krakatoaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Robberbaron (robr)Commented:
not enough info.

need to post your workbook with dummy data for us to test,
0
krakatoaAuthor Commented:
Sorry, cannot post the workbook.

I'm really looking for some help on why the conversion asks for values to be updated from other worksheets, while there are no references to any other worksheets/books anywhere in it, so I am looking for generic tips mainly.
0
Robberbaron (robr)Commented:
you must have linked files somewhere or references.

1. open workbook.  Data menu / see if the Edit Links option is available. if so, you have linked workbooks that may no loger be referenced in the worksheets themselves.

2. Open Developer Tab... Visual Basic.  now look at Tools menu, references.
Chances are there is a reference to an old version of XL or office library. eg Excel 12,0 or Office 12.0..  Deselect and select the current one from the list.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

krakatoaAuthor Commented:
Thanks - I'll be having a look at that suggestion itnf. Sorting out a glitch in smthg before I can do that.
0
krakatoaAuthor Commented:
Hi Robberbaron

the Data Edit Links is greyed out. As for the References, these are the only ones showing :

References in Developer menu
0
krakatoaAuthor Commented:
Lol - pretty peculiar! Without changing anything since I first posted on this, and since coming back to the question with my last comment to simply report the settings as I show above, I weirdly now see that it HAS decided to do the conversion with no further intervention on my part. Very odd.

I anyone wants to comment, please do, otherwise I will close the question soon. Thanks and sorry for the long wait.
0
krakatoaAuthor Commented:
It didn't work in my case, but deserves points as it's probably technically correct otherwise.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.