Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Excel formula works on one computer but not another

0

I have a formula that works on one computer but not another. Both the computers are Excel 2013.

We use this formula to take a list of items and add pricing from a separate spreadsheet.

=INDEX('Digitek Product Catalog.xls'!$H$4:$H$20000,MATCH($B4, 'Digitek Product Catalog.xls'!$B$4:$B$20000, 0)) 

When used on one computer there is an endless loop of excel asking for the Digitek Product Catalog.xls file to be opened. Once you select the file and click OK the window pops back up. Its never ending and you have force close Excel to get it to stop. I don't know enough about excel to figure out what the issue is and the person that created the formula isnt sure of the problem either. 

excelformulas-functions
MS Office Version: Excel 2013
posted by: KST3 on Thu Aug 10, 2017 at 7:24 pm
Answer
Discuss

Discussion

The code refers to the file as XLS format. In Excel 2013 it should be XLSX or perhaps XLSM. Try saving the file in one of these formats and modify the code to refer to it with this extension.
Variatus (rep: 4889) Aug 10, '17 at 7:54 pm
Add to Discussion

Answers

0

Only other thing I would add is that the other computer might automatically prevent links or it might not be able to find the Excel file that you are trying to open; so, in one computer Digitek Product Catalog is already open or is in the same directory, but, in the second computer, there might not be a Digitek Product Catalog Excel file.

posted by: don (rep: 1989) on Fri Aug 11, 2017 at 5:40 am
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login