[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Convert spreadsheet and VBA code to Excel 2013

Posted on 2014-08-15
7
Medium Priority
?
174 Views
Last Modified: 2014-09-12
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 ?
0
Comment
Question by:krakatoa
  • 5
  • 2
7 Comments
 
LVL 32

Expert Comment

by:Robberbaron (robr)
ID: 40266034
not enough info.

need to post your workbook with dummy data for us to test,
0
 
LVL 17

Author Comment

by:krakatoa
ID: 40266542
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
 
LVL 32

Accepted Solution

by:
Robberbaron (robr) earned 1000 total points
ID: 40269655
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 17

Author Comment

by:krakatoa
ID: 40279453
Thanks - I'll be having a look at that suggestion itnf. Sorting out a glitch in smthg before I can do that.
0
 
LVL 17

Author Comment

by:krakatoa
ID: 40319726
Hi Robberbaron

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

References in Developer menu
0
 
LVL 17

Author Comment

by:krakatoa
ID: 40319872
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
 
LVL 17

Author Closing Comment

by:krakatoa
ID: 40320271
It didn't work in my case, but deserves points as it's probably technically correct otherwise.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question