XLSread error started?

I keep getting this error
Error using xlsread (line 260)
Invoke Error, Dispatch Exception:
Source: Microsoft Excel
Description: Open method of Workbooks class failed
Help File: xlmain11.chm
Help Context ID: 0
The script worked before, I changed a few values in my excel file and now I've got this error every time.
Any ideas why?
I've tried clearing the COM ADD INs in excel, restarted my PC a few times, made sure no other programs are running the same time as matlab, my file is directly in the working directory so it isn't a file path problem, any other ideas?
It's very frustrating!

2 Comments

https://www.mathworks.com/matlabcentral/answers/35316-xlsread-error#answer_44274 might help debug the problem. See also my response right under that.
Hi Walter, Thank you for the response!
I came to my PC this morning and ran my script to find that it now works... I haven;t changed anything since last night other than restart my PC, which I also tried yesterday.
Very strange, I'm now hoping it doesn't break randomly again!

Sign in to comment.

Answers (0)

Categories

Asked:

on 19 Sep 2017

Commented:

on 20 Sep 2017

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!