Home
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
Run-time error on opening existing spreadsheet (1 viewing) (1) Guest
Use this forum to discuss any problems, user suggestions or any other issue regarding the XLC software.
Go to bottom Favoured: 0
TOPIC: Run-time error on opening existing spreadsheet
#3562
kvswright (User)
Tadpole (Junior Boarder)
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Run-time error on opening existing spreadsheet 1 Year, 8 Months ago Karma: 0  
I get the following error when I have ExcelCalcs turned on and I open an existing workbook:
Run-time error '13': Type Mismatch from Visual Basic.


It happens with some workbooks and not others. And it doesn't seem to matter if the workbook has any ExcelCalcs objects in it.

However, if I have a new workbook open, and then open any existing workbook, I do not get the error message.

Any assistance in solving this issue would be appreciated!
 
Logged Logged  
  The administrator has disabled public write access.
#3563
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1747
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:Run-time error on opening existing spreadsheet 1 Year, 8 Months ago Karma: 493  
Could you attach a sample spreadsheet so that I can try to reproduce the error on my machine. Then I'll be able to get to the bottom of this. Thanks for reporting it in.
 
Logged Logged  
 
  The administrator has disabled public write access.
#3564
kvswright (User)
Tadpole (Junior Boarder)
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Re:Run-time error on opening existing spreadsheet 1 Year, 8 Months ago Karma: 0  
Here is a file that gives the error message when opened.
File Attachment:
File Name: TestXLC1.xlsx
File Size: 16421
 
Logged Logged  
  The administrator has disabled public write access.
#3566
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1747
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:Run-time error on opening existing spreadsheet 1 Year, 8 Months ago Karma: 493  
I am afraid I cannot reproduce the error. I opened the file successfully. Have you tried opening the file when XLC is disabled (Excel>Options>Addins>Manage>Go). Does it still give the error?
 
Logged Logged  
 
  The administrator has disabled public write access.
#3569
wlmoon (User)
Tadpole (Junior Boarder)
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Re:Run-time error on opening existing spreadsheet 1 Year, 8 Months ago Karma: 0  
I just installed the software and have the same issue. I tried your idea of turning off XLC calcs through the options/add-in. When it is turned off I do not get any error messages. It seems that opening any spreadsheet gives me the runtime error except for when a new spreadsheet is already open. The error doesn't seem to be causing any issues though, more of just an annoyance. Once "End" is selected, I have full use of the XLC calcs and regular software features.
 
Logged Logged  
  The administrator has disabled public write access.
#3570
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1747
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:Run-time error on opening existing spreadsheet 1 Year, 8 Months ago Karma: 493  
"It seems that opening any spreadsheet gives me the runtime error except for when a new spreadsheet is already open" This comment is very helpful and I will try to reproduce it. Could you tell me which version of Excel you are running?

When a file is opened XLC checks to see if it contains any XLC functions and it ensures that they refer to the installed version on you machine which may change location from user to user. I can imagine that if a file is not open this may cause a hiccup. It seems that the work around would be to keep at least one workbook open in Excel.
 
Logged Logged  
 
  The administrator has disabled public write access.
Go to top
We have 13 guests and 39 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.

 

 

Google Analytics Alternative