You have downloaded this file 0 times in the last 24 hours, limit is 100.
Your file downloads total 0 in the last 24 hours, limit is 20.

XLC Add-In for Excel
 
This location is for Registered Users Only.
Perhaps you need to login or register.

Description:

This file can be downloaded by subscribers to our free trial account!

Description - XLC software enhances MS Excel so that cell formulae can be displayed as mathematical equations and your worksheets read like textbooks.

To install XLC download and run XLC_Ribbon_setup.exe. XLC works with Windows versions of Excel - 2007, 2010, 2013 & 2016 (both 32 bit and 64 bit versions are supported). It does not work on any Mac, web or reduced versions of Excel. Any installation problems please browse to the installation directory (usually ‘C:\Program Files (x86)\XLC’) and open XLC.xlam directly. Also check that the XLC Add-In is activated Excel> File> Options> Add-Ins> Manage Excel Add-ins Go button. XLC.xlam must be in "Trusted Locations" Excel>Options>Trust Center then "Trust Center Settings ..." and select "Trusted Locations".

Users with older versions of Excel can install XLC Toolbar (Excel 2000 & 2003).

XLC Pro - No watermarks or hyperlinks.XLC Pro Mode & XLC Ed - If you use XLC for commercial purposes you need to pay for a paid XLC subscription. One subscription is required for each XLC user. Choose an XLC paid plan and no restrictions apply to XLC or the ExcelCalcs site whilst your subscription is active. You will be prompted to renew your subscription just before it expires. If you allow your paid XLC subscription to expire XLC continues to work but it reverts to a restricted trial mode (see below). How to configure XLC in the XLC Pro mode.

XLC Ed - Watermarks and hyperlinks to ExcelCalcs.comXLC Trial Mode - The following restrictions apply.

  • XLC is strictly for non-commercial use.
  • XLC renders some equations with a watermark stating "Non-commercial use."
  • XLC renders equations with a hyperlink to the ExcelCalcs site.
  • XLC disables the following button Delete XLC Functions“Delete XLC Functions”.
  • No Repository downloads.
We are very grateful to users who support us by choosing our XLC paid subscription plan. Your fees pay for software development, new repository calculations and site enhancement. 

 

 "This standalone tool makes generation of equations directly from cell formulae’s in the smartest and fastest way." Freedownloadscentre Editor's review.

"With this add-in, you can finally turn those cryptic Excel formulas into recognizable mathematical equations." Vertex42 Five Star Review

"an addin that displays excel formulas symbolically for easy checking and for presentation. Displaying formulas is a real kick!" Eng-Tips Forum Five Star tip.

"I've had a play with it and it's great, it's driven me nuts for years having to do all my equations in equation editor and then update them when things change". Institute of Mechanical Engineers Forum Administrator

"The best thing about XLC is that equations are a really great check on the cell formula. It's easy to make a mistake with Excel formulas but its easy to see where you have gone wrong when you check against equations." Debbie_Williams.

"

"

"What a great plug-in I have been looking for something like this for years. Highly recommended!" jhardy.

If you still need convincing take a look at all comments from existing site users.


Submitted By:
John Doyle (JohnDoyle[Admin])
Submitted On:
17 Sep 2017
File Size:
647.22 Kb
Downloads:
8368
File Version:
16.05.25
File Author:
John Doyle
Rating:
Total Votes:45
Comments: 1074
Yannam 5 months ago
Hi John,
I am unable to download the XLC addin at work, Is there an alternative way to get the add-in? I use Excel 2016.

Thanks,
Heinzig 6 months ago
Thanks John! Really appreciate the effort you've put into this forum. As a 1 man engineering office, I really appreciate high quality Excel based content you, Alex and others have contributed. Mark
JohnDoyle[Admin] 2 years ago
Any installation problems please browse to the installation directory (usually ‘C:\Program Files (x86)\XLC’) and open XLC.xlam directly. Also check that the XLC Add-In is activated Excel> File> Options> Add-Ins> Manage Excel Add-ins Go button. XLC.xlam must be in "Trusted Locations" Excel>Options>Trust Center then "Trust Center Settings ..." and select "Trusted Locations".
Let me know the details of any error messages you might encounter.
Capel 2 years ago
same problem here
Any solution?
thanks !
JohnDoyle[Admin] 2 years ago
Hi Priit - I am afraid that currently you can't. So as a work around use Excel's find/Replace function to set 'EqnStyle=2' (i.e text rather than graphic) and then redraw all equations.
priit 2 years ago
I would like to make "EqnStyle= 2" as a default style.
How could I do that? [img size=728]https://www.excelcalcs.com/media/kunena/attachments/legacy/images/Screenshot_170427_1408.png[/img]
JohnDoyle[Admin] 2 years ago
Please refer to this [url=/frequently-asked-questions/excelcalcs-faqs/repository-downloads-have-%23name-errors/]frequently asked question[/url]. This will help.
rpisano 2 years ago
Sorry, but all files i've downloaded that use the UND OVD functions get #:S NAME? as result. I'm using EXCEL 2007 (italian version.
Thanks for the help
JohnDoyle[Admin] 3 years ago
Priit maybe you could send me the file and I'll take a look at it. I'll send you my personal email address so you can send it to me privately if you wish.
priit 3 years ago
I apologize for not answering sooner, I have been busy.
What more information could I provide?
I have Windows 10 Pro Version 1607 Build 14393.479 64 bit
I have Microsoft Office 365 64bit - About Excel says 2016 MSO (16.0.7426.1015) 64 -bit
I have only one active add-in: XLC
P.S. On my new calculations I use EqnStyle= 2, but my older calculations do not. So when I update them I am in trouble.
JohnDoyle[Admin] 3 years ago
Priit finally configured a machine but I am afraid when I hit the redraw button all the equations they were rendered correctly. Please see screenshot below. [img size=600]https://www.excelcalcs.com/media/kunena/attachments/legacy/images/NoErrors_xls.png[/img]
There must be something peculiar about your installation of Excel that is giving rise to this odd behaviour but I am puzzled to think what it might be.
JohnDoyle[Admin] 3 years ago
Sorry Priit for not getting back sooner. I have had some trouble setting up a machine to test this. Give me a little while longer and I'll get back to you later today.
priit 3 years ago
Any news?
JohnDoyle[Admin] 3 years ago
Right click on the tab then selecting insert raises Excel's native Insert Form from where I can select worksheet and a new worksheet is inserted. This is Excel functionality and is the same when I do it on a machine with XLC installed and without XLC installed. So I still suspect that your problem is unrelated to XLC.
BMT Structural 3 years ago
You have to hold the pointer over the tab at the bottom of the workbook to do this - I'm still using Excel 2010 so it may be something they have changed.
JohnDoyle[Admin] 3 years ago
If I right click on the worksheet and select "Insert..." I am asked if I want to shift cells right, left, insert a whole row or whole column. Something odd is happening with your Excel but I do not think it is at all related to XLC. I hope this helps.
BMT Structural 3 years ago
If I right click on one of my new ExcelCalcs tabs as per the image, then select insert I am able to select another template from Excel but when I insert it nothing happens (but I can hear the HDD trying to do something). There is no error message, it just doesn't happen.
After some experimenting I have discovered that it is not all ExcelCalcs files that do this so I think you are right that it is something external, possibly to do with different versions of Excel (some templates are 97-2003, some are later). [img size=616]http://www.excelcalcs.com/media/kunena/attachments/legacy/images/Capture-21126733d698423a721e6f44bedbffc0.PNG[/img]
JohnDoyle[Admin] 3 years ago
There is absolutely no loss of functionality, including the ability to insert new worksheets (tabs) when XLC is installed. I would be happy to take a look at the problem if you wish to attach an example. I suspect it is some other issue.
BMT Structural 3 years ago
With ExcelCalcs running I am unable to insert new sheets (tabs) into an existing workbook. If I delete the ExcelCalcs items in the spreadsheet it then allows me to insert another tab. Is this a known feature? In the past I have typically compiled calculations into a single .xls file (up to 50 separate sheets) for easy printing.
JohnDoyle[Admin] 3 years ago
Excel 2013 introduced a native function called FORMULATEXT() which displays the cell formula of reference cell. Perhaps this will give you the functionality you are looking for?
The purpose of our XLC software is to make auditable engineering calculations using Excel displaying cell formulas as mathematical equations. If you follow the work around I suggest then a hard print of the document will produce auditable engineering calculations suitable for third party scrutiny.
priit 3 years ago
Then it is not better than just writing the equation myself. I hoped that I was missing something.
Engineering calculations have a lot of situations when you have to take the minimum value from set of calculated values....
JohnDoyle[Admin] 3 years ago
Sorry for a bit slow on the uptake Priit. I understand your problem now. Unfortunately XLC only allows you to name single cells so the use of a multiple cell range like B2:B5 will not be rendered. The range B2:B5 covers cells with XLC names of b, c, d and e.
As a work around you create two cells one containing the formula =MIN(B2:B5) and name this cell 'Min_b_e' and another cell containing the formula =MAX(B2:B5) and name this cell 'Max_b_e'. If you use these in subsequent formulas the the names 'Min_b_e' and 'Max_b_e' will be displayed in xlc equations.
I hope this makes sense to you.
priit 3 years ago
Fail attached [file name=xlc_min_max.xlsx size=15602]https://www.excelcalcs.com/media/kunena/attachments/legacy/files/xlc_min_max.xlsx[/file]
JohnDoyle[Admin] 3 years ago
Priit, can you attach a sample and I'll take a look?
priit 3 years ago
The question is not about "," in name. For me the problem is that when using excel min or max function XLC does not show xlcnames in equations. [img size=515]https://www.excelcalcs.com/media/kunena/attachments/legacy/images/Screenshot___23-88d4441d8ca2767ce02a5af63d93a4f2.png[/img]
JohnDoyle[Admin] 3 years ago
Equations can be shown in an algebraic form or a numeric form using this button [img]/images/stories/XLC/icons/NumAlgSwitch.png[/img][b]Algebra/Number[/b]. This is documented on our [url=/help-and-tutorials/]help page[/url].
XLC may have difficulties rendering equations when the cell name includes a "," character as it is a delimiter symbol used by all Excel functions. Could you rename the cells without the "," character?
priit 3 years ago
It should read =min(bw,1;bw,2)
Second row should read =min(490;500)
Is there anyway I could accomplish that?
If i use min with range so ":" between numbers then it shows the formula =min(b35:b37) in cells E33 and E34. [img size=694]http://www.excelcalcs.com/media/kunena/attachments/legacy/images/Screenshot___23.png[/img]
JohnDoyle[Admin] 3 years ago
Priit - I have just loaded the document up in Excel 2013 32 bit on a Windows 10 machine and re-rendered all the equations correctly so it looks like a problem with Excel 2016 64bit. I need to set up a machine to investigate this further. Please bear with me.
priit 3 years ago
Please find attached sample file [file name=error.xlsx size=22380]https://www.excelcalcs.com/media/kunena/attachments/legacy/files/error.xlsx[/file]
JohnDoyle[Admin] 3 years ago
Could you attach a sample Excel file which I can examine?
priit 3 years ago
It messes up my all old calculations as well when I update. [img size=558]http://www.excelcalcs.com/media/kunena/attachments/legacy/images/Screenshot___22.png[/img]
priit 3 years ago
Excel 2016 64bit @ Windows 10 w anniversary update [img size=267]http://www.excelcalcs.com/media/kunena/attachments/legacy/images/Screenshot___16.png[/img]
JohnDoyle[Admin] 3 years ago
As stated in the description above "XLC works with Windows versions of Excel - 2007, 2010, 2013 & 2016 (both 32 bit and 64 bit versions are supported). It does not work on any Mac, web or reduced versions of Excel." I'm sorry currently we do not have any plans for a mac version.
Klaassimon 3 years ago
Hi,

Is there an Apple version for this program? Exe files are not working on my Apple MacBook.

Thanks
JohnDoyle[Admin] 3 years ago
Setup file signed the installer with a certificate from a Certificate Authority Comodo. No program changes.
Despite this I am aware that new Windows SmartScreen shipping with Windows 10 triggers a warning "Windows SmartScreen prevented an unrecognized app from starting, Running this app might put your PC at risk." It is possible to override the warning and proceed to install XLC. I am investigating ways of preventing this warning but in the meantime please be assured that our software is completely safe to install.
JohnDoyle[Admin] 3 years ago
I'm glad that's got you up and running. I have continued adding some other run time protection errors - download the latest version 16.03.28 :)
JohnDoyle[Admin] 3 years ago
A little more error protection code has been added (for additional protection against run-time errors).
smgranger 3 years ago
Thanks John, in the newer version I was able to go into the debugger and see the line that threw the error. It appears that the type mismatch was with the release code (my mistake). It's up and running now.
JohnDoyle[Admin] 3 years ago
I have made added some error protection features to address an issue [url=/option,com_kunena/Itemid,145/func,post/do,subscribe/catid,21/id,3585/]reported in the forum[/url]
JohnDoyle[Admin] 3 years ago
[url=/repository/xlc-addin-for-excel/xlc-ribbon/]A new version of XLC is available v16.03.27[/url]. I have added some further error trapping code but as I can't reproduce the error I am working a little blind here. Please let me know if there is an improvement.
JohnDoyle[Admin] 3 years ago
I'm afraid I can't reproduce the error on my machine. I will try to add some further error protection code and put up a new version.
smgranger 3 years ago
If I have XLC installed and enabled and I don't have any Excel windows open, I get the run-time error when I open Excel (blank document or existing). Opening subsequent instances of Excel does not throw an error.
JohnDoyle[Admin] 3 years ago
Can you tell me the exact sequence of events to reproduce the error?
smgranger 3 years ago
I'm having the problem with the latest version.
JohnDoyle[Admin] 3 years ago
I hope this issue has been [url=/component/option,com_kunena/Itemid,145/func,view/id,3562/catid,21#3562/]already solved in another thread in the forum[/url]. You just need to install the [url=/repository/xlc-addin-for-excel/xlc-ribbon/]latest version of XLC[/url].
smgranger 3 years ago
I get Run-time error '13': Type Mismatch from Visual Basic when I open Excel (new document or existing). I've tried updating to the newest version of XLC and reinstalling. When I disable XLC (File>Options>Add_ins>Go), the error goes away. The error only appears when I open Excel the first time (no other instances open), click on about half of the buttons on the XLC ribbon, or click "Check Release Code" in settings.
If I open a new file and setup a simple a*b=c calculation, the EQS command for the 'c' cell will not return an error, it just appears blank (the command is still there, but the cell appears blank until you edit it).
I'm running Windows 8.1 Pro with Excel 2013.
Thanks for your help!
kvswright 3 years ago
Installed latest version and issue disappeared! Thanks for putting out a quick fix!
wlmoon 3 years ago
All fixed. Thanks very much
gossinnov 3 years ago
Thanks very much, I have just un-installed XLC and then downloaded your latest one and installed that, and you have fixed it.
I don't know if this might shed a bit more light on things, but the only thing I have really changed (apart from installing windows 10) is to add a "personal.xlsb" file to the system in order to have couple of handy macro's always available. I started fiddling around with this to see if I could fix it but now that I have put your new version on the error is not there any more, so I don't know if this was the culprit or not.
Anyway thanks very much for your fix
JohnDoyle[Admin] 3 years ago
[url=/component/option,com_remository/func,fileinfo/id,847/]Download latest version of XLC[/url]. I have added some error protection features and it may have resolved this issue. I cannot reproduce the error so I am working in the dark a little. I would be very grateful if anyone could tell me if this issue is solved.
JohnDoyle[Admin] 3 years ago
I have made added some error protection features to address an [url=/option,com_kunena/Itemid,145/func,post/do,subscribe/catid,21/id,3562/]issue reported in the forum[/url]
JohnDoyle[Admin] 3 years ago
Very weird I am also running Excel 2013 but on Windows 10. I followed your instructions exactly but did not generate the error.
wlmoon 3 years ago
I am running Excel 2013 on Windows 8.1 Pro. I just did another little test: Open blank workbook, change one cell, save to desktop, close excel. Open that same workbook and I get the error.
JohnDoyle[Admin] 3 years ago
Try and try as I might I cannot reproduce the error on my machine. This makes it impossible to debug. If anyone can give can list the specific sequence of events to reproduce the bug I would be very grateful.
JohnDoyle[Admin] 3 years ago
"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.
wlmoon 3 years ago
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.
JohnDoyle[Admin] 3 years ago
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?
kvswright 3 years ago
Here is a file that gives the error message when opened. [file name=TestXLC1.xlsx size=16421]http://www.excelcalcs.com/media/kunena/attachments/legacy/files/TestXLC1.xlsx[/file]
JohnDoyle[Admin] 3 years ago
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.
kvswright 3 years ago
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. [img size=399]http://www.excelcalcs.com/media/kunena/attachments/legacy/images/Capture-593cb24b30d101e0edcbca48209e76a9.PNG[/img]
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!
JohnDoyle[Admin] 3 years ago
I can confirm that the software works with Excel 2007 but problems with the Korean character set may mean that it does not work for you.
To uninstall Start>Programs>XLC>Uninstall XLC
Nasa 3 years ago
Pls advise me how to uninstall XLC.
Nasa 3 years ago
Everything is not working. Including "Insert Equation"
When I pressed the button "Insert Equation", the results were illegible characters written.
I'm trying to version up with the IT guy. If I have similiar problem, I'll inform you.
Thank you for your following up.
JohnDoyle[Admin] 3 years ago
Apart from the 'Settings'button does XLC function correctly?
JohnDoyle[Admin] 3 years ago
It may be an issue with the Korean version of Excel 2007 - it is very hard for me to tell as I don't have a copy. It works on US and UK versions of Excel 2007 but I have not checked this in a while as I no longer run Excel 2007. I will install it and check it out. If there are any problems I will get back to you.
Nasa 3 years ago
XLC setting does not work with the message : [Microdoft Visual Basic Complile error : AboutXLC]
I'm using Excel 2007 Korean Version.
peachsb 4 years ago
Hey John. FYI I installed XLC on 2016 as well. I am using Windows 10 Pro. x64 and Office Pro. My ribbon would not load automatically. I went to the add-in opt-in box (under options, add-ins, Manage, etc.). I have several other add ins listed already, but XLC was not listed, so it could not be selected. As such the ribbon wasn?t loaded. After reinstalling a few times for good measure, from the opt-in box, I clicked on ?Browse? and browsed to the XLC.xlam file in the Program files (x86) off *root* drive ("C:\Program Files (x86)\XLC" for me). After doing so it appears to work fine, but I have only checked a few things.
JohnDoyle[Admin] 4 years ago
I am also running Excel 2013. ATVBAEN.xlam is one of the Excel analysis tool packs. It should not throw an error but it could be errors in other add-ins that stops XLC loading. It may be worth deactivation all other add-ins to see if XLC appears on the ribbon.
olgamarin 4 years ago
All that I already did.
I forgot to say that excel is 2013.
The problem is I have to run XLC.xlam each time I open excel. I can see that excel tries to open a file named ATVBAEN.xlam or something similar (is very quick and I cannot read it well): the message is: opening ATVBAEN.xlam (100%) but ribbon is not displayed, no other messages.
JohnDoyle[Admin] 4 years ago
The actually installation directory will make no difference so it is fine running from File programs(x86) even though you are running in 64 bits.
It seems that XLC is installed correctly but does not load when Excel starts up. A good work around is to start Excel and simply open XLC.xlam. Alternatively look to Excel's add-in management tools that are found Excel>File>Options>Add-Ins then find Manage Excel Add-ins and hit the Go button. If XLC is not shown in the Add-Ins available list then use the browse button to load it.
I trust this is helpful.
olgamarin 4 years ago
After installing XLC again I found:
1-XLC was installed in File Programs but excel search in folder File Programs(x86). # of bytes o.k.
2-The system is 64 bits, even though I installed XLC again in File Programs(x86)
3-The ribbon doesn´t appear when I run excel. I have to go to the folder and run it.
4-After running directly from the folder the Ribbon appears but I get a message teeling that part of the program was delete it.
5- XLC appears to run o.k. (off course I am no t sure about that) and I don´t want to run XLC every time I open excel.
6-System is Windows 7 /Proccesor core i7
7-Macros are allowed in excel and XLC is checked as a complement.
JohnDoyle[Admin] 4 years ago
It may be that there is some corruption of the installation file. I'd download it again and check that the file is 532.21 Kb in size. Then reinstall it.
olgamarin 4 years ago
Trying to open de xlam file I get a notice asking to repair the file or let open the macros in it. I let to run the macros and the file apparently was repair but a second notice says:
"Registros quitados: Rango con nombre de /xl/workbook.xml parte (Libro) parte (Libro)"
Translation:
Records removed: Rango con nombre de /xl/workbook.xml part (book)
I run excel again, the addin is there and checked but the ribbon still doesn´t appear.
JohnDoyle[Admin] 4 years ago
The default installation directory is C:\Program Files\XLC can you browse to that directory and open the file XLC.xlam. Please report back any error messages you encounter. This may help me work out what's going on.
olgamarin 4 years ago
I cannot see XLC Ribbon. Addins are ok, the box for XLC is checked when I go to "go command".
JohnDoyle[Admin] 4 years ago
Installed XLC on Excel 2016 without a hitch. It is fully functional and working I am pleased to report. Remember to check that Excel>File>Options>Add-ins then look for 'Manage' and hit the GO button. XLC should be listed just make sure it is checked too.
JohnDoyle[Admin] 4 years ago
Give me a little time and I will look into this. I have yet to install Excel 2016 on my machine. I'll report back in a day or so.
Quarry 4 years ago
I am using Excel 2016. I have downloaded the ribbon and installed. The XLC tab is not showing up when I open Excel. Is this not yet compatible with Excel 2016?
JohnDoyle[Admin] 4 years ago
XLC for the Mac hit the rocks. There seems to be no way of customising the toolbar. It is possible to extend the menu system but this is considered inferior to the XLC toolbar/ribbon you can customise in the windows version of Excel.
dano2664 4 years ago
Just thought I'd bump this topic. It's been over a year since any mention of XLC support of MS Excel for Mac 2011. Any update? I'd really like to be able to use this for my engineering masters work - it will help significantly when my instructors need me to show my work.
Thanks in advance for any update!
JohnDoyle[Admin] 4 years ago
Some issues were corrected regarding AutoXLC functionality. If you use this feature of the program then I suggest you update your copy of XLC.
JohnDoyle[Admin] 4 years ago
The work around is just to use equations with two lines one above the division line and one below the division line. In the example below you could write the term for a6 over three lines and just use 'a' terms (and one division line above another). However using XLC I need to stick to two line and introduce a new variable 'b'. I hope this helps.
[img size=193]https://www.excelcalcs.com/media/kunena/attachments/legacy/images/NestedOVDUND.png[/img]
JoshuaTurley 4 years ago
What was the work around? Was it just using the equation editor and manually putting the equation in?
JohnDoyle[Admin] 4 years ago
Hi Pratto. Trial subscribers generally [url=/repository/xlc-addin-for-excel/xlc-ribbon/]download XLC by following this link[/url]. They get access to only two download directories, [url=/repository/add%11ins/]Addins[/url] and [url=/repository/trial/]Trial[/url], to see how the download process works. All the plans are [url=/compare-subscription-plans/]compared here[/url] and are [url=/subscriptions/]individually described here[/url].
pratto 4 years ago
I went thru the registration process, and i think the free trial selection, but i can't see what happens next. it doesn't seem very helpful to trial subscribers. how do i download what i need to to see if it works on my computer ?
JohnDoyle[Admin] 4 years ago
Yes it will work fine with all versions of windows on both 32 and 64 bit. Sign up for a trial account and you can install the software for free and satisfy yourself that it runs without a hitch.
vcock 4 years ago
Hellow
I am interested in the XLC Pro program, I want to know if it works well in windows 7 prefessional 64 bits,
JohnDoyle[Admin] 4 years ago
Hi Tim - In Excel goto the File>Options>Addins and press the "Go" button. Do you see XLC Addin for Excel? Is it enabled?
timmccarthy 4 years ago
Just paid the annual subscription and loaded xlc, several times, but cannot see the tab referenced as to be in the ribbon, and therefore cannot enter the unlock code I have received. Pls advise,
Thx!
JohnDoyle[Admin] 4 years ago
Tony Brodie and Mathew Moore reported that XLC threw a runtime error when the 'About XLC and Settings' button was clicked. This has been corrected in the latest version.
priit 4 years ago
Yes - my problem seems to be fixed.
Thank you
JohnDoyle[Admin] 4 years ago
The latest version fixes the workbook calculation setting problem [url=/option,com_kunena/Itemid,145/func,post/do,subscribe/catid,21/id,3477/]reported in by Priit[/url].
JohnDoyle[Admin] 4 years ago
Priit - I have just uploaded a [url=/repository/xlc-addin-for-excel/xlc-ribbon/]new version of XLC[/url] with a bit more error trapping. I'm hoping it will fix your problem. I can't check this myself because I could not reproduce your error so I would be grateful if you could let me know if it fixes it.
priit 4 years ago
I uninstalled XLC.
Excel started with calculations automatic.
Reinstalled XLC and Excel turned to manual mode again.
I did not open any old workbooks, just new ones.
priit 4 years ago
This problem occurs with every excel workbook (blank ones , new). Is there any point sending a blank workbook?
As I wrote in first message, "disable the XLC addin " did the trick.
But I would like to use the XLC addin :) and also would like to have automatic calculation turned on :)
JohnDoyle[Admin] 4 years ago
As a work around you can also disable the XLC addin using Excel> Options> Addins and run the addins manager. Un-checking XLC will disable the workbook open code.
JohnDoyle[Admin] 4 years ago
I can't reproduce the problem here but I can introduce some error trapping that would make the code more robust. Would you like to send me your spreadsheet and I'll see if I can reproduce your error and see if the error trapping solves the problem?
JohnDoyle[Admin] 4 years ago
Hi Priit well the short answer to your question is yes XLC runs some code every time you open a work book. It does this to make sure that XLC functions are correctly referenced (currently the functions live in the addin but older workbooks reference an external function library which is now only used in the toolbar version of the program).
When the code is executed the first thing it does is save the workbook calculation setting. Then it sets it to manual and runs some code (as it runs quicker in the manual calculation mode). Once the code is run it sets it back to the saved setting.
I am going to run a few checks on this Priit to double check that everything is working as we intend it to.
priit 4 years ago
Every time I start Excel the Workbook Calculation is set to "manual".
I tried saving the workbook when set to Automatic, as Excel should remember the last state.
Nothing helped until I disabled XLC addin. After that Excel started behaving normally.
Toggling XLC addins "Auto XLC" does not have any effect.
Any suggestions?
Does XLC addin run any macro on startup?
Does XLC addin change excel template workbook?
XLC 15.03.16 on Excel 2007 @Win 7 64bit. [img size=443]https://www.excelcalcs.com/media/kunena/attachments/legacy/images/Screenshot___27.png[/img]
Polecat 4 years ago
John,
I found the problem.
Thanks anyway.
JohnDoyle[Admin] 4 years ago
Can you send me a sample worksheet using XLC and I will take a look.
Polecat 4 years ago
I installed the release code that was sent to me in the Settings window as instructed, then exited and reloaded Excel. I then entered an equation, but there was no response from XLC. I also clicked on Insert Equation and other functions, but they do not respond.
What am I doing wrong?
priit 4 years ago
I did a uninstall and reinstrall.
At the moment it seems to work fine.
And now even with xlc auto turned on , it does not take so long.
priit 4 years ago
File does not matter.
If I uninstall xlc, then this "refresh" goes away. [file name=test.xlsx size=33294]https://www.excelcalcs.com/media/kunena/attachments/legacy/files/test.xlsx[/file]
JohnDoyle[Admin] 4 years ago
If auto XLC is switched off then no equation redraw will be triggered unless you hit the Redraw Equations button. You could send attach the file and I'll be happy to have a look into what is causing the problem?
priit 4 years ago
I have XLC auto turned off.
Everytime I open an axcel file, it seems to redraw all equations.
Depending on the file, it can take some time. And its little frustrating to wait.
Can I turn this feature off?
Running MS Excel 2007 @ Win 7 64bit
reyyankhalid 4 years ago
I have contributed an excel sheet for disc brake calculations under
Home> Calculations> Strength> Wind & Snow> Disc Brake Calculations
(couldn't had any other option to post it)
I want to know that how will I get the subscription now?
Reply in this regard will be highly appreciated.
Thankyou.
JohnDoyle[Admin] 4 years ago
Long time XLC user Keith Sharp reported in a bug when opening a protected Worksheet. XLC needs work with unprotected worksheets and now issues a warning if a protected workbook or worksheet is opened.
JohnDoyle[Admin] 4 years ago
The error message "XLC is curently blocked (is your worksheet protected or are you editing a cell?)" is sent out when when you hit an XLC button when you are currently editing a cell.
Bruteanu 4 years ago
Hello John,
I just join the ExcelCalcs in order to try its equation functionality.
I did try to implement a simple equation in XLC and got a message
like: XLC is currently blocked ... .As my worksheed is not protected
it appears that I cannot edit a cell in the XLC trial mode ..
So my question is: how can I try this ??
To try or not to try ... :)
I am very very interested in that kind of functionality from a teacher's
point of view ..
Thanks in advance
2BMerchant 5 years ago
Hi John
I'm fairly fresh to XLC - a good add-in by the way - but I am having a bit of trouble; clicking the Auto XCL button on the ribbon doesn't seem to work. The rest of the commands seems to work manually, ie they work when I am in the relevent cell and I click the ribbon button.
I think it is a compatibility issue with Excell settings. Any suggestions?
Regards
JohnDoyle[Admin] 5 years ago
Just go to the Windows start button All Programs>XLC>Uninstall XLC. Thanks for your comment it may help other users.
rlowry 5 years ago
Sorry but this program did not do what I thought it would. Can you please tell me how to remove it from my computer? Thanks. I could not find any information about removing it using your search.
JohnDoyle[Admin] 5 years ago
Yves - do you see the XLC part of the ribbon? If you can't the the program has not installed correctly. Can you find any of the files on your computer by default it will install to "C:\Program Files (x86)\XLC" there you will find XLC.xlam. Can you tell me what happens when you load this file into Excel.
yvesrossignol 5 years ago
I always have the following error:
Name????
yvesrossignol 5 years ago
Hi, I use Excel 2013 in 64 bits and XLC software are installed in the 32 bits program file. I have a window 7 french and excel french too!.
It is impossible to have XLC working, i try in administrator, restart computer, etc...
help me
Yves
JohnDoyle[Admin] 5 years ago
The procedure is [url=/frequently-asked-questions/excelcalcs-faqs/how-to-configure-xlc-in-the-xlc-pro-mode./]here in the FAQs[/url].
AbubakrMohamed 5 years ago
Dear Sir

How to enter my release code, please give me clear procedures.

Thanks
brownden 5 years ago
:laugh: :ohmy:
The solution has been provided thanks John and Steven YES the version of excel needs to be 2010, the errors occur using version 2007. Thanks for your time and patience with me.
Denis
JohnDoyle[Admin] 5 years ago
This is often asked and we offer some solutions in our [url=/frequently-asked-questions/excelcalcs-faqs/trouble-with-units?/]FAQs[/url]
gdb041 5 years ago
How do you change units in a download from SI to American?
brownden 5 years ago
I have just purchased the software and have done a trial design using the Steel Angle spreadsheet. The results are all#N/A as you can see from the attached. What is the issue as I do not see where the problem exists. [file name=Steel_Angle_Lintel_L2_Design___Version_2.xlsx size=222365]http://www.excelcalcs.com/media/kunena/attachments/legacy/files/Steel_Angle_Lintel_L2_Design___Version_2.xlsx[/file]
JohnDoyle[Admin] 5 years ago
I had some problems with the previous character it seemed to be the same as "*" and XLC was confused by it. How about trying the following:
Windows shortcut Alt +02DF (don't forget to type the "+" key) [img size=538]https://www.excelcalcs.com/media/kunena/attachments/legacy/images/alt33d.png[/img]
JohnDoyle[Admin] 5 years ago
Thankfully Windows has already given us a shortcut:
Alt +66D Hold down the alt key then "+", then "6", then "6", then "D" and release the alt key.
Jake.B 5 years ago
Thanks John.
The Arabic five point star seems to work quite nice. [img size=550]https://www.excelcalcs.com/media/kunena/attachments/legacy/images/Arabic_five_point_star.PNG[/img]
Any chance of a keyboard shortcut such as |066D or something similar could be added in a future XLC release?
Regards Jake
JohnDoyle[Admin] 5 years ago
Jake
As you have hinted at "*" is a pretty special character and I can't think of a quick fix to resolve your problem. However I can recommend that you take a good look at all the [url=http://symbolcodes.tlt.psu.edu/bylanguage/mathchart.html]alternative characters that are available for you to use[/url].
gkstarns 5 years ago
John,
I am very much looking forward to a release of ExcelCalcs for the Mac! Please keep us posted.:)
Jake.B 5 years ago
Hi John,
The majority of structural calculations I undertake are for ultimate limit state. Design actions are generally denoted by using the superscript '*'. Unfortunately, XLC treats the '*' symbol in variables names as a multiplication operation and renders accordingly. [img size=370]/media/kunena/attachments/legacy/images/XLC_Request.png[/img]
Is it possible to extend the rendering capabilities of XLC so that it detects if a '*' symbol is used in a variable name (and if it is super scripted) and render them correctly? I currently use the superscript '#' as a work-around however having support for the '*' symbol in variable names would make presentation of the calculations even nicer.
I thought I should post this on the forum to see if the above would benefit/effect any other users.
Keep up the great work.
Regards Jake
JohnDoyle[Admin] 5 years ago
For a long time it was not possible to develop add-ins for Excel Macbook but I think this may have all changed in Excel 2011 Macbook. We are bringing in a macbook to explore the possibility of porting XLC to the Macbook. I'll be a duck out of water for a while but I'll see what we can do and keep you posted of any progress.
RogerBlain 5 years ago
I can't seem to find any discussion on how to install XLC on this version of Excel ?
I think it is an excellent product, and have a lot to contribute, but must get it working under Mac
JohnDoyle[Admin] 5 years ago
A couple of suggestions:
1) Use XLC's animation button to increment time and see the trajectory path.
2) Copy the column of calculations and past into a table with a number of column. Then modify the time parameter in each column and plot the trajectory in a scatter chart.
I hope this all makes sense.
woodward@wendtcorp 5 years ago
Win 7. Excel 14.0.7116.5000 (64-bit)
XLC_Ribbon
Trajectory.xls
Simple Projectile Motion.xls
The files above don't seem to plot the trajectories. Am I missing something in terms of how to initiate the calculation or line plot?
Forced Vibration of a single degree of freedom system.xls seems to work fine.
Regards, Mike [file name=Trajectory.pdf size=22370]/media/kunena/attachments/legacy/files/Trajectory.pdf[/file]
JohnDoyle[Admin] 5 years ago
There are two versions of XLC most people install the ribbon version which works with Excel 2007 and later. There is also [url=/component/option,com_remository/func,fileinfo/id,374/]XLC toolbar version[/url] that works with Excel 2003. It appears you have tried to install the ribbon version in Excel 2003 - which will not work.
JohnDoyle[Admin] 5 years ago
There are two versions of XLC most people install the ribbon version which works with Excel 2007 and later. There is also [url=/component/option,com_remository/func,fileinfo/id,374/]XLC toolbar version[/url] that works with Excel 2003. This is explained all XLC download pages.
MicucciEngineering 5 years ago
I activated my subscription, downloaded XLC, got the release code but I don't see any XLC toobar, ribbon, icon or "About XLC and Settings" button.
Please advise.
MicucciEngineering 5 years ago
I just subscribed, downloaded and installed XLC and do not see any indication of a new toolbar, ribbon or icon in Excel. I'm using Excel 2003.
Please advise.
JohnDoyle[Admin] 5 years ago
[url=/frequently-asked-questions/excelcalcs-faqs/how-to-configure-xlc-in-the-xlc-pro-mode./]Follow these instructions[/url].
alimaher 5 years ago
I have my XLC release code. Where do I find the prompt to activate it?
Thanks!
JohnDoyle[Admin] 5 years ago
I thought it might be best to correspond with you directly rather than clutter the site. Would you be will in to let me look at your machine using Chrome Remote Desktop or TeamViewer? This way I can see for myself what the problem is. The last time I used Chrome Remote Desktop I discovered it was possible to install Excel without any VBA support ? this was easily fixed by a full install of Excel. I have sent you an email so that we can arrange this off the comments box.
Islam85 5 years ago
I have tried your suggestion, but it does not work. It gives following error:

-error058960_01.xmlSe han detectado errores en el archivo "C:\Program Files (x86)\XLC\XLC.xlam"-Registros quitados: Rango con nombre de /xl/workbook.xml parte (Libro)
JohnDoyle[Admin] 5 years ago
I have just checked the XLC ribbon install with Excel 2013 and I was a little surprised when the toolbar did not appear. However when I used the Excel menu File>Options>Addins I saw that XLC was installed but was inactive. At the button of the Add-ins screen you will find Manage Excel Add-ins and a "Go" button. Hit the "Go" button then check the tickbox for XLC in the dialog that appears. That got everything working for me.

Failing that navigate to the installation directory (probably C:program Files>XLC) and open XLC.xlam this should give open things up for you and give you an option to start XLC when Excel starts. Let me know how this works out.
Islam85 5 years ago
I have downloaded the ribbon file. Installed and it appears in Excel at options\Add ins as installed, but it it does not appear a tab in excel to run it. Could you help on that please.
JohnDoyle[Admin] 5 years ago
I have just run a check on Excel 2007 running on Windows 7 and all is well. I'm afraid I do not have a windows XP machine to check it on.
I suggest that you download again and check the file size is a little over 1Mb. Re-install and keep an eye out for any error messages.
If this fails you could install [url=/component/option,com_remository/func,fileinfo/id,374/]XLC toolbar version[/url] which runs in Excel 2007 and see if you have more luck with that version. It has been around for longer and is may stand a better chance of working on older operating systems.
JohnDoyle[Admin] 5 years ago
I have no problems opening your work book on a machine using Windows 7 and Excel 2010. However I have another machine with Excel 2007 and I will check if the latest version is working on this. Bear with me a little while.
omeave 5 years ago
Dear John,
I´ve just installed the newer version of the XLC addin to a machine running Windows XP and Office 2007 in spanish. After installing i see the new tab but the buttons do not work, except for the Auto XLC switch. The program hangs and i have to close it. I am attaching a sample workbook. Please help. [file name=Libro1.xlsx size=9103]/media/kunena/attachments/legacy/files/Libro1.xlsx[/file]
JohnDoyle[Admin] 5 years ago
I have just added the MoreVision code signature to the installer. No change to XLC.
JohnDoyle[Admin] 5 years ago
To download you simply need to login to the site - the download link is available to all subscribers even those with a free XLC Trial subscription.
JohnDoyle[Admin] 5 years ago
XLC is updated to automatically detect XLC functions from any file and correct it to use the latest function library. This all occurs in the background and ensures that any file downloaded from the repository can be loaded with correction to the XLC functions. It also includes a bug fix for cell copy functionality reported [url=/forum/xlc-issues/copy-cells-in-excel/#3226]in this thread[/url].
Belay 5 years ago
how can I download it ? it is difficult to get free download tab.
JohnDoyle[Admin] 5 years ago
No Mike there is not currently a way to do this. An equation editor, like the one that ships with Word, would be the easiest way to achieve what you are looking for. The main purpose for XLC is to render an equation from the cell formula as a way of checking it against a formula you are copying from a text book and also that the calculation method is transparent and easily read. All Excel cell formulas start with an "=" and so do XLC rendered equations.
Thanks for your kind comments about the site.
autosocratic 5 years ago
Using the first video as an example, di=do-2t. Instead of "di =" being in one cell and "= do-2t" in another, is there a function that brings the whole equation together?
Thanks - really impressive software!
Mike Round
Yves1908 5 years ago
Thanks John for your help. The solution is effectively to check the tick box in the AddIns menu.
You provide a great support!
JohnDoyle[Admin] 5 years ago
Roger and I spent some time looking at this problem over the phone and I managed to take a look at his PC using TeamViewer. It seems that Excel can be installed without VBA (this is the first I have heard of this but is documented on the [url=http://support.microsoft.com/kb/282847]Microsoft site[/url]). Obviously without VBA XLC will not run nor will any Excel add-in including the ones supplied by microsoft (Solver.xlam). Roger is re-installing Excel and hopefully this will remedy the problem.
JohnDoyle[Admin] 5 years ago
Hi Roger sorry you are having some difficulty installing the software. Firstly did you install the the [url=/repository/xlc-addin-for-excel/xlc-ribbon/]ribbon version of XLC[/url] and not the toolbar version (this is only intended for Excel 2003).
If for some reason you did download and it did not install correctly may I suggest you find the installation directory (usually C:\program files\XLC) and search for a file called XLC.xlam. Just open this file in excel and you should be good to go.
Let me know how you get on.
RogerJJr 5 years ago
Running Win 7 and Excel 2013.,.followed all tips is Read Me file but still can't get XLC to load.
Very frustr4ated!!
JohnDoyle[Admin] 5 years ago
Yves I have just checked the XLC ribbon install with Excel 2013 and I was a little surprised when the toolbar did not appear. However when I used the Excel menu File>Options>Addins I saw that XLC was installed but was inactive. At the button of the Add-ins screen you will find Manage Excel Add-ins and a "Go" button. Hit the "Go" button then check the tickbox for XLC in the dialog that appears. That got everything working for me.
Failing that navigate to the installation directory (probably C:\program Files>XLC) and open XLC.xlam this should give open things up for you and give you an option to start XLC when Excel starts. Let me know how this works out.
Yves1908 5 years ago
I run a French version of Office 365 2013 under Win 7 64 bits on a Macbook Pro. I downloaded the XLC Ribbon and ran the .exe setup program. There was no errors. When I launch Excel, I cannot find any trace of the XLC Ribbon. If I tried to type the =OVD(1)/UND(2) formulae, I get a ?NAME instead of the 0,5 expected answer. What's wrong? Do I need anything else?
Jake.B 5 years ago
Great stuff thanks John.
I have subscribed and look forward to the update. Keep up the good work.
Regards Jake
JohnDoyle[Admin] 5 years ago
I spent a little time on this yesterday and I have a fix which I will include in the next release. If you go to the XLC download page and press the subscribe button you'll be automatically emailed when the update is available for download. Thanks for reporting this in Jake.
Jake.B 5 years ago
Hi John. Thanks for your prompt reply - thought I must have been going mad for a minute!
Work around seem easy enough to implement. Is there any hope for a fix in the future? Just find myself doing a lot of copying and pasting with XLC when I need to copy formula with correct units etc. from one place to another.
Kind regards,
Jake
JohnDoyle[Admin] 5 years ago
Hi Jake. I am afraid this is a bug in XLC. To get back your normal behavior you need to temporarily switch off XLC. This can be done from Excel Menus File>Options>Addins Then at the bottom of the page you'll find Manage Excel Add-ins and a "Go" button. Hit the "Go" button and un-select XLC. You can switch it back on when you need to. Sorry this is only a work around and not a fix.
Jake.B 5 years ago
Hello,
Not an XLC question per se, but this seems like a good place to ask.
I am using Excel 2010 after having quite a long break from doing any real intensive calculations in excel. I could have sworn in previous versions when I clicked on a cell and copied it with Ctrl+C, I could press Ctrl+V more than once to copy the source cell to as may destination cells as I wanted without the source cell deactivating.
Is this correct or has Excel always only ever allowed one Ctrl+V for each Ctrl+C command? Seems a bit painful. I know there is the clipboard but that not really as efficient as a quick keyboard operation.
Many thanks,
Jake
JohnDoyle[Admin] 5 years ago
I have been away for a couple of days Alex but I am pleased you managed to work this out for yourself.
ahuston 5 years ago
John,
Nevermind, I figured it out, the cell was formatted as a Text cell instead of a General cell. Making the update fixed this.
Thanks,
Alex
ahuston 5 years ago
John,
When I enter =eqs(e10) in cell G10, the following displays '=eqs(e10)'. When I do the same thing in cell G14, the equation graphic displays. When I click Insert Equation button in cell G10 the equation graphic will appear along with =EQS(e10,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 1; ShowWorking= 0; EqnStyle= 0; Eqp$G$10_2" ), not appearing in only the formula bar.
How can I get the info above to not appear in the cell and just the formula bar for all cells? [file name=Trial.xls size=29696]/media/kunena/attachments/legacy/files/Trial.xls[/file]
Thanks,
Alex
seattle321 5 years ago
In the above excel spread sheet the following's needs to be added: 1. The deferential in soil levels on both sides of the retaining wall must be controllable . At the moment only Y6 soil level can be reduced or increased, however, please add another key to control soil level on the other side of the wall. 2. No Load impact (Point load in KN)is found in this spreadsheet as a result of a vehicle hit (projected load)magnitude in KN , above grade level by 400 mm, the projected load is against the wall should be add.
Thanks
wahab
do_usr 6 years ago
Thank you for the replay. Actually I have figured out/ eliminated the problem. I had to do with a macro that was somehow trigged when I ran the XLC commands, don’t ask me how. Removing the macro made the spreadsheet run normal again.
JohnDoyle[Admin] 6 years ago
To investigate this I would need to reproduce the error on my own machine. can you send me your file and the sequence of events that I need to follow to reproduce the problem?
If the XLC functions are not working I suggest that you close excel and restart it. This should restore XLC back to some order.
do_usr 6 years ago
I am working on a large workbook and all of a sudden a started getting the error message:
Microsoft Visual Basic for Applications - Wrong number of arguments or invalid property assignment.
The message pops up whenever a try to use any of the XLC functions. Any suggestions on why I got this problem and how it might get solved? [img size=432]/media/kunena/attachments/legacy/images/xlc_error_450.jpg[/img]
JohnDoyle[Admin] 6 years ago
Dennis - Toolbar version and ribbon version implement XLC functions in different ways. We have a [url=/frequently-asked-questions/excelcalcs-faqs/repository-downloads-have-%23name-errors/]FAQ which answers all your questions[/url]. Good luck with your deadline.
denniskirk 6 years ago
I am working with a small team doing calculation development so have had XLC installed on several PCs and they chose the ribbon version. I use the toolbar version on my PC.
The Ribbon version puts a link to XLC.xlam in the file (see "edit links")along with a path to this file.
When I open the file on my PC the XLC.xlam file is not in my install directory and XLC adds a full path to XLC.xlam at the front of each EQS function which then generates errors at each function because it can't find this file.
I can fix the problem by stripping out the patch from each EQS function on each sheet in the (large) workbook and once done I can break the link to XLC.xlam. If I break this link before stripping the path details then the EQS functions fail altogether.
The calculations we are developing must be distributed to other users either with XLC installed (or without XLC and the XLC functions removed) so need to work regardless of whether the Ribbon or Toolbar version is used.
Are we doing something wrong or is there a way to fix this problem as we must deliver the software to the client within the next few days. :(
Rgds
Dennis
JohnDoyle[Admin] 6 years ago
There are no extra strains posed on excel due to equations and the file should save and load without any difficulties. As far as Excel is concerned equations are simply graphics and all the code used to save a file is purely Excel.
I have also taken a look at your excel file and I'm afraid it is very strange indeed. I don't think you fully understand what XLC is doing. Perhaps I could suggest that you follow the tutorials on the help page. This will show you how to use the software and how it can help you verify cell formulas in Excel.
and_rus 6 years ago
After working with the same file for an hour again, repaired some equation faults, there has been even nastier error coming up. Saved the file, closed it and when I opened it again then excel say´s that "Excel found unreadable content in this file. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."
After clicking Yes, I see that excel has lost all the sentences, words and everything else but the numbers and formulas inserted to cells.
It has happened few times more in the past, that´s why I have usually make some extra save as files not to lose everything once.
Can you tell me what can cause this error? Is excel itself causing this, or coping the equations may bring it up?
and_rus 6 years ago
they are named but there are also some extra symbols added. [file name=Labor.xlsx size=37498]/media/kunena/attachments/legacy/files/Labor.xlsx[/file]
JohnDoyle[Admin] 6 years ago
Yikes this looks terrible but there are some clues as to what is going wrong. XLC is telling us that a number of cells are not named.
May I refer you to the [url=/help-and-tutorials/]help page[/url] and in particular the requirements for a named Cell
If you wish please attach your file so that I can examine it in more detail.
and_rus 6 years ago
Hello
recently I´ve had a problem with equations. Something is adding some extra symbols to the equations I´ve made. At first when working with the file there are no problems with it, equations are correctly shown, but after closing excel and opening it again, the problem has begun.
I add a picture also about the file. [img size=748]/media/kunena/attachments/legacy/images/Untitled.jpg[/img]
JohnDoyle[Admin] 6 years ago
I have checked that the file downloads correctly and is not corrupt. The download file is an executable file, it sound like some security feature on your machine is preventing access. There is not much we can do at this end I'm afraid. [Admin]
Woida_Blu 6 years ago
Cannot download. System admin levels will not allow me to use the "Run" button and when I download it the file is always corrupt. Any other way of updating?
JohnDoyle[Admin] 6 years ago
I notice that your row height is quite large. Personally I always leave the row height to automatically fit and let equations spill over to the row below. I always leave the 'Equation vertical align' setting to 'top' which gives me an equation looking like this: [img size=449]/media/kunena/attachments/legacy/images/muddledeq3.png[/img]
BTW to select an image click on the 'Choose File' button then place the image in your post using the button to the right.
Jake.B 6 years ago
Thanks John. Changing that setting looks good. The exponent still renders high but everything else looks spot on. Its no big problem - Just thought I would bring it to your attention.
Image attached (sorry still trying to work out how to include images in posts).
Regards Jake [img size=551]/media/kunena/attachments/legacy/images/UntitledEqMidLine.jpg[/img]
JohnDoyle[Admin] 6 years ago
Jake
There is an equation setting for this too. You can change the default setting using 'XLC Setting' button. Change the 'Equation vertical alignment' from 'top' to 'mid'
Jake.B 6 years ago
Hi John,
Thank you very much for solving this one for me. I generally break up my equations into logical blocks to make it easier to see what is happening. It is a relatively easy fix to write it all as one line so will do this going forward. Sorry to cost you so much time tracing the cause of this one down.
Regarding the vertical alignment of the + operator in the equations below, they seem to be a little high (top line by the looks of it). I assume this is just how excel renders equations?
Thanks again John, greatly appreciated.
Regards Jake
JohnDoyle[Admin] 6 years ago
I have been searching for how the code could introduce these carriage return characters and not finding an answer. But I see that they have been introduced by you. Looking in the formula bar I can see you have carriage return characters: [img size=482]/media/kunena/attachments/legacy/images/muddledeq2.png[/img]
Simply remove these characters and all the rendering problems will disappear.
JohnDoyle[Admin] 6 years ago
I have had no problems in building the equation from scratch (see below): [img size=449]/media/kunena/attachments/legacy/images/notmuddledeq.png[/img]
However when debugging you worksheet I have noticed that there are some strange carriage return characters that somehow seem to have crept in. I am at a loss to understand how this has happened and I am still investigating the problem further.
JohnDoyle[Admin] 6 years ago
[img size=449]/media/kunena/attachments/legacy/images/muddledeq.png[/img]
Oh dear this has not worked out well at all. It has been a long time since we have had an equation rendering issue to investigate but this certainly seems a worthy case. Please give us a little time to investigate. Thank you very much for reporting this in. In the meantime as a work around may I suggest that you break your equation into parts.
Jake.B 6 years ago
Hello team,
I have spent the day converting a calculation I had completed in MATHCAD over to Excel + XLC.
Overall, I am very happy with the results. The equations are generally very presentable and the ability to show working is a big advantage over Mathcad IMHO.
I do however have one problem as shown in row 128 of the attached calculation. I have a moderately complicated formula which requires me to take the square root. XLC seems to be having some trouble parsing the equation and formulating an appropriately rendered image of the equation.
Would someone mind having a look and offering some advice?
Many thanks,
Jake [file name=Bored_Pier_RevB.xlsm size=206229]/media/kunena/attachments/legacy/files/Bored_Pier_RevB.xlsm[/file]
JohnDoyle[Admin] 6 years ago
If you follow the link in my previous post it explains a little about what is happening. [CTRL + Shift + J] invokes a script to correct references to XLC. This is required as the structure of the program has altered over the years. It is in convenient but I am working on a software solution that will make all corrections transparently to the user.
Charlie James 6 years ago
Don't know what ctrl+shift+j means or does BUT IT WORKEDB)
Many thanks Charlie
JohnDoyle[Admin] 6 years ago
[url=/frequently-asked-questions/excelcalcs-faqs/repository-downloads-have-%23name-errors/]To rectify just press the [CTRL+SHIFT+J] keys simultaneously.[/url] I hope this sorts you out.
Charlie James 6 years ago
What am I doing wrong?:S . I have loaded XLC ribbon
JohnDoyle[Admin] 6 years ago
I noticed that the automatic functionality was not working correctly in 13.09.02. This is corrected in version 13.09.03. Version 13.09.02 was only available for a few hours so hopefully this does not worry many users.
JohnDoyle[Admin] 6 years ago
Some people have been troubled with hidden equations. The latest version 13.09.02 corrects this problem. In addition the expiration date for trial users has been removed.
JohnDoyle[Admin] 6 years ago
Some people have been troubled with hidden equations. The latest version 13.09.02 corrects this problem. Please download.
JohnDoyle[Admin] 6 years ago
Hi Dirk
I have checked XLC running with excel 2013 which gave me no problems but I have yet to sign up for office 365. I am aware that the online versions of Excel or Excel running on Windows RT will not support any add-ins at all so if this is your problem I will not be able to help. If Excel is installed on a full Windows product it will support addins. Maybe you could describe your installation in a little more detail?
dirkels 6 years ago
Hi
Can anyone help me with installing Excel calcs into Office 365. I keep on getting an error
Unable to register the DLL/OCX problem
Regards
Dirk
JohnDoyle[Admin] 6 years ago
It is also worth reading our [url=/the-good-calculation-guide/]good calculation guide[/url] which gives you guidance on producing calculations which give good results in any system of units. It will also handle your unit conversion too. I use this approach all the time and it is my starting point for any calculation I undertake.
JohnDoyle[Admin] 6 years ago
There is a [url=/repository/links/changeunits/]great addin here which will do a great job of unit conversion.[/url]
joe.tonneson 6 years ago
Hi,
I'd like to assign units to certain cells. For example, I am looking at a masonry shearwall and it is 10 ft long.
I assign a variable 'L' and input 10 and then in the adjacent cell input 'ft'. In my calculation is it possible for the xlc add in to convert ft to inches automatically or do I need to manually do this?....currently I just do it manually.
Thanks in advance.
SET 6 years ago
John,
Thanks for the quick response. That seems to have it sorted.
Apparently a case of "operator error" on my part in the release code input.
The confusing thing was, when I pressed the "Check release code" button (with the incorrect code still entered), I received a "Success" notification so I did not think to re-enter the Code. As soon as I entered the proper code, all my issues vanished, well, not all my issues.:)
Thanks for the quick response.
SET
JohnDoyle[Admin] 6 years ago
From the sounds of things your XLC release code has not been installed correctly as the program as you have it as the moment is still operating in trial mode. The usual problem is that your username is case sensitive so please follow [url=/index.php?option=com_acctexp&task=subscriptiondetails&sub=mi_excelcalcs_code]these instructions specifically[/url]. When you are sure this has been done correctly use the "Check Release Code" button on the "About XLC and Settings" form. This will tell you if it is working correctly.
Well we plan to be around for a long time but even if your subscription expires you can continue to use XLC in the trial mode (random "non-commercial use" message and hyperlinks to the site). All you calculations will continue to work nothing comes to an abrupt end. Worst comes to the worst and you want to ditch XLC altogether simply use the "Remove XLC" button [img]/images/stories/XLC/icons/UnXLC.png[/img] and everything works as native Excel file with no XLC dependancies (but your equations will not be able to redraw themselves if formulas change they will now be simple static graphics).
Thanks for your support and remember [url=/the-good-calculation-guide/#Publish]we reward any contributions to the repository with free subscriptions and to the best authors we award free lifetime membership[/url].
SET 6 years ago
Hello,
I recently purchased the Pro version and I must say that I love your work, and XLC is making life much easier. But I have one nagging issue that I am hoping can be resolved.
The add-in is installed on a Windows 7 machine running Office 2013 32bit version. The Username and Release Code seem to be correct. I have installed the ribbon version and all works well except.....
When I insert an equation it sometimes comes up with the watermark (even though I have a paid version), sometimes not. When I change the equation from "Algebra" to "Number" the watermark will appear and disappear.
Also, when I click on any equation (left mouse button, not right mouse button), it takes me to the ExcelCalcs website. Not a bad place to be, just an annoyance to be there on half a dozen Firefox tabs. Not sure if this is the intended function, so I would like some clarification on that.
In addition, since much of what I am planning to do with XLC will be used for years, and I need to plan on a worst case scenario, I am also curious what happens to all my XLC spreadsheets if your website goes away in the future and I am not able to renew my subscription?
Any help would be appreciated. Thanks in advance.
SET
JohnDoyle[Admin] 6 years ago
I trust you installed the [url=/repository/xlc-addin-for-excel/xlc-ribbon/]ribbon version of XLC[/url] rather than the [url=/repository/xlc-addin-for-excel/xlc-toolbar/]toolbar version[/url]?
The ribbon version installation is generally un-problematic. Installing the toolbar version can occasionally be a little more difficult to install.
dadva 6 years ago
I have a problem. After instaled, i dont see the buttons in excel. I tried to register the .dll in administrator CMD mode but it doesn't work. I use excel 2010 in spanish on w7 64bit.
David
nephembani 6 years ago
thanks
JohnDoyle[Admin] 6 years ago
I'll take a look into this and try to work out what is going on. In the mean time it is possible to disable XLC from the File>options>Addins menu if it becomes an irritation.
matt.moore 6 years ago
Hi all,
I recently installed xlc onto my pc and since then have noticed that the add-on has changed the behavior of the clipboard within excel. When I copy a cell and paste it in another location, it is removed from the clipboard once it has been pasted the first time. Prior to installing xlc, excel worked as expected, such that I could copy a cell and paste it into several locations without having to re-copy each time.
This same issue occurs when executing vba subs that I have written, where I used to copy a cell or range once and paste it in multiple locations, I now have to rewrite the line of code to copy the value each time I wish to paste it elsewhere.
This issue has been reproduced by my colleagues also. We are all running Office 2010 32bit on Windows 7 64bit. Any help would be much appreciated.
JohnDoyle[Admin] 6 years ago
Edward
I am intrigued to hear your problem but I doubt very much if XLC is causing the problem. An XLC file is saved as any other Excel file. Equations are simply 'shapes' like any other Excel shape. XLC does have some custom functions and will require XLC to be installed to work but if it were not all you would see is some #NAME errors. I will quite happily answer any questions from your IT people if they wish but there are no patches to address such a problem. I hope my response is helpful.
Woida_Blu 6 years ago
I recently noticed that I was unable to open embedded excel tables in my word documents. I had our internal IT look into the issue but realized that it may have been caused by some software I installed (XLC) and sure enough that once I uninstalled XLC I was able to open embedded excel tables in previous word documents.
So my question: Is there a patch or software update that corrects this issue? I searched through the forums and was not able to find anything which addressed this. Please advise.
Can send you some examples if necessary.
Regards,
Edward
JohnDoyle[Admin] 6 years ago
This s very strange but without being able to reproduce the error it is difficult for me to investigate.
r.verhoosel 6 years ago
does not work for me!
no formula shows
JohnDoyle[Admin] 6 years ago
I hit the redraw button to produce the equation: [img size=222]/media/kunena/attachments/legacy/images/3052_1.png[/img]
r.verhoosel 6 years ago
Hi john,
Thank you for your quick response.
Please see the spreadsheet I included, and see the problem.
I tried to shut down all the processes running (as far as possible), but still not working.,
Thank you. [file name=test2.xlsx size=112336]/media/kunena/attachments/legacy/files/test2.xlsx[/file]
JohnDoyle[Admin] 6 years ago
Rob
Simply enter cell C3 in your example and click the [img]/images/stories/XLC/icons/InsertEqn.png[/img] Insert Equation button.
r.verhoosel 6 years ago
Hi John,
I realise that is has been a long time that this topic was hot.
I'm new with using xlc aandit is impossible for me to get formulas with xlc in the spreadsheet. I work with windows 7 and office 2010. Skype is not installed. The computer is free from virus, malware etc.
can you help me?
regards,
Rob [file name=xlc_test.xlsx size=14540]/media/kunena/attachments/legacy/files/xlc_test.xlsx[/file]
JohnDoyle[Admin] 6 years ago
Yes it is easy to do. Just use the XLC "name" and "insert equation" buttons. You can try out all this functionality with a free trial subscription too.
kjn.fife 6 years ago
I'm new to ExcelCalcs: Can XLC be used to decipher an existing spreadsheet and display the formula.
JohnDoyle[Admin] 6 years ago
As far as Excel is concerned an XLC named cell is just a cell containing some formatted text. This data is not lost when it is saved.
As far as Excel is concerned XLC equations are simply graphics and again this data is not lost when it is saved.
Unless I can reproduce the error you experienced I cannot debug it but I really cannot see how XLC has given rise to your file corruption issue.
erik01 6 years ago
I am using name functions, but excel deletes all names and other texts from the workbook. They are also missing from the file You sent back. If I open your work I still get this message: [img size=492]/media/kunena/attachments/legacy/images/Capture2.PNG[/img]
JohnDoyle[Admin] 6 years ago
Eric
I managed to open the file with a few errors. I can see that you have been using XLC so I redrew equations on a couple of worksheets. I was a little surprised to see that you have not been using XLC name functions to generate algebraic equations. Your numeric equations appeared well enough though.
I saved my work which re-opened without errors (see attached).
I do not believe that the file corruption problem has anything to do with XLC but some other Excel weirdness. Sorry I cannot be of much help. [file name=XLC_error2.xlsx size=1574793]/media/kunena/attachments/legacy/files/XLC_error2.xlsx[/file]
erik01 6 years ago
The file is here: [file name=XLC_error.xlsx size=1632260]/media/kunena/attachments/legacy/files/XLC_error.xlsx[/file]
JohnDoyle[Admin] 6 years ago
Could you attach a file exhibiting the problem and I'll take a look at it?
erik01 6 years ago
Hello!
I have a similar issue:"Excel found unreadable content in '[i]filename[/i]'. Do you want to recover the contents of this workbook?"
Cliking YES results in losing all of the text strings (names, xlc formulas,even headings). Only calculations and drawings are left.
Im working with excel 2007 sp3 & xlc trial.
Thank You! [img size=480]/media/kunena/attachments/legacy/images/Capture.PNG[/img]
Woida_Blu 6 years ago
Very odd...and very sad that it was not easier to spot the issue. I appriciate the help in resolving my troubles (which was actually putting in my USER NAME in the XLC settings).
:woohoo:
JohnDoyle[Admin] 6 years ago
It all sounds very odd Edward I'll contact you by email to arrange a call. I may ask you to use a very good website service www.screenleap.com so that you can show me exactly what is happening.
Woida_Blu 6 years ago
Yup, as stated..."I followed some of the trouble shooting steps such as going into the settings and checking, emailing, and updating my release code (which says it is active) to no avail." in my first post. I again followed your links and suggestions to again....no avail.
The only difference being that some of the features described such as "Redraw all worksheet equations" I do not have. Rather I only have options "Redraw with Eqn No" and "Redraw without Eqn No". Additionally, I also tryied to update my settings to change the equation number denotation from Eqn to EQ. and it accepted the changes in the settings window but when I incorperate Eqn No's into the equations it abreviates them "Eqn" despite the changes I made.
Not sure that that helps with trying to figure out whats going on...but still an issue....
:(
JohnDoyle[Admin] 6 years ago
Edward
Thank you for your comments and apologies about the watermark issue. This should be easily rectified. It is simply a matter of inserting your XLC release code correctly. Loginto the site and follow this [url=/index.php?option=com_acctexp&task=subscriptiondetails&sub=mi_excelcalcs_code]link to retrieve your release code[/url]. There is some [url=/frequently-asked-questions/excelcalcs-faqs/how-to-configure-xlc-in-the-xlc-pro-mode./]additional help here[/url].
If you are still having trouble drop me a line - I'm sure we get get this resolved quickly for you.
Woida_Blu 6 years ago
Hello,
I'm new to XLC and so far I have been very interested and excited (who says that about MSExcel or formulas) to use it!
I originally opted for a trial version to see what the fuss was and liked it straight away. So I shelled out the cash for the full version (12M).
The only issue that I am having at the mement is with the hyperlinks and watermarks which I have read through some of the FAQ and forum posts are only to be associated with the non-paid versions. I followed some of the trouble shooting steps such as going into the settings and checking, emailing, and updating my release code (which says it is active) to no avail. The weird thing is that the hyperlink/watermarks change from the list of equations each time I REDRAW (with or w/o eqn). I am not sure why this is or what I am doing or not doing to correct this.
Please help!
R/
Edward [file name=XLC_forum_image.pdf size=93356]/media/kunena/attachments/legacy/files/XLC_forum_image.pdf[/file]
JohnDoyle[Admin] 6 years ago
Expiration date for XLC Trial users extended to 30th September 2013.
JohnDoyle[Admin] 6 years ago
Martti
I have just uploaded new versions of the installation files which extends the expiration date for trial users until 30th September 2013. Please install these new files.
martti 6 years ago
Hi,
My friend installed and used XLC on my computer. I started to like it and when my friends subscription ended I registered myself. But after unistalling and installing the version I downloaded, it still says my subscription has ended. Is there a way to fix this?
JohnDoyle[Admin] 6 years ago
Thanks for your comments and I am sorry that the process of getting up and running is frustrating. All I can do to reassure you is that we are here to help and very happy to do so.
In response to your specific difficulties:
The toolbar version is a little more problematic to install that the ribbon version of the program. Generally the problem has to do with Windows installation rights but if you don't have installation rights you are pretty much stuck.
The trial version of the program times out (this does nor happen to active subscribers). It is done so that trial users use the most up to date version and also to bring them back to the site periodically to encourage them to upgrade (although a trial subscription can be used indefinitely).
Running videos from the Excelcalcs can be problem if your software is not the required version. However all the videos are available on our You tube channel. The YouTube player supports almost all browsers.
Please stick with us we'll get you up and running.
studoc 6 years ago
Perhaps like many engineers, I find myself with many half baked spreadsheets after many years in practice, so see XLC as potentially a useful tool to clean things up from the past and present a more organised way forward.
It's been difficult to move forward though; I don't know about others, but things haven't worked straight off the bat.
I am busy, so go back to my work and sporadically return for another look.
This time I download the XLC toolbar onto my laptop for another attempt, only to find that following a fresh download and successful install, the program says it is outdated (???).
Looking in for a peak at the tutorials I find that the flash player stalls, because it doesn't have the latest version of adobe whatever... The laptop is a month old and i seem to remember being asked to update this program shortly after it's purchase...
I am busy, tired and frustrated by my failure to launch XLC...
Looks like a good idea, but....
JohnDoyle[Admin] 7 years ago
Are you installing the toolbar version of XLC or the ribbon version?
AndrewLivingstone 7 years ago
I re installed windows 7 to day and then I installed XLC, but I got the error 13 message
uninstalling XLC and re installing it didn't help.
any suggestions ?
AndrewLivingstone 7 years ago
thanks :)
JohnDoyle[Admin] 7 years ago
Hi Andrew - If you reinstall your copy of XLC you will not have this problem. The latest versions always start up with XLC Auto switched off and the button needs to be switched on when you want to use this functionality.
It caught me a out a couple of times too and it is quite annoying if you are working with an enormous data sheet :)
AndrewLivingstone 7 years ago
I am using XLC on a daily basis but when I run a VBA within Excel the program runs so slow, I need to turn off the ‘Auto XLC’, my question is can I do this within my VBA program.
Thanks
JohnDoyle[Admin] 7 years ago
Updated the code to get round the XLC Toolbar function and XLC Ribbon function compatibility issue. The problem was that any calculation created using the toolbar version of XLC which was subsequently loaded up by the ribbon version of XLC threw up some #NAME? errors. Should this happen all you have to do is press the [CTRL+SHIFT+J] keys and the error will disappear.
The previous code reformatted some of the XLC Named cells - the latest version does not reformat any XLC Named cells.
medeardorff 7 years ago
I uploaded the latest XLC based on another post. Sorry to trouble you all. I searched after I made my first post.
Thanks
medeardorff 7 years ago
How do I avoid seeing the _ or ^ characters which showed up when I tried your examples?
medeardorff 7 years ago
I often use names with multiple characters with or without subscripts. How do I prevent a cell from being automatically subscripting or allowing a subscript after two or more normal characters? To elucidate I use variables like XTl+1 where l+1 is the subscript.
Thanks
Mark
JohnDoyle[Admin] 7 years ago
So sorry to have to put out this update so soon but I realised that the last version released 2 days ago 12.12.04 was not compatible with the 64bit version of Excel (thank you Clyde Hancock for reporting this in). A stupid mistake oversight on my part I'm afraid. I have fixed the problem in this release.
In addition I have also introduced some new code to get round the XLC Toolbar function and XLC Ribbon function compatibility issue. The problem was that any calculation created using the toolbar version of XLC which was subsequently loaded up by the ribbon version of XLC threw up some #NAME? errors. Should this happen all you have to do is press the [CTRL+SHIFT+J] keys and the error will disappear.
I recommend that you install this update.
JohnDoyle[Admin] 7 years ago
Reconfigured the XLC Functions to maintain better compatibility with XLC toolbar and calculations created by toolbar versions of XLC after problems with #NAME? errors ([url=/site-news/excelcalcs-news/training-courses-for-london-underground/]as reported in the newsletter[/url]).
Also modified graphics routines for better functionality with the Excel Web App and Microsoft SkyDrive.
I recommend that you install this update.
JohnDoyle[Admin] 7 years ago
I have updated the [url=/help-and-tutorials/]help page[/url] so that you read about each button without having to hover over the button. This will be useful for those who like to print out a page of help. Thanks again for the feedback :)
JohnDoyle[Admin] 7 years ago
The written help is encoded into the buttons in the ribbon version of the program. Simply hover your mouse over the button to reveal the help. The same help is on the [url=/help-and-tutorials/]help page on the website[/url] again simply hover over the button graphic above the video player to reveal the help.
jrhien 7 years ago
John:
I'm more of a "book in hand" kind of guy. While your video posts are informative, I really appreciate having something informational in front of me. Do you have a written manual for XLC?
Thank you,
John
JohnDoyle[Admin] 7 years ago
Hi Ryan I have emailed to files to you to make sure you can get going but I am keen to try to find out exactly what the down load problems is. I assume that you have been trying to download the ribbon version of XLC? It seems that you have sucessfully downloaded other files from the site. If this is the case then perhaps the problem is related to you browser security settings. Most files on the site are Xls or xlsx files but the ribbon version of XLC is downloaded as XLC_Ribbon_Setup.exe. Browsers often raise warnings if you download executable files. Is this the problem?
ryan akers 7 years ago
Hi John,
Thanks for getting back to me mate- the problem still persists however- i have tried a different computer but its on a work network so maybe the problem is the internet connection- the excavator sheet downloads fine though- is there any way you could just download the file and send it via email.
Very keen to get this worksheet up and running mate- it looks great from the previews.
JohnDoyle[Admin] 7 years ago
I seem to get this reported every few months or so but each time it is some kind of internet connection problem. May I suggest that you try to download the files again. I have checked both the Ribbon and toolbar versions of the program. Each downloaded correctly and I did not receive any file corruption messages.
If the problem persists please contact us again and look into it again. Could you copy the URL of the file you are trying to download? I'm sure we'll have you up and running soon.
ryan akers 7 years ago
Hi Guys,
Newb Here, doing an analysis of load applications for some of our large excavators on site and i am going to use the excavator arm sheet as a base point to get some ideas for how to do my analysis- this sheet requires XLC and when i try and download it the computer says "the setup files are corrupted.please obtain a new copy of the program" i have tried downloading it a few times with the same message coming up each time.
Any help would be great.
JohnDoyle[Admin] 7 years ago
Improvement to EQS() functionality so that it works correctly with 'Auto XLC' switched on. It is recommended that you reinstall this update.
briand 7 years ago
Thank you for the update.
JohnDoyle[Admin] 7 years ago
Just had a quick look at the code and XLC requires all functions to be named using alpha numeric characters apart from a few noted exception (like Excel's LOG10() function). I think I could improve on this in the future to allow other characters like "_" and numbers too. Consider it on the to do list. In the mean time you'll have to go 'cold turkey' with your "_"s. ;)
JohnDoyle[Admin] 7 years ago
Mmm I can't remember why - I'll take a look into it Brian and get back to you later.
briand 7 years ago
I think I said before I was addicted to underscores...! I now need to see if I can change the habit of lifetime, unless there's a chance of XLC being taught to treat my underscores as I intend them to be treated?
Thanks,
Brian
JohnDoyle[Admin] 7 years ago
XLC seems to be recognising bd_Dewpoint as a cell reference (I don't entirely know why). However if you remove the "_" character in the bd_Dewpoint() function XLC will operate as expected. See below: [img size=545]/media/kunena/attachments/legacy/images/bddewpoint.png[/img]
briand 7 years ago
...oops...it wouldn't let me attach an add-in (bd_tech.xla), so I've renamed it 'bd_tech.xls' and trying again... [file name=bd_tech.xls size=32768]/media/kunena/attachments/legacy/files/bd_tech.xls[/file]
briand 7 years ago
...and please find add-in attached as in previous post...
briand 7 years ago
Please find attached the workbook; I'll post again in a few seconds attaching a cut-down version of my add-in (as I think I can only attach one file per message on this forum?).
Thanks. [file name=xlc_udf_issues.xlsx size=20496]/media/kunena/attachments/legacy/files/xlc_udf_issues.xlsx[/file]
JohnDoyle[Admin] 7 years ago
XLC usually copes pretty well with UDFs. I can imagine that under some circumstances it may have a few hiccups although in this particular case I can't see why it has not worked. Perhaps you could attach an example showing how the problem occurs and I'll have a look into it.
briand 7 years ago
I have some User Defined Functions in an Add-In (my own Add-In, containing various psychrometric functions) for my spreadsheet. It would seem that XLC equation display can't deal with these functions. For instance, my UDF 'bd_Dewpoint' calculates the Dewpoint temperature from Dry Bulb Temperature and Relative Humidity. In cell D15 I have the formula '=bd_Dewpoint(D13,D14)' (using XLC I named D13 ta and D14 rh). XLC enters in cell E15 '=EQS(D15,"Units= ; EqnPrefix=Eqn. ; EqnNo= 1; Multiplication= 1; ShowWorking= 0; EqnStyle= 1; Eqp$E$15_2")'. XLC equation is displayed as '=#Cellbd_Dewpoint not named#(ta,rh)'. Is it just a problem with my UDFs, or does XLC have a problem with UDFs generally?
yanez 7 years ago
Now i can see the toolbar!
I will show what i did for the toolbar appears. The problem was in the user profile.
(i'm using excel 2007)
1º I created a new account (windows 7 account).
2º I downloaded and installed xlc toolbar
Everything it's fine :)
I hope this help :)
Ragley 7 years ago
Hi All
I have a couple of questions regarding the AXIAL AND LATERAL LOAD PILES (FEM) software that I hope someone can help with. I haven't used this software yet, and because of my trial status, I can't download it to test if it's suitable for my purposes.
1) Is it possible to input multiple soil layer parameters?
2) With auger bored concrete piles, the rebar is in effect a large RSJ (H Beam) which sits at the bottom centre of the concrete and protrudes a set distance above the top of the concrete. A lateral load is applied at the top of the RSJ. Can RSJ sizes be input?
Thanks in anticipation
briand 7 years ago
That's much appreciated John, thanks.
JohnDoyle[Admin] 7 years ago
Correction to name button problem reported [url=/forum/xlc-issues/naming-variables-problem-with-subscripting/6/0/#2905]here[/url].
JohnDoyle[Admin] 7 years ago
I have just uploaded XLC Ribbon 12.12.02 - This error is corrected.
Thank you for your feedback Briand and taking the time to report this through to me - I have awarded you a free 3 month XLC Pro subscription by way of thanks.
briand 7 years ago
I am using XLC Ribbon Version 12.12, whcih I downloaded and installed this morning. I run Excel 2010 32-bit (x86) under Windows 7 Enterprise SP1 64 Bit.
Under Equation Display Default Settings, I have ticked the box Show all multiplication signs.
If I have Auto XLC OFF, then once I've entered the name and click the manual '= XLC Name' button, I have the problem I've described.
However, as you suggested, I've just tried with Auto XLC ON entering a name 'OAT=' (without the space) and it does what I want, so thanks for that!
JohnDoyle[Admin] 7 years ago
Apologies Brian:blush: - I have continued test and I can see there is a problem when the auto XLC switch is off in the new ribbon version of XLC. I have managed to get the problem you describe to repeat on my machine. I'll take a further look into this and upload a fix over the next day or so.
In the mean time I suggest you turn on the Auto XLC switch which is working fine I believe.
JohnDoyle[Admin] 7 years ago
Hi Brian
This problem seems a little odd to me Brian I have just checked and everything seems to be working out for me. Let's get a few things straight first.
[li]Are you using the latest version of XLC?
Are you working with the Auto XLC On or Off?[/li]
Entering 'OAT=' should not subscript any character.
Entering 'OAT =' should subscript the 'A' and the 'T' characters.
Underscores in names will enforce subscripts and the only work around I can think of is to use the "-" character in place of your current "_" character.
Let me know how you get on :)
briand 7 years ago
I realise this topic is a bit old, but I've just been trying to do the same thing and I also can't find a way to prevent characters in the middle of my name appearing as subscripts, even though I've ticked the box Show all multiplication signs in the settings. Whether or not I have a space between 'OAT' and '=', still end up with at least one subscript. For 'OAT=' (i.e. no space), the 'A' is a subscript; for 'OAT =' (i.e. one space) (or with just 'OAT' and nothing else) the 'AT' is a subscript. Is there a fix for this? If not, I won't be able to subscribe as I really need to have my names the way I want them.
To complicate matters further, I often put underscores in my names, but these seem to result in subscripts; can this effect be changed? If not, I guess I may have to use a dashes instead of underscores, but that will be hard to remember as I've used underscores for breaking up variable names for as long as I've been using computers!
Thanks for any help you can give.
Brian
peachsb 7 years ago
Fantastic. Downloaded, installed and appears to work great. I have missed this add-in. Thanks!
JohnDoyle[Admin] 7 years ago
[url=/repository/xlc-addin-for-excel/xlc-ribbon/]XLC Ribbon Version
[img]/images/XLC/XLC_Ribbon_2010.gif[/img][/url]
It's here and it support 32 bit and 64 bit versions of Excel 2010.
JohnDoyle[Admin] 7 years ago
Introducing the first release of [url=/repository/xlc-addin-for-excel/xlc-ribbon/]XLC Ribbon version[/url] for Excel 2007 and 2010 (both 32 bit and 64 bit versions of Excel).
JohnDoyle[Admin] 7 years ago
Good news sadunham I am just completing work for the release of the ribbon version of XLC which will support the 64 bit version of Excel 2010 (and the 64 bit version of Excel 2013 which I am currently paying around with).
I have already sent a Beta version to Clyde who reports that it is running without a hit on his copy of 64 bit Excel 2010. It will be posted up to the site sometime this weekend. I'll add a note in this thread when it will be available.
sadunham 7 years ago
I think this is the problem that I'm having as well. When I try to register XLC.dll, I get a message that "failed with error 0x80004055". Could that be because I'm running Office 2010 in 64 bit mode? How would I go about checking that?
Clyde 7 years ago
Hi John,
I would be happy to do some Beta testing. Anything I can do to help. You know I'm "hooked" on ExcelCalcs. I'm surprised that Microsoft hasn't tried to buy you out.
JohnDoyle[Admin] 7 years ago
Hi Clyde
I am working have a ribbon version of XLC that will run on 64 bit versions of Excel 2010. The ribbon version of XLC has been working on the 32 bit version of Excel 2010 for some time and is about ready for release but I have to confess that I do not actually have a 64 bit version Excel 2010 and I really need to get on and start testing the code with this. Would you be happy to run some Beta code and report any problems back to me?
Clyde 7 years ago
I have just installed Microsoft Office 2010 (64 bit). I was not offered the option of installing the 32 bit version of Excel. I am saddened to discover that I cannot use ExcelCalcs. Are there plans for providing this in the future (I hope)? This will probably be an issue more and more in the future. I will really miss ExcelCalcs. Is there a way that I can install the 32 bit version of Excel? When I installed the 64 bit version of Office, the installation stated that I could not install the 64 bit version until I removed the 32 bit Office components that I had on my machine.:(
wescurran 7 years ago
Thanks John for your two great answers. I was using WinZip to unzip the file and kept getting error messages. You suggested that I try another zip extraction tool to see if that would work. So I downloaded Express Zip and it worked like a charm. I was able to successfully unzip and install XLC. Again thanks for your response.
Hydrokiwi 7 years ago
Hi John:
I am having trouble unzipping file xlc 12_09_01
Have tried downloading several times.
Have tried unzipping to an uncompressed folder.
Setup.exe is corrupted. My zip manager reports a format error when unzipping to the folder.
The download size is 1060 kB
Cheers
John
JohnDoyle[Admin] 7 years ago
Another thought... You are not working with the 64bit version of Excel 2010 are you. Our software does not currently support this version of Excel. It does work with the 32bit version of Excel 2010.
JohnDoyle[Admin] 7 years ago
Mmmm we have never had this one before. It seems to be some kind of problem with the integrity of the zip file. I downloaded from the site and checked myself and reinstalled myself. Everything worked for me so I don't think there is a problem with the integrity of the zip file on the site.
It is sometimes worth extracting the files in the zip folder to a uncompressed directory and running setup.exe from there. Please let me know if this solves your problem.
wescurran 7 years ago
When trying to install XLC I got the following message:
Warning: Skipping "setup.exe", the 32-bit CRC stored in the local header for this file is not the same as the 32-bit CRC stored in the central header.
I deleted that zip file and downloaded XLC again only to get the same message. Your help in resolving this issue is appreciated.
JohnDoyle[Admin] 7 years ago
I have been aware of this limitation myself for quite a while but there is an easy work around.
The problem occurs when the worksheet name includes blank characters (i.e. worksheet named "Sheet1" will not give rise to this problem but a worksheet named "Sheet 1" will give the #Cell'Sheet1'!H8 not named# notice).
To fix the problem simply remove any blank characters in worksheet names. I'll add the issue to my todo list - I'm sure I can get round the problem with a little programming effort.
Please let me know if this fixed the problem for you and thank for reporting the problem in - it all helps the product improvement effort :)
gte447f 7 years ago
When I try to use the eqs() function for a formula that references cells on another worksheet I get, #Cell'OtherWorksheet'!B1 not named# but it is named.
Am I doing something wrong?
JohnDoyle[Admin] 7 years ago
I have noticed that Skype have released a version of [url=http://www.skype.com/intl/en/get-skype/on-your-computer/click-to-call/windows/]Skype Click to Call[/url] which does not interfere with Excel or XLC.
priya.malahotra 7 years ago
good
DRT 7 years ago
Solution - use 32 bit excel / office.
I had 64 bit office and have now installed 32 bit - XLC (and other addins) now work.
ArthurJM 7 years ago
I have uninstalled Skype John and the formulae are showing. I will experiment further when I am freer. thanks for your help so far.
Arthur
ArthurJM 7 years ago
I have done all you recommended. However I only had the option of disabling Skype to Call. The remove button was greyed out.
The problem still persists, with only some of the formulae showing
Regards
Arthur
JimR 7 years ago
How about cube or higher roots?
would like it to look as nice as possible.
JimR
JohnDoyle[Admin] 7 years ago
I am afraid that XLC will not work with the 64 bit version of Excel 2010. I try to make this clear on the [url=/component/option,com_remository/func,fileinfo/id,374/]XLC download page[/url] but it is easy to miss. Unfortunately you'll find that many popular addins won't work on the 64 bit version of Excel 2010 and even Microsoft recommend the 32 bit version unless you need extra memory to access very large datasets (which appears to be the only benefit of the 64 bit version of Excel 2010 and is not generally a problem for engineers).
DRT 7 years ago
Hi John
I have the same issues
I AM running 64 bit excel 2010.
I am an admin super user but have also tried running as administrator on right click.
I have disabled my AV.
Yet I still get the same error message as above....
JohnDoyle[Admin] 7 years ago
I'm afraid I am out of advice - I am sure the issue is related to problems with administrator access - you could try on an alternate machine?
alarhammer 7 years ago
I did as You suggested and unfortunantely no change - the same error message!?
JohnDoyle[Admin] 7 years ago
To uninstall the Skype addin:
Firefox: Tool>Add-ons then uninstall Skype addin.
Internet Explorer: Click the gear symbol in the top right of the window> Manage Add-ons then uninstall Skype addin.
From your description something appears to have upset XLC. If XLC continues having problems I suggest you do the following:
[ol]Close Excel.
Uninstall XLC.
Download and install the latest version of XLC.
Restart the computer.[/ol]
I hope this settles things down but by all means contact me again if you continue to have problems.
ArthurJM 7 years ago
Hi John,
I have read through the above concerning equations not showing.
I have been using XCL on my new machine (64bit Windows 7) for months.
Today when I entered my new subscription code I started having problems with equations not showing.
I have tried to disable the addin in skype but don't see how to do it. I unchecked the "call to internet links" and some other like things.
I am now getting an erratic display of some of the formulae.
Any ideas?
Arthur Murphy [file name=Retaining_Wall.xls size=51200]/media/kunena/attachments/legacy/files/Retaining_Wall.xls[/file]
JohnDoyle[Admin] 7 years ago
There is no problems installing the software on any 64 bit version of windows provided that you have a 32 bit version of Excel. There is currently only one 64 bit version of Excel 2010 but it is only used by users manageing very large datasets and even Microsoft recommend that you install the 32 bit version of Excel 2010.
From what I have read 'Unable to register the DLL/OCX: Redsvr32 failed with the exit code 0x5.' arises because you need administrator rights to run the program. May I suggest you follow these instructions:
[ol]Download XLC.
Extract the zip into a folder on your hard drive.
Right click on the file "setup.exe" and select "Run as Administrator"[/ol]
Hopefully this will work but please get back if it does not.
alarhammer 7 years ago
The error messages are the same as in previous posts mentioned: 'Unable to register the DLL/OCX: Redsvr32 failed with the exit code 0x5.'
My operation system is 64bit - is it possible that has something to do with it?
JohnDoyle[Admin] 7 years ago
Did your computer give any error messages? In the previous case the error code 0x80004005 pointed us towards administrator rights and User Account Control Settings.
alarhammer 7 years ago
Hello
I have the same problem with installation and this solution did not solve mu problem. Are there any other suggestions?
Thanks
JohnDoyle[Admin] 7 years ago
We had developed a ribbon version of XLC running under the 32 bit Excel 2010. We assumed that getting this running on 64 bit Excel 2010 would be straight forward. Unfortunately it was much more involved that we first imagined. Coupled with this we have only had 2 request from users who want to run on 64 bit Excel 2010 (yourself and Keith Sharp). Most users are following Microsofts advice and installing the 32 bit version of Excel.
[url=http://www.microsoftstore.com/store/msstore/en_US/pd/Excel-2010/productID.216445700]Microsoft recommendation[/url]:
The only use advantage of the 64 bit version of Excel is to access more than 2GB of memory whih may be of interests to data analysts but not really a constraint for engineering calculations.
Finally we decided to continue offering one version of XLC our software which works on all versions 32 bit Excel (2000, 2003, 2007 and 2010). We are now not intending to realease a version for 64 bit Excel. I apologise for raising any false expectations.
peachsb 7 years ago
This post is a little old now but indicates you were in the final stages then to support 64 bit 2010. How is it coming? Are we there yet?
JFKatMatrix 7 years ago
Hello again,
Still no luck with that one.
Do you have any information on how we might access the ExcelCalcs functions, say within a macro, so that we can construct our own toolbar buttons?
JohnDoyle[Admin] 7 years ago
Sorry for not responding Boss Ed I have only just noticed your post. You are goining about tackling the problem the right way but what exactly does the error code say?
Boss Ed 7 years ago
John,
As suggested I have uninstalled XLC and reinstalled... I note there are two setup applications and I have used the 2012 application for setup.
From the read me notepad I have been through the cmd command prompt and tried to register however whilst the dir confirms the xll and dll files, I am getting the attached error code on registration...
Help ?
valoroca 7 years ago
Thanks ... excellent
JohnDoyle[Admin] 7 years ago
Maybe you have all tried this already but I lost my XLC toolbar for a little while in Excel 2010. I managed to find it again by checking Excel options. The strange thing was that the Add-Ins tab was checked (but not actually showing) so I unchecked it and then rechecked it and thankfully the XLC toolbar appeared. [img]/media/kunena/attachments/legacy/images/ShowAddinsTab.png[/img]
I believe it happened because I installed another addin and this had thrown a error message relating to a command bar. After that the Add-Ins tab disappeared completely and so the XLC toolbar could not be seen. I hope this helps.
John Thistleton 7 years ago
John,
I have just installed and all appears to be working OK.
Thanks for that. John
JohnDoyle[Admin] 7 years ago
I have just uploaded XLC version 12.03.01. Can you install it and tell me how you get on.
Thanks again for your help.
John.
JohnDoyle[Admin] 7 years ago
Thank you John - I will need to review the code to understand what the problem might be. Can you bear with me for a little longer? Thanks for taking the time to reporting this in - it all helps to improve the software :)
John Thistleton 7 years ago
Hi,
It dosen't recognise the date format as you typed it "29th Feb 2012".
However when I enter the same date in a format it does recognise it will return 40968 as a numeric value.
Thanks, John
JohnDoyle[Admin] 7 years ago
Mmm very troubling.
Can you enter the date 29th Feb 2012 into a cell and format the cell as a number with no decimal places? On my system the number displayed is 40968. What do you see?
John Thistleton 7 years ago
John.
Yes that is the message.
And the expiry date is noted as 29th Feb 2012.
I am using Windows XP Pro and Excel 2007.
I have checked the date and time settings on the PC and they are correct.
Thanks, John
JohnDoyle[Admin] 7 years ago
The message you recieve from XLC should look like this:
[img size=515]/media/kunena/attachments/legacy/images/VersionDeath.png[/img]
The intention is to make sure that trial users are use the latest version of the software (active XLC Pro subscribers should never see this message).
You can close the message by clicking the top right hand "X" button this will take your browser to www.ExcelCalcs.com but Excel should remain running. Switch back to excel and press the about XLC and settings button [img]/images/stories/XLC/icons/AboutXLC.png[/img]. This will raise a form and at the top of the form it will state the expiry date for trial users. The latest version is set to expire on 29th February 2012.
Can you tell me what your system says to you?
John Thistleton 7 years ago
John,
I am still getting the same message. I have removed all reference to XLC and repeated download.
But still getting the same message and direction to website.
Regards, John
JohnDoyle[Admin] 7 years ago
I think everything is working fine for me. Please uninstall XLC and reinstall XLC let me know of any error messages that you encounter and I'll try to fathom what the problem is.
JohnDoyle[Admin] 7 years ago
Bear with me John. I am going to install on a clean computer just to check that every thing is working. Give me 10 mins or so.
John Thistleton 7 years ago
I have the same problem. I downloaded for the first time yesterday but did not use. Today I get the message. I have downloaded again today but still get the message and unable to use.
Any help?
Thanks, John
JohnDoyle[Admin] 7 years ago
Thanks for your question Doug - you can install XLC on as many machines as you like provided it is for your use only.
This is dicussed [url=/frequently-asked-questions/excelcalcs-faqs/common-misconceptions/]here[/url] and [url=/frequently-asked-questions/excelcalcs-faqs/how-to-configure-xlc-in-the-xlc-pro-mode./]here[/url].
moping 8 years ago
Thank you for providing me S/W
dhexcel 8 years ago
I got a new computer at work and would like to remove excel calcs from the old computer and install it on the new computer. Is this possible?
Thanks,
Doug
JohnDoyle[Admin] 8 years ago
Hi Greg
Sorry I did not get sooner I have been out of the office for a few days. All versions of XLC have a time limit. If you enter the XLC release code then the time limit is removed. This is to encourage people to install the latest version to keep up to date with updates and bug fixes. The latest version of XLC has a times out on 29th February 2012. You can always check the time limit using the 'About XLC and settings".
I recommend that you download the latest version and install it on your new machine.
gfs_se 8 years ago
John,
I just purchased a new computer and tried to install a new download of XLC. The install appeared to have worked, but when I try to use the add-in I get a message saying that it is an old version of the program and that it needs to be updated. My new computer is using an Intel i7 processor, and is running a 64 bit system.
I did go through the download process probably 3 times. I did not do any deleting of files or uninstalling before trying to re-download.
Any suggestions.
Greg Shea
dsopharith 8 years ago
good excelCal
jimbo 8 years ago
Jaohn, All downloaded and running well. Thanks for keeping it straightforward.
sakkarong 8 years ago
thanks, very excellent
JFKatMatrix 8 years ago
JFKatMatrix here.
Actually, I never did fix XLC on my work laptop, and we don't use roaming profiles so I have never tried deleting mine.
I am just hoping that, once a ribbon compliant version of XLC is released, the problem goes away. In the mean time I just borrow the laptop next door if I want to edit any equations.
JohnDoyle[Admin] 8 years ago
It sounds like XLC.xll is installed correctly. XLC.dll is not working correctly. Have you also run "XLC User Setup.exe" or have you tried to delete and recreate your roaming profile which seemed to solve the problem for JFKatMatrix?
yanez 8 years ago
hi. I can't see the xlc toolbar when i look at "add-ins".I use windows 7 and excel 2007. I installed xlc.dll and xlc.xll. I used the "regsvr32 xlc.dll" and it works correctly. I also wrote OVD(1)/UND(2) and it shows 0,5 so i think xlc is installed but i can't see the xlc toolbar. Please help.
boy11111 8 years ago
thanks
JohnDoyle[Admin] 8 years ago
Well I am not sure what caused them to move but as far as Excel is concerned equations are simply graphics objects or inserted pictures. Certain Excel operations can move pictures, cut and paste operations in particular. Thankfully the EQS() function is the place-holder or anchor for equations so use the 'Redraw worksheet equations' buttons so that equations are returned to their right place.
dhexcel 8 years ago
I added about 10 equations to about 10 tabs.
I saved the file and then re-opened it.
All the equations have shifted to the right and down.
I deleted them on one tab with the eraser tool and re-created them.
They re-appeared in the incorrect location again.
What could have caused this?
keithtfa 8 years ago
John
One option that would be nice to have is to be able to format the formula on the left hand side as if you were writing it by hand.
Normal preference would be to type
b=2
c=3
A= b+c = 5
However in XLC it only displays formulas on the right of a formula cell and you get
A=5 b+c
Also would be nice to be able to tick a box so that you get an = sign before formula. Thought it happens some times but not all the time.
Keep up the good work
Regards
Keith Sharp
JohnDoyle[Admin] 8 years ago
[img]/images/stories/WebLog/XLC_Ribbon.png[/img]
A new version of XLC is in the final stages of development which will be compatible with the 64 bit version of Excel 2010 (currently it works with the 32 bit version of Excel 2010, 2007 2003 and 2000). Please send us details of any features you would like to see included.
JohnDoyle[Admin] 8 years ago
OK just type in
OAT=
to produce what you are after. This is different to entering
OAT =
which will give you automatic subscripts (what a difference a " " makes) [img]/media/kunena/attachments/legacy/images/namingexamples2.png[/img]
dhexcel 8 years ago
Thanks, but I want the variable to look like this:
OAT =
with no sub-scripting or super-scripting.
Your example of "COST1 =" indicates it is possible.
Each of your examples in the reply contains sub-scripting and/or super-scripting.
I want a variable name with no sub-scripting or super-scripting.
Is this possible?
Thanks
JohnDoyle[Admin] 8 years ago
Here are some examples that I hope will help:
Make sure the "Auto XLC" Switch is on then enter the following into a cell:
OAT =
O_AT=
O_A_T=
O_A^T=
You should see the following: [img]/media/kunena/attachments/legacy/images/namingexamples.png[/img]
I hope this helps :)
dhexcel 8 years ago
I cannot get a variable name to start with more than one non-sub-scripted letter.
The variable name I want is "OAT" for outdoor air temperature.
I entered the following into excel and clicked the name equation button:
OAT
OAT=
OAT =
In every case the "A" is subscripted. I want the A and the T to not be subscripted.
I tried the "COST1=" example from the forum.
Nothing is working.
How do I get a variable name of multiple characters with no subscripting?
I read the following posts. I watched some videos. The videos stopped playing on my PC. Only the Quick start video will play and it doesn't cover my problem. The naming variables video won't play. I tried playing them on my Mac and it asks me to buy a plug in called flip4Mac. I searched some on youtube but didn't find the specific video.
#2 JohnDoyle 2010-10-18 11:06
You might want to see the XLC video tutorial series.
Re:Naming variables 7 Months, 4 Weeks ago Karma: 477 Karma+ Karma-
The default behaviours ensures that there is no confusion when multiplication signs are removed. If you do not wish enforce this naming convention (e.g. if you would like equations to read like PRICE = QUANTITY x TIME) you may end the Named Cell with just a single "=" character rather than the usual two " =" characters. You should also set the EQS() parameter "Multiplication= 1" so that multiplication signs are always shown.
E.g. XLC will enforce automatic subscripting of a cell named "A1 =" because there is a space before the final "=" character; XLC will ignore the formatting of an unconventionally named cell like"COST1=" which will be drawn into equations with this formatting because there is not a space before the final "=" character.
Read more here: www.excelcalcs.com/xlc/xlc-help-and-tutorials/name-equations/
JohnDoyle[Admin] 8 years ago
I am pleased you are up and running at last. Version 09_04 did have a problem with the 'Check Subscription' algorithm and it was corrected in version 10_01 build 03. It is always worth installing the latest version of the software.
bigwall 8 years ago
Working now but I had to delete the XLC key from the registry and reinstall.
Two versions of XLC were shown in Programs and Features when I went to uninstall XLC 11_11. Think the older version was 09_04 but I didn't write down. Older version was definately uninstalled using Uninstall XLC from the start menu folder prior to installing 11_11 but I didn't check to see if it was also removed from Windows Programs and Features. Uninstalled both versions (09_04 didn't show an uninstall window), rebooted, updated excel and windows using windows update. Reinstalled 11_11 and my Username and Release Code were still shown in the Subcription Window. XLC still wasn't working with the same problem...Run Time error 13, freezing and couldn't close excel without forcing shutdown. Uninstalled XLC, rebooted, deleted registry key, reinstalled XLC, entered my username and release code (now reset) and now seems to be working.
Fair bit of lost time but got there in the end.
raw01 8 years ago
Wow that seems to be working. That is great! I just disabled all the skype addons for all my browsers (IE, Firefox, and chrome).
To answer you're question John, this isn't a new machine I've had it for over a year and this problem has been intermittent (not surprising if the root cause was the skype addon I guess...)
Thanks everyone
JohnDoyle[Admin] 8 years ago
I noticed that recently XLC running in Excel 2010 was not showing equations. It was an intermittent fault and could always be rectified by rebooting my machine. But I set out to see what could be the route cause of the problem and I think it is the skype addin for Internet Explorer and Firefox. Forums are full of discussions where the Skype addin is causing problems with Excel and somewhere down the line it is upsetting XLC too. I advise everyone to disable the addin - as do Skype.See this thread "[url=http://forum.skype.com/index.php?showtopic=783421]Skype causing MS Excel Error[/url]". Or this one "[url=http://www.online-tech-tips.com/ms-office-tips/cannont-empty-clipboard/]Fix Skype addin for Cannot Empty the Clipboard in Office[/url]". its also [url=http://mobeer.blogspot.com/2009/01/excel-2007-cannot-empty-clipboard.html]here[/url].
I have not got to the bottom of this yet but I have disabled the skype addin and all seems to be working fine again.
bigwall 8 years ago
The error occurs when I enter Username, Release Code and check subsription.
Yes xlc.dll is installed under Excel options> Add-ins. I tried browsing to the file but still doesn't work.
Read through the Redsvr32 web page. Have no option to run as administrator when right click the dll file. Have administrator access on computer.
Have installed on other computers and works correctly on those computers. Would like to install on small laptop as I generaly take this laptop away from home.
JohnDoyle[Admin] 8 years ago
can you check to see if XLC.xll is correctly installed. Check Excel>Options>Addins
You registered just over a month ago. Have you managed to get XLC up and running on other machines. Is it just one machine that is giving you problems?
Please drop me a line if you need further help.
bigwall 8 years ago
Hi John,
I'm getting the Run-Time error 13 when trying to subscribe. Firstly happened with an early xlc version (not sure of version). Then uninstalled early version and installed V11_11. Didn't reboot the computer between installs. Been through the 10 point check. I can see the addin toolbar in excel but when I run regsvr32 XLC.dll I get the error "The module "xlc.dll" was loaded but the call to DLLRegisterServer failed with error code 0x800004005."
Using excel 2007 (full registered version) with Windows 7 starter on a Asus eee pc. No xlc functions work and sometimes after trying to subscribe or clicking an xlc function I have to force excel to close as closing normally causes excel to hang.
Any ideas?
Tony
JohnDoyle[Admin] 8 years ago
Steve
I downloaded your example and pressed the redraw button which rendered all your equations with no problem. I am perplexed as XLC must be installed correctly as you can see all the buttons. There is certainly no reason why it should not work on. Is this a problem it has recently developed or is it a new installation on a new machine?
raw01 8 years ago
Also - please note I am using 32 bit excel on 64 bit windows.
raw01 8 years ago
Hi John,
I have struck the same problem for a while now. The formula only shows intermittently, and at the moment I can't get it to show at all. Please find attached a spreadsheet I am working on which I can't get the formula to show.
I have tried the auto draw, and redraw buttons as described above, but have had no joy. I am running Windows 7 (64 bit) and 2010 excel.
Cheers,
Steve Hore [file name=J000028_ML_500_Feed_Chute.xlsx size=329593]/media/kunena/attachments/legacy/files/J000028_ML_500_Feed_Chute.xlsx[/file]
dhexcel 8 years ago
Thanks!
JohnDoyle[Admin] 8 years ago
Hi Douglas - I am afraid that XLC does not work on the mac. Probably your best option for is to use the [img =/images/stories/SaveAsNativeExcel.png][/img] button to save as a native Excel file (this removes all XLC functions removed). This will get rid of your #NAME? errors but your equations will become static graphics and will not automatically update.
dhexcel 8 years ago
I created an xlsx file on a pc using excel calcs.
When I try to open the file on my mac, it crashes excel.
Should I have saved the file as an xls, or is there some other problem?
A file from the repository does open on the mac, but cells with values show as "#NAME?". The excel calcs equations do show correctly on the mac.
The PC is at home, the mac is at work. I will try saving as an xls tonight, but wanted to know if anyone had a similar problem.
Thanks,
Douglas
JohnDoyle[Admin] 8 years ago
There appears to be no problem you are subscribed to the trial account. You are free to download our [url=/component/option,com_remository/func,fileinfo/id,374/]XLC software[/url] and try out some downloads from the [url=/repository/trial/]XLC Trial Folder[/url].
ram71 8 years ago
I requested the free trial yesterday and haven't gotten any response on progress.
I need to know if something went wrong with the information I submitted.
My company does not have a website, was that a problem?
boymanx 8 years ago
I hope you can help me, about calculation specification trommel for process gold at mining small scale...?
jgmuender 8 years ago
John,
I solved my problem below and am able to get XLC running again..
Was looking at the Bricscad site forum on another issue and ran into this that discussed a similar problem. Short story is it looks like Office 2007 install wrote bad info in the registry that affected Office 2002 (I have both Office 2002 (Office ver 10) and Office 2007 (Office ver 12) applications installed).
The 3rd suggested solution is what I followed. As I am using Windows XP Pro 32 I changed the file path slightly to the VBE6.dll, using 'Program Files' instead of 'Program Fixes (x86)'…see the highlighted below.
From http://www.bricsys.com/common/knowledge/topic.jsp?id=304
Symptoms
When running a VBA macro the following error pops up:
error: "file not found: vba.6dll"
Cause
This is probably caused by an installation of Office 2010 or another application that installs VBA 7. This installation can cause corruption of a VBA6 registry key, that causes an incorrect reference to the VBA 6 dll's.
Resolution
Possible solutions are suggested on these links :
- http://blogs.msdn.com/b/developingfordynamicsgp/archive/2010/08/27/file-not-found-vba6-dll-error-occurs-or-gp-crashes-and-creats-a-watson-fault-bucket-1474386816.aspx
- http://www.excelforum.com/excel-programming/666088-file-not-found-vba6-dll.html
- If registering VBE6.dll as suggested in the previous link doesn't help, have a look at the value of the following registry key:
"HKEY_CLASSES_ROOT\TypeLib\{000204EF-0000-0000-C000-000000000046}\6.0\9\win32"
Perhaps it points to an unexisting file, e.g. on a 64 bit system : "C:\\Windows\\SysWOW64\\msvbvm60.dll". Then try changing it to "C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL".
(delete the (x86) portion of the path if using a 32 bit OS. Best to confirm path to the VBE6.DLL file.
So my particular circumstance was installing some Office 2007 apps but keeping Excel 2002…this was done after the original XLC install, which remained ok until I upgraded. At that point the XLC install could not find the VBE6.dll as the registry was changed by Office 2007.
Hope this is helpful to others.
JohnDoyle[Admin] 8 years ago
Currently names will be constructed taking the Named column and then the row tags. I am tempted to leave it this way especially since Excel's Copy transpose can always make the swap if desired. Thanks for the comment.
adrianomv 8 years ago
I see you transposed it, and i'm getting pretty well your instructions. But is there a possibility to do that: to switch the naming order?
JohnDoyle[Admin] 8 years ago
adrianomv maybe I should have explained that to generate the second chart I simply copied the first table and used Excel's "Paste Special" command to transpose the table. I'm not sure how the commands appear in Portuguese but you seem to have coped pretty well with my English instructions so far :)
adrianomv 8 years ago
Thanks, i would be very thankful if you can teach me how to switch this function. I can see that in this example, it's a little odd. But it's exatly what i was trying to do in the real calc (which is in portuguese).
JohnDoyle[Admin] 8 years ago
I'm probably not quite following what you are trying to achieve but using current XLC functionality to display formulas within tables you could present your calculation in one of two ways (as shown below). However XLC always follows the convention of the column name followed by the tagged row name. I could change this convention if it would be useful to do so.
[img size=513]/media/kunena/attachments/legacy/images/Untitled.png[/img]
adrianomv 8 years ago
Thanks, John. But, actually i wish to invert this naming. creating something like "R1a" (Room1 area), instead of "Ar1". making the first letter reffer to the lines not to the columns. Did you get?
JohnDoyle[Admin] 8 years ago
Sorry I did not reply sooner but XLC can be used to display formulas in tabular form. [url=/ExcelCalcsTV/videodirectlink/50-making-equations-from-tabular-data/]You should take a look at this video[/url].
JohnDoyle[Admin] 8 years ago
I appreciate that you may well be disappointed with this news and I am happy to refund your subscription. We have some longer term plans to develop a version of XLC which will work with 64 bit Excel 2010 but this could take some considerable time.
JohnDoyle[Admin] 8 years ago
Hi Simorag. I am afraid that XLC is not compatible with the 64 bit version of Office 2010. The download page reads:
simorag 8 years ago
Hello,
just installed XLC on Win7 Ultimate / Office 2010 64bit (both Italian), but I cannot see the add-in in the ribbon.
I have even tried registering manually the dll, with success, but no add-in toolbar again.
Lastly, I tried to uninstall / reinstall but again with no luck.
I am attaching a screenshot of the Excel add-in list where Excel Calcs is mentioned.
Can you please help?
Thanks,
S [img size=557]/media/kunena/attachments/legacy/images/excel_screenshot.png[/img]
adrianomv 8 years ago
my calculation, simplifying, is something like that
[url=http://postimage.org/image/2j6pts2v8/][img size=454]/media/kunena/attachments/legacy/images/figure_1.JPG[/img]http://s3.postimage.org/2j6pts2v8/figure_1.jpg[/img][/url]
And, using XLC goes something like that
[url=http://postimage.org/image/2jdp7gtxg/][img]http://s3.postimage.org/2jdp7gtxg/figure_2.jpg[/img][/url]
Is there another easier way to do that without adding all this rows and naming all this cells?
There's the tabular buttom but, i didn't got the point to this problem through the tutorial.
Otherwise it will be easier use the "show formula" function from excel.
Adriano
JohnDoyle[Admin] 8 years ago
This is actually the way we way we intended XLC to work. There are a number of special characters:
"_" will subscript the proceeding character (and then delete itself)
"^" will superscript the proceeding character (and then delete itself)
"|" will change the proceeding character to its Greek equivalent (and then delete itself)
The idea is that typing mathematical equations is made easier (it can be a bit time consuming using native Excel). The same rules are used in out text processing button and can be used with ordinary cells, chart titles, text in shapes etc.
However I can see in your case when you want to use the "_" character in a name it must be frustrating. May I suggest that you use another character rather than "_" like "-" or "."
Thanks for another good question - I think other uses may benefit from reading this.
JFKatMatrix 8 years ago
When naming a variable in the 'no-space' manner - i.e. "=" rather than " =" - my underscore characters disappear and the subsequent character is subscripted. I have attached a picture that hopefully illustrates the case.
Two questions: - Is this a 'hidden' feature of ExcelCalcs, or something Microsoft have cooked up? - Is there any way I can disable it or otherwise work around? [img size=384]/media/kunena/attachments/legacy/images/ExcelCalcs_Issue.jpg[/img]
JohnDoyle[Admin] 8 years ago
Hi Gordon, thanks for your question. I too have worried about the best way to display if statements. My advice is to keep your IF() functions as simple as possible so that they are more readily understood. If you look in text books words are often added to explain the logic this is easily done in Excel too. As an example I am just working on a calculation for plastic stress distribution in a rectangular beam. [img size=407]/media/kunena/attachments/legacy/images/plastic.png[/img]
Gordon 8 years ago
I use XLC to document my calcs in Excel. I assume I don't need to tell anyone here how glad I am for XLC. Occasionally, however, I have an equation that I just can't format the way I want using XLC, usually thanks to the building code writers. It typically goes something like this:
w = 4 x h_sub(d) if h_sub(d)<= h_sub(c) or 4 x [h_sub(d) / h_sub(c)] otherwise, but <= 8 x h_sub(c)
If I write something like this in MS Equation Editor or in MS Word and then paste it in it gets the job done (painfully, compared to XLC), but eventually they seem to blow up. One day I'll open the spreadsheet to find out that those equations have decided to double in size, and it's a pain to fix them once, let alone more. I like pasting in from MathCad for ease of equation writing, but their formatting is odd and doesn't match XLC.
What does anyone else do? Asking XLC to handle "if" statements is a lot, and often there isn't space to break them down and document every step with XLC...in a calc I really want to keep to one page of output.
thanks,
Gordon Goodell
JohnDoyle[Admin] 8 years ago
I think the problem may be with your windows user profile not a roaming profile this will be more familiar to your administrator. See below taken from later in the the thread I referred you to.
Without access to your system it is hard for me to understand exactly what the problem is but from experience it is generally:
1) problems with not having administrator rights to install software.
2) Occasionally problems with the Windows User Profile which have been resolved remotely by system administrator and I don't have a full understanding of the problem.
I am going to raise this with a colleague, a very talented software engineer, to see if he can throw any light on the situation. Please bear with me.
JFKatMatrix 8 years ago
After tracking down our network administrator, I am informed that we do not use the 'roaming profile' functionality of Windows, so I have no 'roaming profile' to delete.
Maybe I could create my own toolbar buttons...
JohnDoyle[Admin] 8 years ago
I think it might be a problem with your Windows User profile. This has occasionally troubled some people. See [url=/forum/xlc-issues/solved-%11-installation-problem/6/6/#1808]this thread[/url].
It may also be worth doing this:
" If you require an administrator to install your software Ask your administrator to install XLC following the instructions above.
IMPORTANT: To set the computer up for your user account he will also need to run "XLC User Setup.exe". " - You'll find this in the XLC zip file.
JFKatMatrix 8 years ago
Have checked the status of the addins (see attached image). I note that the "Solver" addin parks itself on the "Data" ribbon. You haven't hidden the ExcelCalcs buttons somewhere else have you?
Both addins seem to have installed correctly, and the functions work within the spreadsheet, just no toolbar... [img size=767]/media/kunena/attachments/legacy/images/Excel_Addins.jpg[/img]
JohnDoyle[Admin] 8 years ago
It may also be worth restarting Excel. Sometimes it helps if you uninstall XLC (Windows Start button>XLC>Uninstall XLC). Then re-install it.
JohnDoyle[Admin] 8 years ago
I should check that it is listed and enabled. Goto File>Options to raise the Excel Options form then select Add-Ins you should see two Add-Ins related to XLC (XLC.dll this is the toolbar and XLC.xll this holds the XLC function). Check that they are both listed as active application add-ins.
JFKatMatrix 8 years ago
Sorry to say I am also having problems with the 'hidden' tool bar. Will get on to IT about the roaming profile, but in the mean time:
I am running Windows 7 and Excel 2010
When I register XLC.dll I get the following message: "DllRegisterServer in XLC.dll succeeded."
Any tips I have missed on the forums?
JohnDoyle[Admin] 8 years ago
Hi Gloria
I opened the spreadsheet and saw no equations but there was an eqs() function in cell F7 so I simply pressed the redraw all equations button [img]/images/stories/NoEqNos.png[/img]and the equation appeared.
You might want to check that XLC automatic functionality button[img]/images/stories/AutoXLC.png[/img] is switched on - this means that equations will be automatically drawn when an EQS() function is inserted.
You'll find more help in the [url=/help-and-tutorials/]help & tutorials page[/url].
gkstarns 8 years ago
John,
XLC appears to be correctly installed on my machine but the show equation feature is not working. (I have attached my spreadsheet).
Thank you for your help.
Gloria [file name=show_equation_gkstarns.xlsx size=12894]/media/kunena/attachments/legacy/files/show_equation_gkstarns.xlsx[/file]
ArthurJM 8 years ago
John,
Thanks again for your reply.
The trouble may have been caused by not having entered the release code.
It all seems to be working well now that I have. I'm looking forward to my next bit of Excel programmming.
Regards
Arthur
JohnDoyle[Admin] 8 years ago
Arthur I think everything is working as it should. Here are a few comments on your spreadsheet that I hope will help:
You need to configure XLC on the XLC Pro mode to loose the "non-commercial message" by [url=/frequently-asked-questions/excelcalcs-faqs/how-to-configure-xlc-in-the-xlc-pro-mode./]following these instructions[/url].
The error message "#CellD26 not named" simply tells you that cannot build an algebraic equation because D26 is not named. I can see that cell D15 is named its name is Whs and this will be inserted into an equation. The [url=/help-and-tutorials/]tutorials [/url]cover this.
You don't necessarily have to name all your cells. You may choose to display numeric equations rather than algebraic equations in which case naming is not required. [url=/ExcelCalcsTV/videodirectlink/51-switch-between-algebraic-eqation-display-and-numeric-equation-display/]Tutorial 11[/url] covers this.
XLC default options are set by following [url=/ExcelCalcsTV/videodirectlink/30-xlc-quick-start-06/]tutorial 6[/url].
I have updated your spread sheet following [url]tutorial 3[/url]. Please find attached. [file name=learning_XLC_2.xls size=111104]/media/kunena/attachments/legacy/files/learning_XLC_2.xls[/file]
ArthurJM 8 years ago
John,
I'm afraid the problem hasn't gone away.
It appears to settle down for a few minutes and next thing the worksheet is gone and messages appear saying that there is no formula in one of the cells.
It has happened with several files but I am attaching the one I am using for learning.
I am wondering if the is a global settng causing the problem.
Hope you have a nice Easter weekend.
Arthur [file name=learning_XLC.xls size=38400]/media/kunena/attachments/legacy/files/learning_XLC.xls[/file]
JohnDoyle[Admin] 8 years ago
Hi Arthur you just need to follow [url=/frequently-asked-questions/excelcalcs-faqs/how-to-configure-xlc-in-the-xlc-pro-mode./]these instructions[/url] to remove the "non-commercial use message".
I am pleased everything settled down. Thanks for your enthusiasm about the product I know I am slightly biased but I genuinely believe that all engineers need XLC. If you need any more help at all getting up and running just drop me a line.
Welcome on board.
ArthurJM 8 years ago
Thanks for your reply John.
I restarted Excel and the formulae are now appearing.
Just still have the non-commercial use note appearing. Maybe I am not fully registered yet though I did confirm my email address form the email sent after I purchased.
I am looking forward to using this system; it looks just what I need.
Arthur
JohnDoyle[Admin] 8 years ago
Arthur this does not sound at all good. I have never had such a report in the past. The first thing I would do is restart Excel and see if the problem persists. You can attach the spreadsheet to your next post and I'll see if I have the same problem. I'll do my very best to get to the bottom of this.
ArthurJM 8 years ago
I just started using XLc and everytime I press the button to show the formulas one or two worksheets dissappear including the one I am working on.
Any ideas as to what is going wrong.
Arthur
panda5 8 years ago
thanks
gandalf69 8 years ago
All YouTube videos are fast, can be downloaded and the resolution is generally adequate.
JohnDoyle[Admin] 8 years ago
Often there seem to be problems player the windows media player from the site. I post all the videos to our YouTube Channel too. These seem to play more reliably but there is a loss in resolution. See http://www.youtube.com/user/ExcelCalcs#p/u
gandalf69 8 years ago
I can't view it but perhaps that is because I Use VLC as my media player.
JohnDoyle[Admin] 8 years ago
Please just try to download again. Sometimes there are interruptions to the download process nothing to do with this site but service providers. This is a common question and is always resolved by downloading again.
lkim 8 years ago
When attempting to download the XLC add-on, I get the message 'compressed folder invalid / corrupt'. The folder looks to be the correct size, 1mb.
:unsure:
JohnDoyle[Admin] 8 years ago
Spacer I have copied my email response to you here in the forum in case any other user is following the thread.
JohnDoyle[Admin] 8 years ago
Spacer I have sent you an email privately. Send me the file and I'll take a look at it.
spacer 8 years ago
How can I send you the file without posting it to the site?
I've determined that this is the sequence that causes the problems.
1. I display the formula of the calculation.
2. To double check the formula, I select the image of the formula and then click the add-in to change to the numeric display. Most times this works. Sometimes, the numeric version is superimposed over the formula with the enite cell outlined with a black border. Since there is no undo (apparently) for the add-in functions, I select and delete to clear the cell and then use the "show equation" funtion to try to redisplay the formula. This is where the = variable name shows up instead of the formula. Rpeated attempts to delete and insert formula only shows the = variable name. At this point my only option is to delete the entire row, not just clear, and put it all back in mannually.
JohnDoyle[Admin] 8 years ago
Could you upload a sample file so that I can see the problem and I'll be happy to check it out for you.
spacer 8 years ago
I occassionally have problems with the displayed formula simply repeating the variable name after an "=". The computed value is correct but the defined formula is not shown as input. Only deleting the entire row appears to correct the problem. Suggestions on what I am doing incorrectly?
JohnDoyle[Admin] 8 years ago
Thanks for reporting this in. This has been a problem in the past because ms media player does not seem to be well supported by all browsers. I always check the site using Internet Explorer and Firefox which seems to cover most people out there.
I like windows media player file for screen capture because they are pretty compact and render the screen better than YouTube media. They play very well when maximised on a full screen too.
It may be an error I made on the XLC help page so could you tell me if you can you play the following videos played in the ExcelCalcsTV viewer e.g. /ExcelCalcsTV/videodirectlink/25-xlc-quick-start-01/
Thanks again for your help.
becoleman3 8 years ago
Found them on You Tube, thanks anyway.
becoleman3 8 years ago
I am having problems running the tutorials on your site. When I click on the play button nothing happens. When I do a right click and hit properties the length comes up as 0, so I don't know if the video files aren't there anymore?
Suggestions?
JohnDoyle[Admin] 8 years ago
The default behaviours ensures that there is no confusion when multiplication signs are removed. If you do not wish enforce this naming convention (e.g. if you would like equations to read like PRICE = QUANTITY x TIME) you may end the Named Cell with just a single "=" character rather than the usual two " =" characters. You should also set the EQS() parameter "Multiplication= 1" so that multiplication signs are always shown.
E.g. XLC will enforce automatic subscripting of a cell named "A1 =" because there is a space before the final "=" character; XLC will ignore the formatting of an unconventionally named cell like"COST1=" which will be drawn into equations with this formatting because there is not a space before the final "=" character.
Read more here: /xlc/xlc-help-and-tutorials/name-equations/
spacer 8 years ago
Is there a way to name a variable with more than a single letter such as AA instead of just A?
JohnDoyle[Admin] 8 years ago
This seems strange HarmonEngineering. I can't see how XLC could cause this to happen. Would you like to attach your spreadsheet and I'll take a look at it.
HarmonEngineering 8 years ago
I have a similar problem. After bringing in the equations, if I click anywhere on
the spreadsheet, a stack of cells gets selected rather than just a single cell.
If I just keep clicking around on the spreadsheet, it seems to go back to a single cell selection. Odd.
JohnDoyle[Admin] 9 years ago
Recently I had some correspondence with another Windows 7 user who also struggled to install XLC. He managed to resolve the problem and I wondered if you could check out his solution?
A google search on "DllRegisterServer failed with error code 0x80004005" showed this [url=http://www.mydigitallife.info/2007/07/25/the-call-to-dllregisterserver-failed-with-error-code-0x80004005-on-windows-vista/]page[/url] which also seems to point at User Account Control Settings.
crystalinv 9 years ago
I have downloadeded XLC. anytime i try installing i get this error message '[b][i]Unable to register the DLL/OCX: Redsvr32 failed with the exit code 0x5[/i][/b].'
I'm running MS Office 2010 Professional Plus on Windows 7 Home premium 64 bit Operating system.
I also tried registering manually by following the instructions in the read me, but get this error [b][i]"The module "XLC.dll" was loaded but the call to DllRegisterServer failed with error code 0x80004005"[/i][/b]. I have attached a screenshot of the error. Thanks. [img size=673]/media/kunena/attachments/legacy/images/Error.jpg[/img]
JohnDoyle[Admin] 9 years ago
Hi Craig sorry to hear you are having problems with the installation. Let me reassure you that we offer a full refund if you are not entirely satisfied. This has never happened so far and I expect we can overcome any problems. Please ask your IT to contact me (see 'Contact Us' on the right hand side of the website). I'll can guide him through a few checks. If you view the forum you'll see quite a few people have had installation problems this is generally to do with unsuccessful download, admin privileges or user access account problems.
Running the setup.exe file is generally all you have to do but if this fails I can run through a manual installation process where we can check progress stage by stage. Its is important that I get some feedback on each stage and find out any error messages that may be thrown up:
There are two files Excel needs to have access to for XLC to run successfully
A ) XLC.dll (this is the toolbar component).
B ) XLC.xll (this contains special XLC functions).
You will find both files in the install directory (Default C:>program files>XLC )
PART 1 - Check XLC.dll installation
===================================
Follow these instructions to register manually:
1) goto start button and select "run"
2) type in "cmd" this will get up a command prompt window.
3) navigate to the xlc install directory (use "cd" commands usually "cd C:>Program Files>XLC" )
4) check using "dir" that two files are present XLC.dll and XLC.xll
5) register XLC.dll by typing "regsvr32 XLC.dll" into the command prompt window. - you should get a message saying you have succeeded in registering.
6) hopefully you can see the toolbar when you start Excel.
PART 2 - check XLC.xll installation
===================================
7) In Excel go to Tools>Add-Ins... This displays the Add-ins form.
8) From the add-ins form select the browse button and navigate to your XLC installation directory. Select the xlc.xll and press 'OK'. This has manually installed xlc.xll
9) Close Excel and restart it again.
PART 3 User Access
==================
10) Administrators have access to the program but to set the computer up for a particular user account sign in as a user and ask your administrator to run "XLC User Setup.exe".
ccweems 9 years ago
I watched the IT admin run the install programs and I assume they ran ok - do they give any message of a sucessfull install? If not they should. Open Excel and no XLC toolbars nor is it listed in view list of toolbars. Did brouse to addin and installed it. It does show up on the addin list but no toolbars or program functionality (=OVD(1)/UND(2) only results in text). I expect the XLC.dll file is not loaded. I can get IT back but I have to be carefull, if they smell a rat (unauthorised software) they'll fold. Ouch! the 90USD came out of my pocket, not expenses. What next? Is there a preferred method of install? TIA
Craig
jimpayne 9 years ago
Thanks, I will probably upgrade in the next 6 months or so. Spreadsheets are still usable so it should be worthwhile to stay registered. Jim
JohnDoyle[Admin] 9 years ago

I think you have merged the cells. To un-merge select the merged cells. Then a right chick with the mouse button should show "Format Cells" - select the "Alignment" tab and under "Wrap text" and "Shrink to fit" you'll see "Merge cells" - just uncheck this box and all should be good again.
I hope this answers all your questions.:)
gfs_se 9 years ago
Is there a way to format the equations so that they appear in the same text as the other data in the spreadsheet? I started working on a spreadsheet over a year ago, and I seemed to have gotten the equations to look similar, but now I get a completely different font and spacing. I would also like to change the multiplication character to something larger, but still a dot centered in the font height. The options has a place to change the multiplication symbol, but how do I get somethinmg other than a keyboard character?
I also run into a problem occasionally where after bringing in an equation, when I try to click on a single cell several vertical stacked cells will highlight. Can I get back to a single cell, and what is the cause?
JohnDoyle[Admin] 9 years ago
I am afraid that XLC will not work with versions of Excel before Excel 2000. This is documented in the frequently asked question section of the site: /frequently-asked-questions/excelcalcs-faqs/excel-2000-or-later/
Jim I can see that you recently purchased an XLC Pro subscription and we'll gladly give you a full refund if you wish. We are sorry that we can't make XLC work in Excel 97 but it is based on technology that was introduced for Excel 2000.:(
jimpayne 9 years ago
I have downloaded XLC and attempted to install as per instructions for Excel 2003. No go. Will XLC work with Excel 97 and if I missed something how do I get it work? Thanks, Jim :(
JohnDoyle[Admin] 9 years ago
Thank you for your kind comments eng619 your query has been asked a number of times so I thought it was about time I uploaded a video to cover good techniques when working with tabular data in Excel. The video is in two parts. [url=/ExcelCalcsTV/videodirectlink/64-using-tabular-data-in-excel-calculations-part-1-of-2/]Part 1 is here[/url] and [url=/ExcelCalcsTV/videodirectlink/65-using-tabular-data-in-excel-calculations-part-2-of-2/]part 2 is here[/url].
Here at ExcelCalcs we endeavour to serve a community brought together through a common interest in making calculations in Excel. One of its strengths is that we seem to have attracted a number of very skilled professionals who use Excel in the most innovative ways. Personally I get great pleasure in receiving spreadsheets to learn different approaches and techniques in the application of Excel. Excel is vast and there is a lot to learn and I am still learning. If you need any help in developing spreadsheet for publishing on the site you find all of us will only be too glad to help you out in any way we can.
eng619 9 years ago
i am new to excelcalcs and very impressed with the spreadsheets....i would like to start developing some ....i do mostly civil, structural and geotechnical calculations....however, i am still trying to figure out the best way to perform some of the advanced functions on excel - such as selecting a beam and having the properties come up in designated cells ...i have bought quite a few books on excel, but none of these seem to get me up to par with the other professionals on this site ...could someone please direct me to a site, book, planet to elp me gain the knowledge? .....thanks
gutierg 9 years ago
I am pretty sure this site and all of its excellent content will facilitate my life a whole lot.

Thank you,
German
Akinola 9 years ago
thanks
JohnDoyle[Admin] 9 years ago

I think all you need to do is enter "do =" by putting the "=" character in the cell XLC recognises it as an equation name and it will automatically format as such by subscripting the "o" character.
JohnDoyle[Admin] 9 years ago
Yes I am using it on a 64bit Vista operating system at the moment.
jimschu 9 years ago
Can I install XLC on a 64 bit system
relu59 9 years ago
Thanks!,
very useful tool for engineers
JohnDoyle[Admin] 9 years ago
So what does your computer say when you register XLC.dll (regsvr32 XLC.dll)? The message is important to my understanding.
Another idea: Try deleting your Network User Account. this appears to have worked for two other people. It is tracked in this [url=/forum/xlc-issues/solved-%11-installation-problem/6/6/#1808]forum thread[/url]. I can't reproduce the problem to debug it and understand the issue but this is probably worth a try too.
Ron Mitchell 9 years ago
John,
Thanks for the reply. I followed all of these steps and still have no XLC toolbar on the Add-Ins ribbon. Two of us at the office have the same problem. Our IT department cannot figure it out. Any suggestions?
Ron
JohnDoyle[Admin] 9 years ago
Sorry for the slow response Ron. I have been travelling on business the past couple of days. If the XLC toolbar does not show then it is almost certainly a problem with registering XLC.dll. Please follow these instructions:
Follow these instructions to register manually:
1) goto start button and select "run"
2) type in "cmd" this will get up a command prompt window.
3) navigate to the xlc install directory (use "cd" commands usually "cd C:Program Files/XLC"
4) check using "dir" that two files are present XLC.dll and XLC.xll
5) register XLC.dll by typing "regsvr32 XLC.dll" into the command prompt window. - you should get a message saying you have succeeded in registering. It may give an error message and I would be interested in what this says.
Ron Mitchell 9 years ago
Hello John,
The two of us at the office are using Excel 2007 and cannot get the toolbar to show up in the Add-In Ribbon.
JohnDoyle[Admin] 9 years ago
I have just picked up your voice mail Ron in which you say that XLC is still working but you can't see the toolbar. If you are using Excel 2003 it may be that you have hidden the toolbar. You can un-hide it from the excel main menu view>toolbars>XLC. I hope this solves your problem.
Ron Mitchell 9 years ago
The XLC toolbar disappeared in my Add-In ribbon over the weekend. I have followed all of the procedures you have posted on the forum and while the two XLC.dll and XLC.xll files are present and the XLC.dll file has been registered, the XLC toolbar is still not showing up. I have tried unistalling and installing the XLC software twice, and still no toolbar. Do you have any suggestions on how I can get the toolbar back? A couple of weeks ago another worker at this office had the same problem and he has not been able to use ExcelCalcs. I have checked that everything is operational. Equations generated in the past still work and even change when the cell where the equation is changed, but I cannot display new equations without the toolbar.
JohnDoyle[Admin] 9 years ago
I am posting this email conversation in case it is useful to other users
odisious 9 years ago
Thanks.
bangpoo 9 years ago
bangpoo 2010-06-10 very excellent
turgutbilen 9 years ago
thanx
raw01 9 years ago
I followed your instructions and it worked! I got the succeeded in registering popup and now the addin ribbon is showing.
Thanks for your help. Great product by the way.
JohnDoyle[Admin] 9 years ago
Sorry you have been having some trouble. I still have not got to the bottom of this but it certainly has effected a few users in the past. The problem is that I cannot reproduce it on my machine to attempt to debug it. I'm pleased to see that you have managed to follow the advice in the forum.
Since "=OVD(1)/UND(2) is showing 0.5" XLC.xll is installed - good.
If the toolbar is not showing then XLC.dll is not installed properly. Let's see if we can do it manually. Can you log in as administrator?
Follow these instructions to register manually:
1) goto start button and select "run"
2) type in "cmd" this will get up a command prompt window.
3) navigate to the xlc install directory (use "cd" commands usually "cd C:\Program Files\XLC")
4) check using "dir" that two files are present XLC.dll and XLC.xll
5) register XLC.dll by typing "regsvr32 XLC.dll" into the command prompt window. - you should get a message saying you have succeeded in registering. It may give an error message and I would be interested in what this says.
6) hopefully you can see the toolbar when you start Excel.
raw01 9 years ago
I have tried installing xlcalcs but the ribbon won't show... I have tried =OVD(1)/UND(2) and I get 0.5, so the program is there, just the ribbon part isn't working. I tried deleting my user account and creating another and it didn't work. What should I do now?
Cheers.
vvjjoshi 9 years ago
thanks for a demo version
hoda786 9 years ago
Thanks.
bhupesh.nandurkar 9 years ago
Thanks.
JohnDoyle[Admin] 9 years ago
Ron I am working in Excel 2010. Why not send me a copy of your calculation (or an example which features the problem) and I'll try to get it working for you?
Ron Mitchell 9 years ago
John,
I tried unprotecting the cells containing the formulas, with no success. Maybe that is because I am using Excel 2007. I can live with the problem by explaining to the checker of the calculation that these cells are not updating when changing the value in the input cells.
Thanks for looking into this issue.
Ron
JohnDoyle[Admin] 9 years ago
This is a very interesting question Ron. I tend to keep all my workbooks unprotected but keep original versions of the calculation in the ExcelCalcs repository so I can always download a 'fresh' copy.
I have played around with cell protection to investigate your problem and I found that if the equation show function, EQS(), is in a locked cell and the spreadsheet is protected then equation graphics will not automatically update (or in deed manually update). This is not a problem if the EQS() function is showing symbolic formulae because equations do not change but if you have set the graphic to show working (i.e. numbers not algebra) then the equation does need to be redrawn to show the changed number.
Equations will always update in a protected worksheet provided that the cell containing the EQS() function is unlocked (format cells>protection and uncheck the locked property). I hope this is the answer you are looking for.
Ron Mitchell 9 years ago
I have an Excel calculation that I want another engineer to check and in order to keep him from altering formulas used in the calculation, I protected the workseet with only input cells unlocked. I noticed that the XLC formulas will not update until I have unprotected the workseet. I have tried to unprotect the cells where the formulas are located without success, i.e., the formulas will not automatically update when the input is changed. Is there a way for the XLC formulas to be updated in a protected worksheet without unprotecting?
Thanks for any help
Ron Mitchell
balumagesh 9 years ago
Thanks.
JohnDoyle[Admin] 9 years ago
We get this reported a lot but generally it is a problem with internet connections. I have just downloaded and upzipped the file so I can assure you that it is working. Please download again. Check the downloaded file size matches the file size on the download page (currently 1,038.22 Kb) and you should have no problems.
msabla 9 years ago
When I try and download the file, it says its not a valid format. I am running Windows 7 and using the new version of WinZip to try and download the file. Can anyone help me?
recalvino 9 years ago
very useful tool for engineers
JohnDoyle[Admin] 9 years ago
Let's take this one problem at at time:
1) Can't get download to work - The download is working you may have some problems with your browser or internet connection.
2) No extension on unzipped file - Does this mean that the download did work? The following files: [img size=398]/media/kunena/attachments/legacy/images/ZippedFiles.png[/img]
3)Excel is locking up - did you manage to install XLC?
Please be assured that XLC can be downloaded and installed easily. Thousands of people have managed to do this.
rsmith4austin 9 years ago
Help...
JohnDoyle[Admin] 9 years ago
Hi Jimmy well we can conclude that the installation program failed due to registration problems and it sounds like a problem with Administrator rights on the computer. I found the following recommendation on [url=http://www.mydigitallife.info/2007/07/25/the-call-to-dllregisterserver-failed-with-error-code-0x80004005-on-windows-vista/]another website[/url] and copied it below. I hope it can help you resolve the problem.
StTomas 9 years ago
Hello,
Thanks for your replay but it still don't work. When I try to register using
CMD as administrator it says "The module "XLC.dll" was loaded but the call to DllRegisterServer failed with error code 0x80004005". When I try to add
XLC.xll in add-in (office 2010) it says "XLC.xll" is not valid add-in." I have disabled UAC too. So I don't know what's wrong...
best regards
Tommy
JohnDoyle[Admin] 9 years ago
If the install program has not worked we could try to install it manually following the step by step instructions in the Readme.txt file which is included in the XLC download. I'll need you to record the computers response at each step of the process so I can figure out where the problem is. I'm sure we'll get there in the end. The instructions are copied below:
If you have Administrator rights on your PC
===========================================
If you are upgrading first uninstall your existing version of XLC (Start>Programs>XLC>Uninstall XLC).
Install XLC by running "setup.exe". When you next start MS Excel you will see the XLC toolbar:
Excel 2007 Users - Look on the ribbon under "Add-Ins".
Excel 2003 to Excel 2000 users - XLC appears as a toolbar (by default it is visible but if you can't find it check Excel's main menu View>Toolbars>XLC Tools).
For a quick start go to the on-line help tutorials and you'll be displaying mathematical equations in Excel in less than 10 minutes (/help-and-tutorials/).
If you require an administrator to install your software
========================================================
Ask your administrator to install XLC following the instructions above.
IMPORTANT: To set the computer up for your user account he will also need to run "XLC User Setup.exe".
Trouble-shooting
================
Most people will not have any problems installing XLC but in case you have any difficulties here is an explanation of the install process and 10 checks you can perform to help diagnose any faults. If you have run through the 10 checks and still have problems we will be very keen to hear from you through the support forum you may have found a problem that we are not aware of (/forum/xlc-issues/)
There are two files Excel needs to have access to for XLC to run successfully
A) XLC.dll (this is the toolbar component).
B) XLC.xll (this contains special XLC functions).
You will find both files in the install directory (Default C:\program files\XLC\)
PART 1 - Check XLC.dll installation
===================================
Follow these instructions to register manually:
1) goto start button and select "run"
2) type in "cmd" this will get up a command prompt window.
3) navigate to the xlc install directory (use "cd" commands usually "cd C:\Program Files\XLC")
4) check using "dir" that two files are present XLC.dll and XLC.xll
5) register XLC.dll by typing "regsvr32 XLC.dll" into the command prompt window. - you should get a message saying you have succeeded in registering.
6) hopefully you can see the toolbar when you start Excel.
PART 2 - check XLC.xll installation
===================================
7) In Excel go to Tools>Add-Ins... This displays the Add-ins form.
8) From the add-ins form select the browse button and navigate to your XLC installation directory. Select the xlc.xll and press 'OK'. This has manually installed xlc.xll
9) Close Excel and restart it again.
PART 3 User Access
==================
10) Administrators have access to the program but to set the computer up for a particular user account sign in as a user and ask your administrator to run "XLC User Setup.exe".
StTomas 9 years ago
I have the same problem using Windows 7 and Office 2010...I have run
CMD as administrator and the problem is the same :/ Can someone help me?
I would like to try this addin.
best regards
tommy
JohnDoyle[Admin] 9 years ago
I have been reviewing the code and I think I have corrected a potential type mismatch problem which is a possible culprit for generating the error message. I have corrected it and you can download [url=/repository/add%11ins/xlc-addin-for-ms-excel/]XLC 10_01 build 03 here[/url].
pandavision 9 years ago
I get the run-time error when I press the "check subscription" button on the settings or account details page in the popup window. Both versions do the same thing for me.. which is run-time, type mismatch. I'm not sure what that part is about and I'm also not sure that the add-in is working correctly for me. But that's okay. I really just wanted one spreadsheet in particular to play with and I have it. Others are very useful too, so I'm glad this place exists. Thanks for your help.
JohnDoyle[Admin] 9 years ago
Sorry to hear this. I had managed a work around for tmy1337 but we worked it out off the forum by direct email. There is some issue with the new functionality in the latest version. I have not specifically diagnosed the problem because I manage to reproduce the error on any of my machines.
The work around was simply to keep with the previous version of XLC. You can [url=/repository/add%11ins/old-version-of-xlc./]download it here[/url].
In the interests of finding a more satisfactory solution to the problem would you agree to run some tests for us?
pandavision 9 years ago
I have a run-time error 13 too, so count me as your second person!
JohnDoyle[Admin] 9 years ago
tmy1337 I have added some error handling code to XLC. I have uploaded it as [url=/component/option,com_remository/func,fileinfo/id,374/]XLC 10_01 Build02[/url]. Please install this and let me know what happens. Can you check if the automatic features are working too. Thanks for reporting the error in.
JohnDoyle[Admin] 9 years ago
Transcript of Live Support Discussion:
tmy1337 - Anonymous from the web says (09:58): Hi
Live Support says (09:58): Hi
tmy1337 - Anonymous from the web says (09:58): im haveing problem with getting XLC to work i get an "run-time error 13"
Live Support says (09:59): OK - you have seen my forum response?
tmy1337 - Anonymous from the web says (09:59): yeah, and i tryed to uninstall but got the same error
Live Support says (10:00): oh
tmy1337 - Anonymous from the web says (10:00): but im running 64bit with windows 7 could that be the problem?
Live Support says (10:00): Any error messages on installation?
tmy1337 - Anonymous from the web says (10:00): nope
Live Support says (10:01): I'm running 64bit with windows vist with no problems
tmy1337 - Anonymous from the web says (10:01): and the XLC adding pops up in excel but as soon as i type something i get an error
Live Support says (10:01): What version of Excel?
tmy1337 - Anonymous from the web says (10:01): 2007
Live Support says (10:02): So you start Excel and get the runtime error immediately?
tmy1337 - Anonymous from the web says (10:04): i start excel and the XLC add-inn is there and i can clikc the buttons but as soon as i type something i excel like a constant or a number i get run-time error 13 and the XLC buttons stopp working
Live Support says (10:05): Weird - lets see if the problem is asscoiated with XLC's automatic features. We can switch this off.
Live Support says (10:06): The first button on the toolbar swoitches it off.
tmy1337 - Anonymous from the web says (10:06): 1 sec
Live Support says (10:06): Sounds like you may have to restart Excel first
tmy1337 - Anonymous from the web says (10:07): yes its working now thanks alot
Live Support says (10:08): Ok but there is a problem with the automatic features sounds like it is causing a problem.
tmy1337 - Anonymous from the web says (10:08): oki
Live Support says (10:08): The automatic features are worth having.
Live Support says (10:09): You can us the manual redraw equations whilst I look into this further.
tmy1337 - Anonymous from the web says (10:10): yeah, no problem
Live Support says (10:10): I am going to boot up Excel 2007 and see if I get the same problem. I'll be back in 5 mins or so.
tmy1337 - Anonymous from the web says (10:10): oki
Live Support says (10:19): You still there?
tmy1337 - Anonymous from the web says (10:20): yes
Live Support says (10:20): Its working fine on my Excel 2007 installation so there must be something about your installation which is different. Do you have any other addins installed?
tmy1337 - Anonymous from the web says (10:21): nope no other addins but im useing a Norwegian version could that be it?
Live Support says (10:21): I can't see this being a problem
Live Support says (10:22): The automatic functions simply check any cells have changed that require an equation update so I am struggling to think what the problem might be.
tmy1337 - Anonymous from the web says (10:23): ah i see
Live Support says (10:23): particularly as XLC is working in a manual mode Runtime error 13 errors are usually when one piece of software is in conflict with another
Live Support says (10:24): but if XLC is working...mmm
tmy1337 - Anonymous from the web says (10:24): got the same error at my laptop
tmy1337 - Anonymous from the web says (10:25): but the other functions seems to work
Live Support says (10:25): well I am pleased you are seeing some action but there is a problem here.
Live Support says (10:26): Can you list all the addins from the Excel options page?
tmy1337 - Anonymous from the web says (10:28): Excelcalcs Add-in, Xlc, and Videosoft Flex Grid 7.0
Live Support says (10:28): I am thinking maybe another addin interferring with XLC I don't know Videosoft Flex Grid 7.0 but is this easy to uninstall and reinstall?
tmy1337 - Anonymous from the web says (10:29): no clue what it is i can just deactivete it
Live Support says (10:29): let me google it
tmy1337 - Anonymous from the web says (10:30): its a crack thing i think, but im on a student license
Live Support says (10:31): It looks a bit dodgy to me - I have see a lot of cracks, malware and russian brides on a google search Can you uninstall it?
tmy1337 - Anonymous from the web says (10:35): working on it :\
Live Support says (10:35): I hope this is the source of the problem.
tmy1337 - Anonymous from the web says (10:39): removed it and still got the same error
Live Support says (10:39): Doh
Live Support says (10:40): Would you try another XLC uninstall and reinstall for me?
tmy1337 - Anonymous from the web says (10:40): Run-time error 13 - type misstype yes no prob
tmy1337 - Anonymous from the web says (10:42): same thing after the reinstall
Live Support says (10:43): Ok Let me look into Run-time error 13 is it "type mimatch" not "type misstype"
tmy1337 - Anonymous from the web says (10:45): Run-time error 13 "type mismatch"
Live Support says (10:54): If I send the previous version og XLC could you uninstall the current one and reinstall this one. I would like to know if it is something new that has crept in with the latest version?
tmy1337 - Anonymous from the web says (10:57): oki I have sent it through to your registered email account
tmy1337 - Anonymous from the web says (11:00): no prob
tmy1337 - Anonymous from the web says (11:04): but i have to run to class now but thanks alot for all the help
JohnDoyle[Admin] 9 years ago
First of all let me reassure you that we'll do everything we can to get you up and running. We will and extend your subscription for the time you are down and if you are not satisfied we'll give you a full refund.
That said I don't think anyone has reported in a "Run-Time error 13" before. I have researched the subject and found some articles suggesting that un-installation and reinstallation usually solves the problem. This is easy enough so let's try this first.
You find the uninstall program from the start button>Programs>XLC>uninstall XLC. Then reinstall. Make sure excel is closed when you uninstall and reinstall. Use the live support button when you do this and I'll guide you through the process if you like.
tmy1337 9 years ago
Hi
I found a video on youtube this morning about your software and it looks amazing so i got the 3month subscription to try it out.
but when i start excel after XLC is installed i get an error when i try to type somthing.
"Run-time error 13" and XLC wont work?
any tips?
JohnDoyle[Admin] 9 years ago
Hi Josephjphs - to remove XLC is simply a matter of running the unistall program. You will find it under Programs>XLC>Uninstall XLC. XLC does not interfere with the spellcheck. I hope this solves your problem.
josephjphs 9 years ago
Hi
I have downloaded your trail-version 12/26/09 to see if I could make use of it in my application(Number-crunching)now Iam losing -conrtol my desk-top pc,I have
hp/Pavillion Media Center(m8120n) with windows/vista 32 home premium,Intel core 2
Quad Processr q6600 2.4 GHz 8mbL2,1066MHz FBS,3.0 GB pc2-5300 DDR2 Memory,enought
of these Stat's.
My question is would you Please out-line (how to remove this Add-in) form My Machine, I have try-so far the dis-Abling the Mircos(didn't work)Excel-optional,
windows -(control-Panel) to re-move the program,it is still there in my EXCEL-Add-In Menu (Effecting) any -key-stroke entered into EXCEL.
Please Help!!.PS Spelling stop working too.
Thank in Advance
Josephjphs
JohnDoyle[Admin] 10 years ago
Record of Live Support comments:
Hermandh - Anonymous from the web says (23:06): I am having problem with installing in the office m/c with windows 7 and office 2007. I would like try out the program at home on Windows XP and Office 2003. Can I down load with same username and e-mail at home
Live Support says (23:14): Hi Hermandh Yes no problem you can download as many times as you like
Live Support says (23:15): our license agreement allows a user to install on any machine he likes for his personal use.
hermandh 10 years ago
Hi John
I was able to register XLC.DLL using Regsrv32 by logging under administrative account. But it it would not still load XLC.DLL using the COM add-in option in Excel.
JohnDoyle[Admin] 10 years ago
I am struggling to find a machine with Windows 7, IE8 and Office 2007 set up. Can you reply regarding the "To solve the call to “DllregisterServer failed with error code 0×80004005″ error, run a Command Prompt as Administrator. Alternatively, you can disable User Access Control too, or login with Administrator account." Judging from the links in the previous post this appears to be the issue.
JohnDoyle[Admin] 10 years ago
Did you hit "Reply Topic" or "New Thread"?
"Reply Topic" should post your message at the bottom of the Forum page.
"New Thread" starts a new topic and will be placed at the top of the page.
hermandh 10 years ago
John
As you indicated
[i]I'll install it on a Windows 7 machine my self and let you know how I get on. Please bear with me.[/i]
You should try it a m/C with Windows 7 and IE8. Not only I am unable to load the toolbars I cant even read your responses to my postings in the forum.When I click your posting it goes back to the top level of the forum.
Thanks
JohnDoyle[Admin] 10 years ago
I have been looking into the error code 0x80004005 [url=http://www.mydigitallife.info/2007/07/25/the-call-to-dllregisterserver-failed-with-error-code-0x80004005-on-windows-vista/]here[/url], [url=http://www.vistax64.com/vista-installation-setup/33219-regsvr32-error-0x80004005.html]here[/url] and [url=http://forums.techarena.in/vista-setup-install/667662.htm]here[/url].
"To solve the call to “DllregisterServer failed with error code 0×80004005″ error, run a Command Prompt as Administrator. Alternatively, you can disable User Access Control too, or login with Administrator account." Maybe this is the problem?
JohnDoyle[Admin] 10 years ago
I'll install it on a Windows 7 machine my self and let you know how I get on. Please bear with me.
hermandh 10 years ago
Thanks John for the reply but the problem still remains.
When I register XLC.DLL using the command regsvr32 xlc.ddl, I get the following error message
The module "XLC.dLL" was loaded but the call to DllRegisterServer failed with error code 0x80004005.
I used the free Dependency Walker program on XLC.DLL and it gives the following error messages
Error: At least one module has an unresolved import due to a missing export function in an implicitly dependent module.
Warning: At least one module has an unresolved import due to a missing export function in a delay-load dependent module.
The two offending DLL programs are
IEFRAME.DLL
SHLWAPI.DLL
I think Microsoft may have disabled certain function calls in Windows 7 that were available in previous versions of the operating system. I have found it to be true in VBA applications.
JohnDoyle[Admin] 10 years ago
A couple of users have had the same problem too and they managed to resolve it by deleting their network user profile and creating a new one. You can read the thread [url=/forum/xlc-issues/solved-%11-installation-problem/6/6/#1808]here[/url].
Now I don't fully understand why this happens and without being at a particular machine it is difficult to interrogate the issue. I have a colleague who is far wiser than me on these issues and he will be happy to help you resolve the problem (see this [url=/forum/xlc-issues/xlc-is-not-working/]thread[/url]). Just let us know how you get on.
JohnDoyle[Admin] 10 years ago
Thank you for reporting this problem in. I have never used the Walker Dependency program so please forgive my ignorance.
Have you tried registering XLC.dll manually? Follow these instructions to register manually:
1) goto start button and select "run"
2) type in "cmd" this will get up a command prompt window.
3) navigate to the xlc install directory (use "cd" commands usually "cd C:\Program Files\XLC")
4) check using "dir" that two files are present XLC.dll and XLC.xll
5) register XLC.dll by typing "regsvr32 XLC.dll" into the command prompt window. - you should get a message saying you have succeeded in registering.
6) hopefully you can see the toolbar when you start Excel.
Would you report back and tell me any error messages you may encounter.
hermandh 10 years ago
I downloaded your free 30 day evaluation copy and registered it. When I installed in a computer running Windows7 and office 2007 COM add-in xlc.dll would not load. It cannot be forced to load as well. XLc.Xla is loaded and the calculation OVD(1)/UND(2) is giving 0.5.
I ran XLC.dll through Dependency Walker program. It flagged three DLL with issues.
IESHIMS.DLL was not found. I was able to fix it.
IEFRAME.DLL and SHLWAPI.DLL are other two dll's with issues. The error message is
Error: At least one module has an unresolved import due to a missing export function in an implicitly dependent module.
Warning: At least one module has an unresolved import due to a missing export function in a delay-load dependent module.
JohnDoyle[Admin] 10 years ago
I have asked a software expert, Craig Littlewood, to review my installation source code and he can't see a problem with it. However there are always particular environments (version of windows, user rights...etc.) which might give rise to a problem. The problem is that we cannot reproduce the error so we cannot solve it.
I think you have resolved your problem but if you still have the problem again in the future please let us know and Craig has offered to help you resolve it.
JohnDoyle[Admin] 10 years ago
The only installation problems I am currently are are of are discussed in [url=/forum/xlc-issues/solved-%11-installation-problem/#1798]this thread[/url]. The problem occurs when reinstalling XLC after it has been uninstalled. I have still yet to fully understand this problem but there is a work around by deleting your user profile and re-creating a new one. Looking at your details it seems that you have been an XLC Pro subscriber since 2009-02-11 so this is probably the problem. I'll make a renewed effort to get to the bottom of this.
However this is the first instance of an installation problem with Windows 7 so this might introduce something new. I'll have to install Windows 7 and check it out. This may take a little time.
victormchavez39 10 years ago
I have a new computer. The OS is Windows 7. Excel is 2007. I downloaded XLC but I don't see any change in the Ribbon. I tried to download some programs from the site but I am unable to do it. Help! Thanks'
merrill 10 years ago
Yes. The buttons work and the =OVD(1)/UND(2) works. It becomes 0.5. It apparently is working. I will keep playing with it, and maybe i will figure it out. :) I'll keep watching the tutorials, they really help.
Thank you.
JohnDoyle[Admin] 10 years ago
Strange... Do any of the buttons on the toolbar work?
Have you a high security setting and don't allow macros to run?
What happens when you type "=OVD(1)/UND(2)" into a cell?
merrill 10 years ago
[size=4]The XLC toolbar appears in Excel, so i know it is installed properly. I can't name cells or get the greek symbols to appear by typing vertical bar and appropriate letters. I have watched the beginners tutorial, so i think ive done whats right so far. Does anyone have any ideas on this? :blink: [/size]
tenswg 10 years ago
Thanks. That worked. When all else fails follow the instructions.
JohnDoyle[Admin] 10 years ago
All the instructions are here:
/frequently-asked-questions/excelcalcs-faqs/how-to-configure-xlc-in-the-xlc-pro-mode./
Common problems are that the release code email is in your junk email folder
or
You have entered your username incorrectly "Take care to copy and paste your username from the member login menu because it is case sensitive!"
Hope this helps. Let me know if you have any problems.
tenswg 10 years ago
How do I get rid of the " non commercial use" message. I have pro version. Pressing redraw equation button doesn`t work. [file name=sections.xls size=52736]/media/kunena/attachments/legacy/files/sections.xls[/file]
gfs_se 10 years ago
John,
Sorry it has taken so long to respond again. Last week the system administrator reluctantly dumped my user profile and then re-created it. I can now use XLC. Thanks for all of your help.
boudira 10 years ago
thenks
JohnDoyle[Admin] 10 years ago

Remember to double-click the video to view the video in full screen mode.
How to switch of the automatic equation redraw and naming features of XLC the addin for Excel.
JohnDoyle[Admin] 10 years ago

Remember to double-click the video to view the video in full screen mode.
How to make equations from tabular data with XLC the addin for Excel.
JohnDoyle[Admin] 10 years ago

Remember to double-click the video to view the video in full screen mode.
Part 2 - How to switch between algebraic equation display and numeric equation display with XLC the addin for Excel.
JohnDoyle[Admin] 10 years ago

Remember to double-click the video to view the video in full screen mode.
A quick guide around the new features in XLC v10_09 including making equations from tabular data, algebra/number equation toggle and easy switch of the XLC audomatic redraw features.
JohnDoyle[Admin] 10 years ago
I am waiting for a colleague of mine to take a look at the problem. Unfortunately his father has just died so I am not expecting him to get back to me very quickly. I'll be interested in any progress you make at your end.
gfs_se 10 years ago
I still have not been able to get the Add-Ins tab to appear on the ribbon. Someone is supposed to look into my profile early next week. In the mean time I have managed to get the install to work on a backup computer. It's inconvenient, but it works for now.
I also tried to uninstall and reinstall office without any success. I also went through the repair proceedure before re-installing. It did not help either.
I will let you know next week if the profile deletion has any effect.
JohnDoyle[Admin] 10 years ago
Keith Sharp has got back to me with some further details of how he cured his disappearing XLC toolbar on his 'Add-in' tab in Excel 2007's ribbon.
JohnDoyle[Admin] 10 years ago
I have had two previous problems where the XLC buttons did not appear in Excel 2007's ribbon 'Add-in' tab but both were resolved by the users themselves. Unfortunately I supported the other two cases by direct email and not in the forum but here are their final responses to the problem. The first one gives me a lead which I look into in greater detail:
gfs_se 10 years ago
I used the setup file as you suggested. I first shut down excel. I received no messages after clicking the verify button. I assume it did as it was intended. When i open excel I still do not get the Add-Ins tab.
gfs_se 10 years ago
Yes, it is showing XLC.dll in the location statement below the list box. In the list box it lists ExcelCals Add-In and it is checked.
JohnDoyle[Admin] 10 years ago
Just one other idea try running "XLC User Setup.exe" its one of the files in the XLC download. You need to use this if you log in under a different user profile to the administrator.
JohnDoyle[Admin] 10 years ago
That's a good sign it means that XLC.xll is installed and working. The second part of XLC is called XLC.dll - this produces the XLC toolbar in Excel 2003 and should appear on the 'Add-ins' tab in Excel 2007. This you say is installed as it is has a tick mark next to XLC.dll (Right click-> customize quick access toolbar -> Addins -> Manage 'Com Addins') - just double check for me that it is XLC.dll and not XLC.xll
gfs_se 10 years ago
The cell displays 0.5
JohnDoyle[Admin] 10 years ago
can you insert the following formula into a cell to check if Excel recognises XLC functions?
=OVD(1)/UND(2)
gfs_se 10 years ago
Hello John.
Basically nothing happened. I did not receive any kind of message, and the Add-Ins tab is still not displayed on the ribbon. I have followed thru some other posts that dealt with similar issues, and the other tests seem to work. I suspect that I did something that removed the tab, but Excel thinks that it has added it. Is there a way of having your program check to see if the tab exists, and if not, adding it back in?
JohnDoyle[Admin] 10 years ago
Move you mouse to the Excel Ribbon then Right click-> customize quick access toolbar -> Addins -> Manage 'Com Addins' -> Go. Then click Add -> Navigate to C:\Program Files\XLC\XLC.dll
and tell me what happens.
jonmsmith 10 years ago
Great addition to my Excel Spreadsheet program. Great for error detection and correction.
gfs_se 10 years ago
I have previously had XLC running, but disabled it because of some cell formatting problems when I was not using XLC. I just became a PRO user, but cannot get the ADD-In ribbon visible when in Excel. The ADD-Ins section shows XLC and I have it check marked. I am running Excel 2007. What do I need to do to get XLC up and running again.
JohnDoyle[Admin] 10 years ago
XLC is 'blocked'? - sounds like an Excel security issue - you must let macros to run in your Excel security settings. Let me know how you get on and welcome aboard.
Shep 10 years ago
Hi forum folks!
I'm new to XLC and got it installed but when I tried to put in a function or equation into xcel (2007 under add-ins) it says XLC is blocked, and I can't get it to work.
JohnDoyle[Admin] 10 years ago
It looks good to go. Please [url=/component/option,com_remository/func,fileinfo/id,374/]download XLC 07_09 build 02[/url].
Thanks again for this useful feedback.
JohnDoyle[Admin] 10 years ago
I have identified the errant code - some very peculiar behaviour in the equation renderer. I'll run some verification problems before I post up the corrected code.
JohnDoyle[Admin] 10 years ago
You are right Marty. I think you have found a bug. Sorry I did not pick up on your point quicker. I think it will be easy enough to correct. I'll let you know when it is implemented so you can update XLC. It might take a few days to implement so bear with me.
Thanks again for taking the time to report this in. It all helps to improve the quality of the software.
m4grem 10 years ago
Ok. I made EqnStyle=0 rather than =1 and that made the parenthesis show. So does the =1 not work? I'll just use =0, but would like =1 as it reads better.
thx,,,,marty
JohnDoyle[Admin] 10 years ago
Back from holiday I see thav I sent you special extended expiration version of XLC by email on 24 June 2009.
JohnDoyle[Admin] 10 years ago
Automatic equation redraw gives a tremendous productivity gain but if you decide to stop working with equations to work on a large spreadsheet full of data it will slow you down. It is easy to switch off - click on the ‘about XLC and settings’ which you find on the XLC toolbar and uncheck the 'automatic equation redraw' checkbox. This is covered here /help-and-tutorials/
JohnDoyle[Admin] 10 years ago
I have attached the document reworked showing the correct equation rendering. Generally I deleted your EQS() functions and re-entered them. All equations are rendered correctly. [file name=BTH_pinned_plate_reworked.xls size=229888]/media/kunena/attachments/legacy/files/BTH_pinned_plate_reworked.xls[/file]
JohnDoyle[Admin] 10 years ago
I have taken a quick look at this and I am struggling to reproduce the problem with XLC version 07_09 (the current version). Can you tell me which version of the XLC program you are using?
m4grem 10 years ago
John, uploaded "BTH pinned plate" to Strength/plates and attached. thx [file name=BTH_pinned_plate_xlc.xlsx size=178096]/media/kunena/attachments/legacy/files/BTH_pinned_plate_xlc.xlsx[/file]
obudho 10 years ago
Hi.
What could be the reason of my computer hanging up whenever I am using XLC.It is a good programme cept for this shich is realy slowing me down. can someone advice.
JohnDoyle[Admin] 10 years ago
This seems a little strange. If you send me the excel file I'll be able to debug the problem and get back to you. If you don't want to post the excel file in the forum please send it to my email address directly. Thanks for reporting this in.
JohnDoyle[Admin] 10 years ago
If you have XLC installed and configured in the XLC Pro mode you simply have to redraw all the equation graphics an the non commercial user tag will be removed.
m4grem 10 years ago
John, I keep seeing ending parenthesis missing in equations. Tried increasing size of "picture" and other possible fixes, but to no avail. Is there a way to correct this? thx [file name=BTH_1_pin_design.pdf size=116254]/media/kunena/attachments/legacy/files/BTH_1_pin_design.pdf[/file]
joris 10 years ago
Hello,
I got a subsription for 3 months and downloaded XLC and the excavator arm .xls to play with, I want to modify the file to fit a standard excavator boom.
I face however two issues :
I keep seeing "www.excelcalcs.com non commercial user" line in excavator arm.xls.
I get a warning the macro's won't run , because they do not have a user certificate.
Please advise, best regards,
Joris van Dijk
Clyde 10 years ago
I reinstalled XLC and all is well now.:unsure:
JohnDoyle[Admin] 10 years ago
Ace329 I am sorry to hear that you are having problems installing the XLC toolbar and I appreciate your support through your XLC Pro subscription. I will do everything I can to get you up and running and I will extend your membership period to account for any lost time.
Firstly let me reassure you that thousands of people are running XLC with Excel 2007 and I am sure we can get you going too. Let's start with a few questions:
1) do you have administrator rights on your machine?
2) Can you type the formula "=OVD(1)/UND(2)" into a cell without getting a #NAME error (this checks if XLC.xll is installed properly).
3) Now let's check the toolbar installation (that's XLC.dll). OK so you tell me it is successfully installed with the windows registry. In Excel 2007, click the Office button, choose Excel Options then select the Add Ins screen, choose Excel Add-Ins in the Manage input box and click Go. In the Add-Ins dialog, click the Browse button. This will open a familiar Open File dialog. Navigate to the folder in which you saved the XLC.dll file (generally C:/program files/XLC), select that file, and click Open. Let me know how you go on.
Ace329 10 years ago
I cannot view the toolbar. I have performed all of items i.e the ten steps in the text file. I installed xlc.dll and it verified registration. I also installed the xlc.xll. I use excel 2007. Please help. Can I be credited for days I cannot access the toolbar?
Clyde 10 years ago
Hi John,
Thanks for the quick response. I have tried all that you have mentioned. I have not tried to reinstall EXCEL yet. I will need to get our "administrator" to handle that, I suspect it's a Microsoft issue. I thought you may have come accross this in the past and had a quick fix. Still a great product, keep up the good work!
Best regards,
Clyde
JohnDoyle[Admin] 10 years ago
Actually Dave I am not quite sure what the current XLC Ed expiry date is it may be October 2009. I am away on holiday at the moment so its not easy for me to check. However I have a pretty vivid recollection that I sent you an email with a special version of XLC with a Jan 2010 expiration date. Could you check you email? If you can't find it I'll send it again when I return on August 10th. Is this OK?
JohnDoyle[Admin] 10 years ago
Hi Clyde. The “~#temp” sheet is used as scratch space and should not be seen by the user. I reckon a restart of Excel should sort you out. Failing that a restart of the machine. If this does not sort you out then I am perplexed and I'll look into it further. Let me know how you get on.
Clyde 10 years ago
Recently my computer's hard drive became corrupted in the OS area. I've had the drive replaced and retrieved my data. I installed XLC and I have strange results. Now when I "Show Equation" or "Redraw all equations", the “~#temp” sheet displays and I see the operations taking place. The “~#temp” sheet disappears, but this is indeed not the normal behavior that I am accustomed to. This is on both old and new spread sheets. And those with a lot of equations, it seems to be slow (maybe because of screen updating). Any ideas?
JohnDoyle[Admin] 10 years ago
Yes that's correct David.
JohnDoyle[Admin] 10 years ago
The missing icons are probably not missing but they sometime change between versions. Hover over the icon to see the icon tip and the online help will help you too. It's always best to use the latest version of the software too.
JohnDoyle[Admin] 10 years ago
Most functions tend to use anglular values in radians so I tend to define a variable in radians but also show in radians. I'm on holiday at the moment and i'll try to give you a more complete response when I am back on the 10 th august. Always use the latest version of XLC.
m4grem 10 years ago
I have equations with degrees and radians MS formula conversion. Is there a way to remove that from the drawn equation. I've seen posts on an Equation editor. Is that XLC? MS? Do I use that and where is it?
Just signed up with PRo and certain icons/options didn't show up after inputing the release code to make the demo work. Missed redraw equations, Save as native excel file, and Find a repository file. Do I need to reinstall XLC.
Great add-in to Excel and better $ than Mathcad.
thx,,, marty
DavidEkker 10 years ago
John,
I have buy-in from everyone on my end. We intend to install the educational version and hope to start using it this coming semester.
From our last email, you have extended XLC timeout for the latest version to 6 months, is that correct? In other words, if I get the most recent XLC Ed version, it will last through December?
Thanks,
David
Ver 10 years ago
Your graphic display routines are very easily understood by a novice user of excelcalc. Truly great guide
kailee 10 years ago
It's really usefull to maka any notations of the formulas,THANKS!
JohnDoyle[Admin] 10 years ago
I have been aware of this problem for a while 3350Craig. It occurs particularly when you cut and paste from one sheet to the next. I actually cured the problem a while ago and it should not happen for the latest version XLC 07_09 which I have just uploaded to the site. Thanks for reporting these errors in. Sometimes I am not aware of them.
I am sure that there is not a problem with the autodesk software.
3350Craig 10 years ago
This error has been occuring for a bit now. I can save by Ctrl S and shutdown, and then start up where I left off but it is annoying.
Not sure what the trigger is as it has occurred when doing different things.
NB Autodesk Vault program installation has installed Vault tools - not sure if this is significant.
Thanks for any insights into this
Regards,
Craig
Maury McClain 10 years ago
With help from the home team, this issue has been isolated to a rogue worksheet unrelated to XLC. I have moved the worksheet between Excel 2003 and Excel 2007 over the course of a month in building the file, which likely has created a compatibility related issue tied to Excel. Everything behaved normally when the equations were migrated to a new worksheet.
If you're like me, you hate to lose all of that hard work. Thanks for the quick response John. This is one great program.
Maury McClain
JohnDoyle[Admin] 10 years ago
No there is no limit to the number of equations you can have on a spreadsheet. I would be interested in seeing the spreadsheet so that I can take a look myself. I'll send an email to your registered email address so that you don't have to post it through the forum. I will respect your confidentiality should you choose to send it through.
Maury McClain 10 years ago
I have been building a worksheet from the XLC template and ran into a snag with the calculations redraw. At around 198 or 199 equations the Excel program started drawing the equations with missing characters, stopped numbering equations, or numbered them wrong, and blanked out many equations.
Is there a practical limit to the number of equations the worksheet can handle? I am planning to check the same worksheet on a different computer to see if this makes any difference. I am running the laterst version 4.09 and 2003 Excel.
Maury McC
JohnDoyle[Admin] 10 years ago
Hi David - I hope you are keeping up with your workload. It looks like we have an agreement in principle. I will extend the timeout period for XLC Ed from three to six months. The next version is due out at the end of June so I’ll set the timeout for that version at end of December. This ties in nicely with your semester. At the end of December the next version will be ready which will run until June the following year.
You can install the XLC Ed version on as many machines as you like. Students can download the exactly the same software for their own machines too. I would ask that each student registers with the site to access the site material it is part of the [url=/frequently-asked-questions/excelcalcs-faqs/excelcalcs-site-rules/]site rules[/url].
I picked up the impression that you thought that the contribution I requested was financial. That is not the impression I meant to give – I welcome any contribution in the form of calculation uploads and we reward users with XLC Pro subscriptions. I’m sure that some of your teaching material would be of interest to our users.
Best Regards
John
DavidEkker 10 years ago
John,
Thanks for the effort in your response and please excuse my tardy response. We are just finishing Final Exams week and starting the summer semester. We usually get 2 full weeks between semesters, but this year we only get one, so everything is a bit crazy.
I think your offer is most generous. If you are willing, I would like to try to target the upcoming Fall and Spring semesters as a trial. The Fall semester would require installing the software at the beginning of August, when we update the computers for the Fall, and the software would need to be good until the middle of December. We then make the Spring semester install between the middle of December and the first week of January. The software must be good until the third week in May. I would need the EXACT copy that the students would see for the Fall sometime this summer, say June 15, so I can show them some examples and, hopefully, turn them loose. I will provide feedback on how students absorb the material.
The XLC Time-Out would seem to be the best for the computer lab, if you would be gracious enough to work around our teaching schedule.
The EXCELCALCS Site license would appear, as you say, not to create a great barrier, but please note my next question:
Question 1: Would I be able to provide the exact version of the software that is loaded on our computers to the students so they can install it on their own computers? This is really only important if there is a change to the software. I could post it, or a link, on a college-only website that only students in my class have access to it. Would they need to download it on their own? I am open to suggestions and please excuse my lack of ignorance on how you would prefer to control your product. If you think the Site Access will not result in significant difficulty, then I am willing to give it a shot. Usually, the version doesn't matter once they get used to using it, but some will simply freeze if the buttons are in a different order, etc. Just remember that I have students with extremely diverse computer skills. Many have never downloaded and installed 3rd party software and this is their first EXCEL class.
Question 2: Our process is to load the software on a single machine, make an image of the hard drive, and then push the updated image to the rest of the computers in the lab. Will this be allowed with the XLC Time-out? It is a pain if we had to install it one-by-one to our ~150 machines!
The watermark is common with the saftware we already use, so it would not be a detriment at all.
I am willing to make a contribution, but am not able to make that kind of commitment at this moment. With the bad economy, we have record enrollment and the wisdom from above is to freeze hiring! Eventhough, historically, enrollment goes up in a down turn. So, we are all working 30-50% over time! What is the old saying, if you don't study history, you are doomed to repeat it?
Thanks,
David
MajorMagee 10 years ago
Two would give the most flexibility. That way you could keep the auto updating, but not have to use subscripts.
JohnDoyle[Admin] 10 years ago
Hi there MajorMagee - Once you change any setting using the 'About XLC and settings' button your preference is stored and the behaviour of XLC will not change unless you change the setting again. Or is the suggestion that there should be two program settings one for automatic subscripting and another for automatically redrawing equations?
MajorMagee 10 years ago
I think what he may be after is a way to switch on/off the name subscripting option so he doesn't have to remember.
JohnDoyle[Admin] 10 years ago
It is part of the 'Automatic Equation Redraw' functionality introduced with the latest update. It is easy to switch off - click on the ‘about XLC and settings’ which you find on the XLC toolbar and uncheck the 'automatic equation redraw' checkbox.
Most of the time I work with XLC and I find the functionality useful but if I start work on very large spreadsheets of tabular data - it can slow you down.
jpriley485 10 years ago
When entering variable names thus: "TL ="
the "L" is automatically subscripted. If the space after the "L" is omitted, subscripting does not happen.
To be honest, I don't know if I've loaded an add-in that causes it to happen, but I want to end the behavior.
Can anyone help?
JohnDoyle[Admin] 10 years ago
Moving forward from my previous post, you realise that we offer [url=/earn-your-subscription/]free XLC Pro subscriptions in return for contributions[/url]? One idea that has crossed my mind is that I could give you a [url=/frequently-asked-questions/excelcalcs-faqs/volume-discount-when-you-buy-a-corporate-coupon/]Corporate Coupon[/url] in exchange for posting calculations on ExcelCalcs. Perhaps we could find a way of collaborating to develop an area of the site? You could act as a local co-ordinator with your students? This idea can be extended to other educational establishments too.
JohnDoyle[Admin] 10 years ago
I work alone in a bit of a vacuum and I often don’t appreciate the organisational difficulties that larger establishments face. So first of all thank you David for taking the time and trouble to explain your difficulties using XLC Ed as a teaching tool.
I am keen to have as many students as possible using the software. The right balance has to be found between giving educational users as much functionality as possible and to making it attractive to commercial users to pay for the software. This balance has to be found without introducing too much administration. That said it is pretty easy for me to change the fulcrum of the balance by tweaking the software. I have listed the current XLC Ed restrictions and I am very interested in your view as to where to strike the balance.
1) XLC TIME-OUT - XLC Ed (1M) typically lasts for 3 months before it times out. The current version expires 28th June 2009 this date is hard wired into the code (only the XLC Pro release code can defuse the time-out feature). I don’t really have a problem extending this to 12 months say. I think this get around most of the difficulties you have described.
2) EXCELCALCS SITE ACCESS - The site subscription controls login access to the site. XLC Ed (1M) lasts for 1 month before it expires. You are required to take out a new subscription if you return after 1 month (but you can select an additional month on XLC ED (1M) indefinitely). This expiration should not be confused with XLC time-out previously mentioned. I don’t think this is a barrier for your students.
3) XLC WATERMARKS – The XLC Ed (1M) version will continue to display the “Non-commercial user” watermarks and hyperlinks to the ExcelCalcs site. I don’t think it is a barrier for educational use.
I’ll look forward to your comments.
DavidEkker 10 years ago
I teach Engineering Problem Solving with EXCEL.
I am really interested in using XLC as a means to make it easier for students to view complex equations in EXCEl spreadsheets. This includes relatively simple equations to statics, dynamics, and thermodynamics classes.
In its present form, I cannot use XLC in my classroom. The first and most desire limitation is that a month is just too short for the educational license. I teach EXCEL over an entire semester, which means the software would need to last at least 4 months to allow me to use it on my machines.
I need to put in my software request at least 2 weeks before a typical semester starts to allow my IT people to install the software. Once installed and tested (which I do on a single machine), we make an image and distribute it to the other computers.
The software would need to be installed on about 250 computers, which would require something like a site license. To install on each and every computer would be exceedingly time consuming at best. Also, I do not like updating and re-imaging in the middle of a semester since the computers are in use pretty much all the time. Also, I need to lock the version so that when I create teaching examples, they do not change too much. This is really important for students that mostly have never seen EXCEL, let alone 3rd Party Add-Ins.
This means I would need at least a 5 month license. The license would need to be timed to expire sometime after the end of the semester, not the middle of one.
Then, each student would need/want to download and install their own copy. I guess that they could update it every month or so, but, remember, these students are being exposed to EXCEL for the first time in most cases. It is better to keep a stable version until they have earned some confidence with it.
I also have the dubious pleasure of being the Administrator for various Educational Software packages. The software is controlled in two ways, the first is that I am given a site license, which allows me to install full professional versions on all of my school computers. There is an agreement between me and the software provider such as a MOA, so they can hang me if I violate it. The second way is that I send the faculty/students *.edu email addresses to a central facility and the students are sent either a unique download link or unique password access. You could place a time limit for expiration for updating additional downloads from the same email address, say one year, unless their email address is updated by me.
Bottom line, if you want me to use XLC in my classroom, you need to change the way it is offered. I would love to be able to offer it to my students. Once they learn it and can use it for a while, they may be willing to adopt it permanently. What you need to do to be successful with students is to give them time and opportunity to use the software at a low price or free. It may take them a few semesters to get use to it, depending on their class schedule. So, this is not a 30 day trial type of effort! My two CADD software vendors offer students 13 and 18 month student licenses for their $5000+ sofware. My numerical software providers offer free updates to the current student version for the first six months and then no upgrade support for the next 6 months or year, but the software still works. All four know that students do not adopt like commercial personnel do, they need more time and more opportunities. 30 day trial simply is not long enough.
Also, I need to be able to install on a large group of machines for 5 or so months with the expiration date not corresponding to the middle of a semester!
I would like to offer this up to the about 350 or so engineering students I interact each year, and convince my colleagues of its ease of use, but I need some flexibility in my ability to deliver the software. At present, it is simply TOO HARD!
Maybe we can arrange a test where the software has a longer latency period? The test could be conducted in the upcoming Fall semester, if we can work out the bugs.
Thanks for reading this.
David
P.S. I did not see a directly similar thread, if there was one, please excuse.
binhxd2 10 years ago
tytytytyt
blackcap 10 years ago
its good sheet
Mike.f.Webster 10 years ago
Up and running thanks :)
JohnDoyle[Admin] 10 years ago
Sorry a problem with a server upgrade. Downloads have not worked for the past six hours. It appears to be working fine now but please report in any weirdness. I'll continue making my own checks. Sorry about this.
Mike.f.Webster 10 years ago
I am in the same boat :S
bobday 10 years ago
I am trying to down load this software on my computer and it will not download. I have excell program. After I download and bring up excell there is not an icon XLC
could anyone help
bobfred1 10 years ago
Hi John
Thanks for the tips. After uninstalling I found I also had to go into the program files folder to remove two additional files that weren't automatically removed. After that installing the new files worked and now the program works again.
Thanks again, I'm using excelcals for my thesis and it is making everything a LOT easier to check!
JohnDoyle[Admin] 10 years ago
Hi bobfred1. It sounds like XLC 04_09 has not been installed properly. Here are a few checks to diagnose the problem:
1) Check what version you are running - Use the "About XLC and Settings" buttons on the XLC toolbar to see what version you are running. My copy says "Version 04_09 - XLC Ed expires on June 28th". By the way XLC Pro never expires.
2) Some systems (not all) require you to uninstall the old version of XLC prior to installing the latest version. The install instructions ask you to do this.
That should do it. Let me know if this resolves the problem.
bobfred1 10 years ago
Hi
My excelcalcs keeps telling me
"Your copy of the ExcelCalcs Add-in is old and you need a new copy. You'll be directed to www.excelcalcs.com website where you can download a new updated copy for free."
When I go to the website, login and download a new copy and install it I still get the same message. My subscription still has 55 days left on it. What's going on?
JohnDoyle[Admin] 10 years ago
I am very grateful for your feedback.
JohnDoyle[Admin] 10 years ago
Please find attached the latest installation instructions. You will need administrator rights on your PC to install XLC.
Please send me the repository links you need and I'll email to you directly. Please be quick I am about to leave work. [file name=Readme.txt size=2851]/media/kunena/attachments/legacy/files/Readme.txt[/file]
cruzcd 10 years ago
i dled and ran the "XLC user Setup.exe." file an nothing happened. I open excel and the toolbar does not show up. I cannot manually add the .dll file from this user login. So how can i get the toolbar?
I added your webstie to the trusted sites list in my IE options menu but still cannot dl the files i need. Do i still have to wait til my 24 hrs are up?
JohnDoyle[Admin] 10 years ago
With regard to your download limit of 2 - it should be 6. I am aware that internet explorer will double count downloads, which would restrict you to 3. Adding ExcelCalcs to your 'trusted content sites' will get you back to 6 downloads per day ([url=/frequently-asked-questions/excelcalcs-faqs/internet-explorer-may-double-count-downloads/]read more here[/url]).
JohnDoyle[Admin] 10 years ago
cruzcd unzip and run the attached file. The XLC setup.exe configures XLC for an administrator but the administrator needs to run "XLC User Setup.exe" to configure the program for a user. I think this could solve the problem. Let me know how you get on.
I have only recently become aware of this issue and it will be included in the next version of XLC which will be released before 30th March. [file name=XLC_User_Setup.zip size=265212]/media/kunena/attachments/legacy/files/XLC_User_Setup.zip[/file]
cruzcd 10 years ago
i logged into my system with an elevated access account and was able to install the xlc.dll file. but when i logged back into my normal user name and opened excel the toolbar still does not show up and is not even listed in the view-toolbars menu....where is it?
And i'm going to a lot of trouble just to get access to you weld section spreadsheets. but i accidentally reached my 2 per day limit yesterday and need the weld calcs today...can you get me access to the weld spread sheets? I've gone through a lot of trouble trying to use you program but still have not gotten what i need.
Thanks
cruzcd 10 years ago
No i do not have administration rights to my PC.
I got to the C:\program files\xlc directory using the cd command but cannot register the xlc.dll by using the "regsvr32 xlc.dll"
I get "access denied" when trying to do this.
JohnDoyle[Admin] 10 years ago
A couple of questions first.
Do you have administrator rights on your PC?
Do you generally install your own software of does a system administrator do this for you?
Step 3) Navigate to the XLC install directory (use "cd" commands) - enter "cd C:/Program Files/XLC"
Continue with the following steps and tell me exactly how the computer responds.
cruzcd 10 years ago
I'm trying to install this toolbar manually because the .exe file doesn't do it. I open the command prompt as stated by step 2 in the manual process but don't know how to navigate to the install directory using the "cd" commands. How do i get through steps 3-5?
I bought the 1 month XLCPro package.
JohnDoyle[Admin] 10 years ago
If you have had XLC installed previously you may have hidden the toolbar. On Excels Main Menus select View>Toolbars>XLC Tools.
Ade50 10 years ago
I mean where is the toolbar? I cannot find it.
muhouston 10 years ago
It seems very great work
JohnDoyle[Admin] 10 years ago
I am not sure what your question is. You can see XLC tools under the Add-in tab. What do you mean by no appearance?
Ade50 10 years ago
It is under Addins tab and box checked but no appearance.
JohnDoyle[Admin] 10 years ago
It can be found on the 2007 Ribbon under the 'Addins' tab.
Ade50 10 years ago
[b]Carlos wrote:[/b]
I too am having difficulty in seeing xlc toolbar. I am working on excel 2007. Any suggestions?
Ade50
Carlos 10 years ago
New Development:
After following the thread to make the toolbar show up and doing everything as instructed I gave up. Because nothing worked. However, it is there now - All I did was to check the VIEW menu, then TOOLBARS, and a listing of toolbars showed up. The ones checked are the ones showing. XLC Tools was not checked. So I just did and there it is now (Excel 2003)
Miguel 10 years ago
I've downloaded it, will come back after do some reviews.
FShahab 10 years ago
I've downloaded it, will come back after do some reviews. Thanks, fs
JohnDoyle[Admin] 10 years ago
The [url=http://support.microsoft.com/default.aspx/kb/920111]Microsoft support site says [/url] that the issue is resolved by installing the latest service pack for Excel. If the computer has Internet access, you can download and install the latest Office 2003 service pack from either the Microsoft Update Web site or the Office Update Web. Both sites will automatically prompt you to download and install the latest service pack.
JohnDoyle[Admin] 10 years ago
There should be no reason to manually install XLC you are better off running the setup.exe program. The manual installation method has helped some people on some operating systems install XLC without administrator privalidges.
With regard to your specific problem I refer you to http://support.microsoft.com/kb/914232
Sorry I can't be of more help.
mohdimran1982 10 years ago
:ohmy: Dear all,
Could anyone solve my problem that, while i'm registering XLC.dll manually i got the error message that server failed to call XLC.dll (error code: 0x80004005)
could anyone response immediately?
JohnDoyle[Admin] 10 years ago
No I managed to get another tiny tweek into the code so it became build 03. Build 02 only lasted a couple of hours. Please download and install build 03. Thanks again for your help.
helden5022 10 years ago
John ... it now shows 01_09 build 03 for the download. Was there something else changed after the 01_09 build 02 that you mentioned? Or was the build you were talking about? Thanks.
helden5022 10 years ago
Thanks. That is useful.
JohnDoyle[Admin] 10 years ago
The first parameter of an EQS() function is the cell reference whose formula is going to be displayed. Let’s say you have cell B2 with the formula “=2+56” and you want to show the equation the cell underneath. Simply go to cell B3 and type “=EQS(B2)” and press the redraw button. Notice that you don’t have to use the ‘Show Equation’ button on the XLC toolbar at all.
helden5022 10 years ago
Thanks John. And I admit, I am impressed by the quick fix on that bug.
With regards to the alignment, maybe in a future build allowing the alignment to be chosen would be a good improvement. Actually on one of the first examples I tried when using XLC was a spreadsheet where I had the variable equation (previously just typed in using normal Excel text) below the equation results. I quickly realized that the XLC calc shown equation was based on the contents created in the right adjacent cell, and I just moved that cell underneath the equation results, instead of on the side. Which did what I wanted, but when I showed the equation the left justification threw it off. In this instance if I was able to have the code cell for the shown equation centered, it would fit right under the results and not look "off".
And in that same circumstances, is there a way to have the "code cells" that give the shown equation instructions become visible. In my situation where I was moving them around, I lost track of where they were. Obviously like the left justification issue if someone doesn't move the "code cells" it isn't an issue, but again, maybe something to think about for the next upgrade version of the software.
Thanks again.
JohnDoyle[Admin] 10 years ago
I have uploaded [url=/repository/add%11ins/xlc-addin-for-ms-excel/]XLC version 01_09 build 02[/url] the border issue is resolved in this build.
JohnDoyle[Admin] 10 years ago
Thank you helden5022 for some very pertinent questions.
1) Horizontal alignment of equations - equations are aligned to the top left of the cell this is because equations generally show the formula of the cell to the left of the equation. I am not sure if I can see the benefit of aligning to the top centre of the cell. That said if you present a good reason why I’ll add some additional functionality to XLC. The [url=/xlc/xlc-help-and-tutorials/controlling-the-appearance-of-equations/]vertical alignment of equations[/url] described in the help was proposed by a user too.
2) Regarding the borders I think you have spotted a bug for us. I’ll look into this further and get back to you.
Thanks again for the comments.
helden5022 10 years ago
Hi, I am new to XLC, so sorry if these issues have been addressed, but I had a few questions about the display format for a shown equation.
1. When the equation is displayed it puts the shown equation to the left side of the cell. Is there a way to have the shown equation display in the center of the cell?
2. It appears that the cell which the shown equation is being displayed in dictates the formatting of the shown equation obviously. This is ok unless you have borders on the cell and then it tries to add borders to the shown equation which screws it all up, especially if you have an equation with OVD()/UND().
Thanks.
JohnDoyle[Admin] 10 years ago
mmm there is clearly some issue here to be solve. I had been following a line of enquiry under this [url=/option,com_kunena/Itemid,145/func,view/id,1369/catid,13/limit,6/limitstart,0/]forum topic[/url]. Here is a summary of the investigation
XLC works fine with Excel 2000 and you can save and open files fine.
[url=/media/kunena/attachments/legacy/files/Book2.xls]Book2.xls[/url] contains an equation graphic only and no XLC functions. This can be opened and closed in Excel 2000 so it is not a graphics compatibility issue.
XLC functions open and save fine.
XLC files are always saved native Excel file format. There is nothing special apart from the additional XLC functions.
I have concluded that this is not an XLC related problem.
Now I don't want to send you off on a wild goose chase but many non XLC people seem to have the same problem. See related discussions on:
[url=http://support.microsoft.com/kb/920111]Microsoft[/url]
[url=http://groups.google.com/group/spreadsheet-writeexcel/browse_thread/thread/6656856820b6f799/]Ozgrid forums[/url]
[url=http://groups.google.com/group/spreadsheet-writeexcel/browse_thread/thread/6656856820b6f799/]Google groups[/url]
dirkels 10 years ago
Hi
I am having the same error with Excel 2000. File error: data may have been lost.
Excel calc data.
9.08 (Ed)
File data
Started 12 August 2008
137 formulas
6 sheets
The data can be recovered in Excel 2003.
John: Does the problem existing in Pro edition?
Please advise if problem can be fixed for Excel 2000. Otherwise I will have to upgrade
ferna001 10 years ago
Is very usefull for checking and providing formulas for equations.
JohnDoyle[Admin] 11 years ago
Thanks burmie
The error message "File error: data may have been lost" is not generated by XLC but Excel so I don't know exactly why this error is raised.
Since you managed to open the file containing just an equation graphic in Excel 2000 I can conclude that there is no incompatibility in the way Excel stores graphics beteen the two versions. So this can be ruled out as a reason for the error. Apart from the equation graphics the only way in which an XLC generated spreadsheet is different to a normal spreadsheet is the inclusion of XLC functions like OVD(), UND() and EQS() although I do not see how these can bring about the problem.
We could try another test. There is a button on the XLC toolbar called "Delete XLC Functions" you could use this and see if the problem occurs when you have no XLC functions. Please return to let me know how you get along.
burmie 11 years ago
Hi John,
Yes I was able to open the file that you attached to your previous correspondence.
It's all a bit strange why some files I have edited at work with XCL graphics do not work when I load at home. Both work and home operate Excel 2000.
Graeme
JohnDoyle[Admin] 11 years ago
I don’t have a copy of Excel 2000 but maybe we could work on this together. The spreadsheet attached contains an equation graphic only – no XLC functions. Can you tell me if this can be seen when you open it in Excel 2000. Can you also confirm the following for me:
Does XLC work OK in Excel 2000?
You only have a problem with files made with XLC in Excel 2003 which give you the error when opened in Excel 2000? [file name=Book2.xls size=15360]/media/kunena/attachments/legacy/files/Book2.xls[/file]
burmie 11 years ago
Hi All,
Yes I am still having the same problem at home. Spreadsheets which open fine on the laptop and at work which have XLC formatting cannot be opened on my home desktop which is running Windows XP and Office 2000.
I initially thought it was to do with the internet but I have had the same problem with files copied to a USB stick. Not sure what the problem is and haven't had time to look into it.
Graeme
JohnDoyle[Admin] 11 years ago
Hi kpd let me reassure you that a file made XLC is saved as a normal Excel file (it just has some special functions and equation graphics) so if data is being lost somewhere it is nothing to do with XLC. If you want to send me a copy I'll gladly take a look at the file for you.
dirkels 11 years ago
File error: data may have been lost.
I am having the same problems with the latest release on Excel 2000. The file cannot be opened because Excel closes with : Microsoft Excel for Windows has encountered problem and needs to close.
This file has multiple sheets and over 140 formulas. I have started this file in previous version of Excel calcs.
I have tried in opening this file on another PC with Microsoft Excel 2003 SP3 and latest release of Excel calcs with no problem. It also open much faster than with Excel 2000.
Please help!
questio 11 years ago
Such a fabulous way to see the equations, and see where you make the mistakes! Thank YOU
JohnDoyle[Admin] 11 years ago
Yay! - well thanks for sticking this through. This is the first time I have come across this problem and it may come in helpful for other users in the future. Enjoy XLC! Let me know if I can be of any further help.
bootlegend 11 years ago
New development!
I wanted to check which service pack I had (turned out to be SP2) so I wen to Help>About Microsoft Excel.
I clicked Disabled Items and XLC Add-in was listed. It said it prevented Excel from operating properly.
So I enabled it again and I can see the tol bar now.
But I don't know what the problem was? I will have to make sure it is operating correctly.
Thanks!
JohnDoyle[Admin] 11 years ago
I am clutching at straws now but do you have full system administrator rights on your machine?
bootlegend 11 years ago
Yes it says laod at startup.
No I can't show the toolbar.
Thanks!
spanacia 11 years ago
Does the load behaviour say "load at startup" - as shown in the screenshot from my computer?
When you check it and without restarting Excel can you show the toolbar using the Excel main menu? (View>Toolbars>XLC Tools)
bootlegend 11 years ago
Okay, I went through that process and I see ExcelCalcs Add-in listed but it is not checked.
I can check it and restart, but no luck and when I open the Add-in box again it is still unchecked.
Any idead on that one?
JohnDoyle[Admin] 11 years ago
When you have your "com add-in" button on a tool bar you should be able to raise this form: [img size=381]/media/kunena/attachments/legacy/images/d2.png[/img]
As you can see on my machine Excel Can see two addins, XLC from ExcelCalcs and a google desktop addin. If you cannot see ExcelCalcs Addin you could use the add button to manually install it. Then I hope you can see the XLC toolbar - you may have to restart Excel. Let me know how you get on.
Normally people should not have to go through this tortuous process and I am still confused as to why you are in this situation bootlegend. Good luck.
JohnDoyle[Admin] 11 years ago
OK let's do a few tests
1) On the View menu, point to Toolbars, and then click Customize. [img size=395]/media/kunena/attachments/legacy/images/d1.png[/img]
2) Click the Commands tab.
3) Under Categories, click Tools.
4) Under Commands, click COM Add-Ins and drag your selection to the toolbar. This can be any toolbar of your choosing.
5) Click COM Add-Ins on the toolbar to see a list of the available add-ins in the COM Add-Ins dialog box. See the next post as to what to do with your new COM Add-Ins button.
bootlegend 11 years ago
The only reason I tried to manually install is because the toolbar didn't show up after I ran the installer.
I have tried uninstalling and reinstalling and still no luck.
Does the xlc.dll file need to be in a Microsoft Excel folder?
It is installed in Proram Files>XLC and I thought that should work.
Thanks for the help!
JohnDoyle[Admin] 11 years ago
mmm very weird. Not quite sure what to do here.
Why did you need to manually install in the first place? Have you tried uninstalling XLC and reinstalling it with the setup.exe file?
bootlegend 11 years ago
Thanks for the reply. I have checked the toolbar menu but XLC is not listed.
The computer responds with a dialog box titled RegSvr32 that states:
"DllRegisterServer in xlc.dll succeeded."
I had an older version of XLC that worked, but I only used it occasionally.
Last year I tried to use the new version and that is when the problems started.
I have unistalled XLC before downloading the new version. I did notice that the uninstall utility leaves the XLC in the Program Files directory, so I even deleted that manually.
I hope someone can help me out. I would like to try the program again.
Thanks for the help!
JohnDoyle[Admin] 11 years ago
If you are sure the Dll registered then the only other thing I can suggest is to check View>Toolbars>XLC Tools. If the XLC Tools is not listed then the Dll is not properly registered.
When you type "regsvr32 XLC.dll" at the command prompt could you tell me the exact message the computer responds with?
bootlegend 11 years ago
Hello,
I am having the same problem. I have done the manual installation, and I get the succesful registration message but the toolbar will not show up.
Has anyone figured this out?
I am using Excel 2003 and Windows XP.
Thanks!
JohnDoyle[Admin] 11 years ago
If statements can be troublesome I agree but if you want to present the logic of your calculation I think it is worth considering placing each conditional check in to a separate cell rather than one long IF statement(see below):
[img size=265]/media/kunena/attachments/legacy/images/ifstatement.png[/img]
By the way I have named variables Cond1 and Cond2 so that the first four terms are un-subscripted. This is achieved by removing the " " character before the "=" character in the naming cell ([url=/xlc/xlc-help-and-tutorials/name-equations/]see help for more details on this[/url] look under the flash tutorial under the heading ADVANCED).
I hope you find this advice useful.
jwt 11 years ago
I wonder if you have any suggestions on how to manage if statements. In the past I’ve used them a lot, but the equations will likely get too long when converted by XLC.
I agree with a lot of the comments in the Forum, it would be really nice if there was a way to allow for several letters in a cell name before subscripting, like RLmax.
JohnDoyle[Admin] 11 years ago
I have noticed this happen occasionally too but when I open the file I have found that nothing has been lost. This problem has been previously raised in the forum ([url=/forum/xlc-issues/re%3afile-error-%3a-while-opening/]read here[/url]). Whilst being annoying I think this error message can be safely ignored. I think it may have to do with a glitch in the download software but I don't think it is serious.
It sounds like your case is a bit more serious if you suspect the file is missing elements of the calculation. It would be useful if you could send me a link to the file that has given you this problem and I'll take a look into it. I certainly can't see any reason for XLC content to be lost (maybe it never had any XLC content in the first place).
Thank you for reporting this in. The site is so large now I rely on users telling me when they have problems so I can't correct these types of glitches.
johanhand 11 years ago
It's really usefull to maka any notations of the formulas,
burmie 11 years ago
I have a desk top and old laptop at home. Often I work with both, hence I have XLC on both.
Lately I have noticed that I get the message [b]File Error: data may have been l[/b]ost when I open a file that I have saved on the laptop and copied to the desk top to use. The file opens but has lost all the XLC input.
Has anyone experienced this problem?
ngan 11 years ago
Thanks
fwiseputra 11 years ago
I am hooked with excelcalcs, thanks
dirkels 11 years ago
This very usefull tool when you have 89 plus formulas in spreadsheet to check!
JohnDoyle[Admin] 11 years ago
Try copying the "·" character from here in the forum (i.e. this html page) and paste into XLC settings form.
JohnDoyle[Admin] 11 years ago
You had me worried for a couple of minutes John until I re-rendered the equations using my copy of XLC and it worked fine. So why is it fine for me and not for you? I think it is because of the multiplication character you have set using the XLC toolbar's "about XLC and settings" button. I have "·" as a multiplication character and not sure what you have set.
I am guessing you have a " " character. A " " character may screw up the rendering algorithm. Or maybe you have two characters set? Any character like "·" or "x" or "*" will work fine. [img size=410]/media/kunena/attachments/legacy/images/iy1.png[/img]
jpriley485 11 years ago
From MSWord I found a symbol that looked like the elevated period. Tried to cut and paste it into the multiplication box, but nothing appeared.
JohnDoyle[Admin] 11 years ago
What happens when you copy the "·" character into the multiplication character box?
jpriley485 11 years ago
I tried your instructions, must be doing it wrong. Finally, I decided on the "*" symbol. Just as well.
jpriley485 11 years ago
LOL, sorry . . . here it is.
I must have tried to upload the file as an image in the previous post. [file name=Box_Beams___XLC.xls size=75776]/media/kunena/attachments/legacy/files/Box_Beams___XLC.xls[/file]
jpriley485 11 years ago
The PDF file could not be uploaded, so here's the Excel file.
See next post.
jpriley485 11 years ago
Best way to describe the problem is by attaching a printout (see attached).
The "working" equations for Ix and Iy are not displayed correctly.
I can send the Excel file if you'd like.
Skip to final post.
JohnDoyle[Admin] 11 years ago
I don't think it is on many keyboards but there is a keyboard short cut code in MS Word:
type "2219" then "alt" then "x" and "·" should appear.
Its not often used I guess.
jpriley485 11 years ago
On my keyboard, ">" is above the "."
JohnDoyle[Admin] 11 years ago
It may not be on your keyboard John but you can copy this "·" character is sits above the "." character.
JohnDoyle[Admin] 11 years ago
When you use the "about XLC and setting" button you set the default [url=/xlc/xlc-help-and-tutorials/controlling-the-appearance-of-equations/]equation control string settings[/url]. By setting the default Equation prefix to "" this means that future equations will have no Equation prefix. But the equation prefix of existing equations is set by the equation control string.
It is easy to change all existing equations too using find and replace commands:
Find: EqnPrefix=Eqn.
Replace:EqnPrefix=
Then redraw all worksheet equations to update the equation graphics. I hope it makes sense. Check out the link to the help files this will be instructive too.
jpriley485 11 years ago
A blank or nil "Equation Number Prefix" has been entered on the "about XLC ... " screen, but equation numbers remain, even after "redraw all worksheet equations" has been implemented.
I tried entering a blank space, but that didn't seem to work either.
jpriley485 11 years ago
I wanted to see what equations would look like with an "x" multiplication symbol.
Of course, since we commonly use "x" as a variable, it isn't acceptable.
So I must set the symbol back to its default.
The problem is, I can't figure out what the default symbol was . . . certainly not a ".", but rather a raised period.
If it's on my keyboard, I sure can't find it.
Can anyone help?
Carl A 11 years ago
I tried three times to download this again and the connection to the
server is lost when the download reaches 175-176 KB. I suspect this is
due to I'm using dial up 56K. Doesn't work even using Free Download Manager.
(No high speed available in the sticks)
JohnDoyle[Admin] 11 years ago
I have checked the download on two separate machine and both times I successfully downloaded and installed the software. I think that you have some problem with your internet connection. I am sorry I cannot be of any more help.
luizel 11 years ago
The XLC download don´t complete. What is goin on? I have tried up four times and it terminate without the file complete - only 293 Kb.
I would like to test XLC, but it seems impossible...
(sorry my english...)
Luiz Eduardo Lourençoni
Brazil
JohnDoyle[Admin] 11 years ago
We seem to get this issue raising its head from time to time. The solution that seems to work for everybody is to simply download again. I think it must be some kind of connection issue. Let me reassure you that many people have installed XLC successfully today. Please let me know if this resolves the problem for you.
excelcalcs79 11 years ago
I get this error message when I try to unzip the XLC File. Any suggestions?
! C:\Program Files (x86)\XLC 03_08 Installation.zip: The archive is either in unknown format or damaged
! Cannot execute "C:\...\setup.exe"
Thanks
JohnDoyle[Admin] 11 years ago
You can convert any calculation so that it is readable by Open Office's Calc program of course.
1) In Excel Use the "Delete XLC Functions" button on the toolbar.
2) Same as XLS document.
3) Close Excel.
4) Open Calc
5) Open the XLS document you have just created.
6) The calculation functions perfectly well in Calc but you cannot redraw any equations.
If I had more time I would like to develop an Open Office Add-in too but I don't know how I will find the time.
JohnDoyle[Admin] 11 years ago
No toolbar means xlc.dll is not installed properly (Part 1 of the manual installation process).
Do you have installation rights on your machine - are you an administrator?
If you have the please tell me what response you get to item 5 of the manual installtion procedure i.e.
PART 1 - XLC.dll
================
Follow these instructions to register maually:
1) goto start button and select "run"
2) type in "cmd" this will get up a command prompt window.
3) Navigate to the xlc install directory (use "cd" commands)
4) check using "dir" that two files are present XLC.dll and XLC.xll
[b]5) Register XLC.dll by typing "regsvr32 XLC.dll" into the command prompt window. - you should get a message saying you have succeeded in registering.[/b]
6) Hopefully you can see the toolbar when you start Excel.
This should tell you what your problem is.
johobo 11 years ago
I'm also having trouble installing the toolbar. I have installed it using the setup file as well as manually. The XLC check box is present when I go to TOOL\ADD-INS, but selecting it does not activate the tool bar.
Does anyone know how to solve this?
josepajelani 11 years ago
Try to find the readme.txt file:
"The easy way to install XLC is simply to run the "XLC setup.exe". When you next start MS Excel you will see the XLC toolbar. For a quick start go to the on-line help tutorials and you'll be displaying mathematical equations in Excel in less than 10 minutes. You might also like to use the Calculation template file 'XLC CalcSheet.XLT'.
The harder way is for those users who are not given software installation rights at work which prevents them running installation programs like "XLC setup.exe". It may be possible to follow the manual installation method outlined below.
There are two files Excel needs to have installed separately 1)XLC.dll (this is the toolbar component) and 2)XLC.xll (this contains special XLC functions).
PART 1 - XLC.dll
================
Follow these instructions to register maually:
1) goto start button and select "run"
2) type in "cmd" this will get up a command prompt window.
3) Navigate to the xlc install directory (use "cd" commands)
4) check using "dir" that two files are present XLC.dll and XLC.xll
5) Register XLC.dll by typing "regsvr32 XLC.dll" into the command prompt window. - you should get a message saying you have succeeded in registering.
6) Hopefully you can see the toolbar when you start Excel.
PART 2 - XLC.xll
================
7) In Excel go to Tools>Add-Ins... This displays the Add-ins form.
8) From the add-ins form select the browse button and navigate to your XLC installation directory (normally this is C:Program FilesXLC unless you installed it elsewhere). Select the xlc.xll and press 'OK'. This has manually installed xlc.xll
9) Close Excel and restart it again.
0davids0 11 years ago
Hallo everyone,
My name is David and i've made the download from this program, because i work in project, electric projects, and i ussualy need to do some calculs and this program is fantastic. I have one problem... I cant´t find de xlc toolbar.
How can i make it possible? Need some help.
Thanks
PS:
I don,t know if is necessary to make an apresentation of my self.
Excuse my english. Is not very good.
JohnDoyle[Admin] 11 years ago
Yes you can format equation names anyway you like please refer to /xlc/xlc-help-and-tutorials/name-equations/ - Under the flash video there is a section entitled "ADVANCED" - your answer lies there.
wellington 11 years ago
Hi,
I am new in XLC, I just wanted to convert some of my previous excel files to proper format with this tool.
I had problem with variable with more than one alphabet like DAF (Dynamic Amplitude Factor)
For example when I use equation name on a cell with “DAF” is convert to DAF which "AF" become Subscript but I do not want to change to this format and like appear normal as "DAF"
is there any solution for this
Regards
A
JohnDoyle[Admin] 11 years ago
Well done mguter you have found a bug for me. I have managed to fix the problem and I'll include it in the next release of XLC. It may be a few weeks before I can manage to get it out - I am just back from my summer break with a mountain of work to clear. Please bear with me and thanks again for reporting in the problem.
saminania 11 years ago
Thanks,it is very useful.
mguter 11 years ago
I think I figured it out.
The line representation depends on Autoshape Defaults Settnig.
Here is the new one: when there are two or more radicals with OVD/UND in the equation, they loose part of the sign (except the last one) - see attached file. [file name=SQRT_missing_line.xls size=22016]/media/kunena/attachments/legacy/files/SQRT_missing_line.xls[/file]
JohnDoyle[Admin] 11 years ago
XLC does not support nested parentheses. XLC intends to render Excel formulae in a mathematical form. In this case the upper and lower limits would be represented as arguments of a function. The Equation editor could be used to write your formula in the manner you describe.
JohnDoyle[Admin] 11 years ago
I am afraid not Audie.
JohnDoyle[Admin] 11 years ago
I am back in the office on August 11th - I'll get back to you then when I can investigate this fully.
Xanklup 11 years ago
I am new to XLC and need help.
How do I use nested parentheses? If I use OVD and UND, I get something not very pretty!
How can I depict summation with the lower and upper limits?
Audie 11 years ago
Can XLC be used in conjunction with the "Open Office" Spreadsheet programme
mguter 11 years ago
I am resending the file. I am not sure if my previous post went through. [file name=OVD.xls size=340480]/media/kunena/attachments/legacy/files/OVD.xls[/file]
JohnDoyle[Admin] 11 years ago
You have to attach a spreadsheet showing the problem so I can investigate.
mguter 11 years ago
Division line does not display in the formula with OVD()/UND() or displayed as an arrow. What do I do wrong?
JohnDoyle[Admin] 11 years ago
The manual installation seems to work on some machines. I would advise letting your administrator know what you have done though. Welcome on bard Ben.
JohnDoyle[Admin] 11 years ago
I am not sure what is going wrong here breeses. I have checked the download myself and it worked fine. Could you try again on a different machine?
bbrampton 11 years ago
I followed the manual installation instructions in the readme.txt and it worked. Great!
breeses 11 years ago
Tried to dwonload the latest version of XLC onto my laptop and got a file named "no_html,1". Needless to say it was not a zip file. What am i doing wrong here? Tried it twice, once not logged in an second time logged in. Same file both times.
bbrampton 11 years ago
Hi there,
I would like to install XLC but don't have administrator rights. Is there a way I can install with only user rights?
Many thanks,
Ben
JohnDoyle[Admin] 11 years ago
Nidhee, This is strange because I downloaded all the file and did not get the "File Error : Data May be Lost" message on any of them. I know that I have seen the error in the past however. Without being able to reproduce the error I can't investigate the problem. In nay case, as I said in my previous post, I think in any case this error message can be safely ignored.
Nidhee19 11 years ago
Hi,
Here are the links,
/repository/Machines/Welds/Fatigue-Damage-in-Steel-Welds.xls/
/repository/Machines/Welds/EC3-Fatigue-Damage-in-Steel-Welds.xls/
/repository/Strength/Materials/Material-non-linearities-S304L-V0001.xls/
/repository/Strength/Materials/True-Stress-True-Strain.xls/
Thanks,
Nidhee
JohnDoyle[Admin] 11 years ago
Nidhee I can't find the download you are referring to but I have noticed the same error appearing myself on occasions. The file error is nothing to do with your version of Windows, MS Office, MS Excel or XLC I think it is an issue with how files are stored in the ExcelCalcs Repository but I do not know why it appears.
I would like to reassure you that when I have had this error message the calculation has behaved perfectly normally. I have managed to save the file locally and upload to the site again and then the error message does not reappear. It would be useful if you could send me a link to the file that has given you this problem and I'll take a look into it.
Thank you for reporting this in. The site is so large now I rely on users telling me when they have problems so I can't correct these types of glitches.
Nidhee19 11 years ago
Hi,
I am facing a problem with some of the Files
e.g. Welds - Fatigue / Non Linear Material properies curves
While I open these file, I get an error message of
[b]File Error : Data May be Lost[/b]. After OK click file can be opened but No Images / Graphs. This happens with WinXP / MSOffice2000 / Latest XLC version.
The same files can be opened in MS2007, is this something to do with MS Office version ? Many other files can be open without any problem on MSOffice 2000.
Please help !
Thanks,
Nidhee
megamaxx 11 years ago
Oh i see! Ok i'll try that in my formula again. Thanks big help! ;-)
JohnDoyle[Admin] 11 years ago
moises I think that their is a " " character in the formula which is causing the problem. Your cell formula reads:
=IF(D10D14, (23600/D10)*6.895, ERROR)))
If you change this to:
=IF(D10D14, (23600/D10)*6.895, ERROR)))
Notice the " " character remove in front of "D10 Now your equation will be rendered correctly.
I'll be able to fix this bug in a future release but if you could use this work around for now.
Thanks for reporting this in. I really rely on user feedback to notice these bugs so that I can improve the product in the future.
megamaxx 11 years ago
Got it sir!
here is the file! at last i was able to attach it! ;-)
[b]JohnDoyle wrote:[/b] [file name=Box_Sections.xls size=28672]/media/kunena/attachments/legacy/files/Box_Sections.xls[/file]
JohnDoyle[Admin] 11 years ago
File attachments seems to be working OK moises. I am looking forward to receiving your attachment.
JohnDoyle[Admin] 11 years ago
I am just checking the file attachments work in the forum. [file name=test_attachment.xls size=13824]/media/kunena/attachments/legacy/files/test_attachment.xls[/file]
megamaxx 11 years ago
Hi there! I was making an excel template for calculations of allowable stress for aluminum frames.when I took a look at the rendered XLC formula.. there was a slight error in it. kindly look at the attached file.
"d10" is supposed to be "S".
i know that this is just a slight issue, but nonetheless i am giving my comment to further improve d XLC program.
thanks and more power to you and to XLC!
-moises villar-
civil engineer
-sori i cant seem to attach the xls file. ill repeat my post tomorrow.. my apologies :(
ttruter 11 years ago
excellent
rcast 11 years ago
Thanks, I am trying XLC right now
JohnDoyle[Admin] 11 years ago
It's done already. Please see the bottom paragraphs under the flash tutorial.
/xlc/xlc-help-and-tutorials/name-equations/
I hope that you like the software.
ptonkin 11 years ago
Hi,
I am a new user evaluating XLC for possible use by our design team.
1 possible enhancement I am interested in is to change from the default format that shows the 1st character as normal, with all subsequent characters subscripted.
I would like the option to have 1 or more characters normal, with all subsequent ones subscripted.
Can this be done today?
Are there any plans to make this available in the future?
Regards,
Phil.
ptonkin 11 years ago
Hi John,
I have just started to evaluate XLC for potential use by 20+ designers in our company.
Yes, we have corporate policies which prevent individuals installing software, and having out IT dept install updates every 3 months will probably kill the project.
We would pay for a version that was a 1-time installation (preferably networked, rather than on individual machines), or where upgrades are seamless with minimal interaction by the user.
Phil.
megamaxx 11 years ago
ok, thanks, will do wait for that information. :)
JohnDoyle[Admin] 11 years ago
I am putting a plan together and I'll survey user opinion so I'll get back to you on this.
megamaxx 11 years ago
how much would the non-expiring XLC be?:unsure:
BahirDar 11 years ago
Here is my spreadsheet.
Thanks for your help. [file name=PSBeam_Miscelaneous_Calcs.xls size=57344]/media/kunena/attachments/legacy/files/PSBeam_Miscelaneous_Calcs.xls[/file]
JohnDoyle[Admin] 11 years ago
Seems weird - can you attach the spreadsheet so I can take a look?
BahirDar 11 years ago
My apologies - I should have tested more and explained it better before posting.
OK - I have one spreadsheet with multiple worksheets.
Sheet1 - where the function "Select all shapes on worksheet" works
Sheet2 where the function does not work.
I created a brand new spreadsheet with a couple of formulas. The "Select all shapes on worksheet" function works.
I copied (edit - select all - copy) the data from the worksheet where the function does not work and pasted it into the brand new spreadsheet. I applied the show equation then the formula shows. However the select shapes does not work on it either.
The only thing that worked for me was copying the items row by row and pasting it into a brand new worksheet.
I wonder if anybody else had similar issues.
Thanks,
JohnDoyle[Admin] 11 years ago
That seems strange BahirDar it works fine on my version. I have checked in a second machine too and it still seems fine. Can you check again? First of all there needs to be some graphical objects on the page (lines textboxes, xlc equation). Press the 'select all shapes on work sheet button' and they should all be selected.
BahirDar 11 years ago
I updated to the new version. I have the 03.08 version with "expires on 9/27" as stated in your reply. However, now the "Select all shapes on worksheet button" does not seem to work.
Thanks for the great work you are doing you and an excellent tool.
JohnDoyle[Admin] 11 years ago
I have taken quite a few emails too explaining how inconvenient the XLC expiration is for large companies. If I could ask you to put up with it for just one more time and I will bring out a commercial non-expiry version before the next expiry date on 27th September 2008.
The main reason for expiration is to force everyone to run the latest version. XLC has changed much over the last year since its launch. Bugs have been ironed out and functionality improved. However I have not had a bug report for a long time now and the product is robust and bug free so maybe the time is right to release a non expiry version.
This is my first web site and I have learned a lot about how they work. Originally the concept was a kind of Math Wikipedia with everyone contributing but if I am honest apart from some notable exceptions I am underwhelmed at the few calculations that users upload. New calculations keeps the site alive and buzzing so I want to encourage calculations in other ways.
In addition users rarely use the the Amazon links and thus far I have received one cheque from for $100 from Amazon.com and none at all from the other Amazon domains. I am grateful for about 10 donations amounting to about $200. Google ads bring in about $50 per month but I have been unsuccessful in getting any paid sponsors for the site. So financially its a spectacular flop. That said I am pleased with the 26000 unique visitors per month and the popularity of the XLC and I think there is a sound base to develop. My prime motivation has not been financial but I think that funds will help to develop the site and site content.
My current thoughts are for a free XLC version for educational use only and a commercial use version of XLC for users who pay an annual subscription (XLC pro). XLC will not expire but a release code on the 'about XLC' form will set it to XLC free or XLC pro. I will also offer free annual XLC pro subscriptions to users who donate good calculations. I have some work to do to implement this so please bear with me.
Andrew1111 11 years ago
Hi John,
I have come to rely on this software for a number of calculations, and it has a happy knack of expiring right when a calculation needs to get out the door! Working in a large company, the process for me to re-install is complicated and drawn out, times that by about 6 engineers using it in this office, you can see how the inconvenience can hurt us. Essentially it costs money every time we need the re-install.
In fact I have been online looking for an alternative that we can purchase to avoid the problem, however one has not presented.
So consider us your first customers for a licensed version.
neyulu 11 years ago
good
JohnDoyle[Admin] 11 years ago
Sorry to hear you are having trouble again Ernie. I have checked the download and everything is fine for me. There is a thread in the forum which shows that zip files may not download because it detects the presence of a *.exe. I don't know if this might be your problem but it is work investigating. It seems there is some help on the Winzip site. I don't think that there is any more I can do.
[url=/option,com_kunena/func,view/Itemid,145/catid,13/id,1062/]Read the thread and Donm's remarks here.[/url]I hope it works for you.
ehcet 11 years ago
This is the tird time. XCL downloads the first 56KB then quit. Wont install.
Tried on my laptop, same result, tried on office computer with high speed connection, same result.
Please advise.
Thanks
Ernie
JohnDoyle[Admin] 11 years ago
Because I am the administrator of my own machine and I am not part of a large company I tend to not fully appreciate upgrade implications of the software. You are not the first person to raise this issue with me.
I have been considering an XLC pro version of the software which would not require upgrading. I have been thinking about making this available to users on a paid subscription basis. This revenue could fuel site development. I need think this issue through properly and I will consult with users for their opinions. These are ideas only at this stage and I need to fully think through the implications. I always intend to make a free version available but possibly on an education only license.
I would be interested in your opinion.
Cheers
John
ingle 11 years ago
John,
I posted the following message on the XLC forum:
"My work computer requires admin rights to install software. Installing the software manually is against company rules and therefore not an option. However, my IT department will evaluate the software and release it if no problems are encountered during testing. This evaluation takes approximately 2 months. The problem is that each new version will require me to go through the approval process. Is there any other options?"
The IT department has informed me that the 60-90 day expiration limit is unacceptable due to the man power required to test the application. I really like the software. Is there a chance that policy can be changed?
philstunell 11 years ago
John,
Thanks for the advice.
Perhaps the on-screen message could say 'uninstall your existing copy and download the current edition' or something similar?
Phil
JohnDoyle[Admin] 11 years ago
XLC is regularly improved and we want all our users to benefit from them, so old versions die and new versions can be downloaded. It simplifies support issues and it also offers some protection from piracy. Many of you will be running XLC version 03_08 build 03 which will die on 30th May 2008. You can download build 04 which will extend XLC life until 27th Sept 2008. Apologies if this causes any inconvenience. 1)Download XLC version 03_08 build 04. 2)Close Excel. 3)Goto the Start>All Programs>XLC>Uninstall XLC and then run the new setup file in the XLC version 03_08 build 04 zip download. 4)Start Excel. 5)On the XLC toolbar select the ‘About XLC and settings’ button (it’s the last one on the bar) to check the new expiry date of 27th Sept 2008.
Please note that when XLC expires only the ability of XLC to redraw equations will cease to work. Those equations already drawn remain as graphic objects and all Excel functions (including XLC functions) continue to work. There is never a danger of not being able to use your excel file or loosing time you have invested in developing a spreadsheet.
philstunell 11 years ago
When attempting to use Xcalc functions I now get a message saying
"your copy of Xcalc add-ins is old - you need a new copy" with a link to this site.
Although I have downloaded and re-installed the software from this site - the add-inns are still not working and the same message appears.
Anybody the solution to this problem
Phil
megamaxx 11 years ago
Wow tnx for answering this question sir! I was about to ask the same question about the line above the 'radicand'. Big help!
-Maxx
[b]JohnDoyle wrote:[/b]
megamaxx 11 years ago
very good add in! good job!
JohnDoyle[Admin] 11 years ago
123excel you need to first uninstall. Then install the new version.
If for some reason that does not work simply copy and replace XLC.dll from version 03_08 zip file and replace the one in your XLC installation directory.
donm 11 years ago
Thank you for the new zip file of XLC. My problem is with Windows XP blocking the .exe setup file. It does not completely download this file from your site and it would not unzip this file from your e-mail. I finally found out how to unblock it from the Winzip site and have now successfully installed the new program.
DonM
123excel 11 years ago
I have downloaded the XLC file and loaded it a number of times and continue to receive the message that my file is old and needs to be replaced.
Thanks,
Brandtw 11 years ago
I actually went through that entire process yesterday and got the success window pop-up, but it still wasn't working. I tried the exact same thing today and it worked. Thank you so much for getting back to me. This will make my senior project much easier. I have told a bunch of other engineering students about this program, so let hope that it becomes huge! Thanks again!
JohnDoyle[Admin] 11 years ago
Brandtw it sounds like you have done everything I would suggest. It appears that XLC.xll is installed correctly (because this appears in the add ins list) but XLC.dll is not installed correctly (because you can't see the XLC toolbar and it is not listed in the View>Toolbars list).
Can you check that XLC.dll is shown in your XLC install directory.
If it is then make sure it is registered (i.e. part 5 below tells you XLC is registered).
Tell me exactly what happens and I am sure we'll have you back up and running again.
PART 1 - XLC.dll
================
Follow these instructions to register maually:
1) goto start button and select "run"
2) type in "cmd" this will get up a command prompt window.
3) Navigate to the xlc install directory (use "cd" commands)
4) check using "dir" that two files are present XLC.dll and XLC.xll
5) Register XLC.dll by typing "regsvr32 XLC.dll" into the command prompt window. - you should get a message saying you have succeeded in registering.
6) Hopefully you can see the toolbar when you start Excel.
Brandtw 11 years ago
I closed the XLC Tools menu and can't find how to open it again. Help?
I tried re-installing, but no luck. The XLC toolbar is not visible under View>Toolbars. XLC still shows up in the add ins list.
I have used it several times, but didn't need it for one project and closed the toolbar. Wish I hadn't done that.
I even tried doing a manual install, nothing works. Please Help!
JohnDoyle[Admin] 11 years ago
I have just checked the download again and it works fine. I don't think we have a problem at the site.
donm 11 years ago
I got the last newsletter with the update link. Downloaded new XLC. After removing the old XLC, I tried to unzip the file. Got the error message from Winzip that it was not a valid zip file. Tried downloading again directly from the site and had the same result. Any suggestions?
donm
JohnDoyle[Admin] 11 years ago
I have just checked the download and it works fine. The file size should be 528Kb so if yours is just 70 to 80 Kb then something is going wrong somewhere but I don't think we have a problem at the site.
ehcet 11 years ago
Tried to download XCL. 4 times. Each time
it downloads 70-80KB. then it shows full download. When I try to install it come up with error message "uncomplete file"
Please inform
Thanks
Ernie
thorgan 11 years ago
Hi John,
Thanks for getting back so promptly. I went ahead and did a full install, but it still just shows up under Administrator.
I'm hoping we have slightly above admin rights at work so that I can install it, as I've shown it to a few of the team who were all very impressed.
Thanks again,
Tim.
JohnDoyle[Admin] 11 years ago
Thanks for your encouraging comments Tim. Its good to have you aboard. You are quite correct if XLC.dll is not registered (either manually or automatically when setup.exe is run) the toolbar will not show. Unfortunately I can't think of another way of helping you. You'll just have to install it when you have administrator rights (which is the way we would normally advise anyway).
thorgan 11 years ago
Hello All,
Firstly thanks for this great addition to Excel. Its a very clever idea and probably long overdue. I frequently put together the equation using equation editor in my workbook and its painful not to mention not linked at all to the formula. I'm pretty sure colleagues will find this useful too.
I have a question about installation. I used the manual install method (register dll and add addin) and that worked fine under administrator rights on my laptop, however I can only see the addin under other users (XP Home) and I can't see the toolbar. Trying to register the dll under these users fails, most likely due to rights restrictions. So my question is - is there some way I can add a key or something to the registry so that all users can see the toolbar? I ask this because I usually try to avoid working on the laptop as administrator.
Many thanks, and congrats,
Tim.
JohnDoyle[Admin] 11 years ago
It looks like you just need to use the OVD() and UND() functions to draw parts of your equation OVer the Division line and UNder the Division line.
Enter "=SQRT(OVD(5+3)/UND(2))" into a cell, display the equation and you'll see the big SQRT symbol.
Clarke 11 years ago
I appear to have the same problems with the square root sign display. I have just downloaded the latest version and installed it with Office 2007.
I have attached the XLS file.
Any suggestions as to what is going wrong with my set up? [file name=Sqrt_problem.xls size=41472]/media/kunena/attachments/legacy/files/Sqrt_problem.xls[/file]
JohnDoyle[Admin] 11 years ago
I am sorry wes616 my intention is to keep everyone up to date with the latest features and so I don't end up trying to support older versions of the software. That said the upgrade seems to be causing some problems out there.
Here is a quick fix:
The zip file you download for XLC version 03_08 includes the latest copy of XLC.dll. All you need to do is copy it and paste in into the XLC install directory.
Let me know if this gets you going and I'll update the upgrade instructions (it might be simpler for people to do this rather than running the install programs).
wes616 11 years ago
I have recently become very frustrated with the expiration policy. It seems like every time I turn around, the liscense has expired, and I am asked to re-download the program.
I have now spent over 30 minutes trying to get the upgrade to work. I follow the instructions on upgrading, but still get the graphic that sends me to the download page to get a current copy. I don't know what I am doing wrong. Do I need to restart! It is becomeing not worth it to use.
JohnDoyle[Admin] 11 years ago
Scott it sounds like you might be able to teach this dog some new tricks - it doesn't ring any bells with me. As you say its so easy to create a table of results and plot it I am not sure if we need another method.
Rebel300r 11 years ago
Thanks John, that is the way I have been doing it too. There is a way to graph an equation across a range without making the grid of points. I made some progress last night but have not been able to make it work. It involves naming or defining cell ranges but it looked like as much work as just building a matrix and plotting it.
Scott
JohnDoyle[Admin] 11 years ago
Scott you could check out this [url=/site-news/excelcalcs-news/excelcalcs-a-youtube-favourite!/]Video 2 - How to Present Great Calculations in Microsoft Excel (5 min 10secs).[/url]
One side of the template is arranged as a grid for presentation and the right hand side is arrange as any other worksheet. Using the XLC template I arrange all the formulae in one column and present the formulae in this area. Then I simply copy the column into a number of other columns on the right hand side to produce a table of calculations. I change an input parameter moving from column to column and plot it against a calculated value.
I hope this makes sense. I have uploaded the calculation that I used to make the animation too [url=/component/option,com_remository/func,fileinfo/id,376/]Forced Vibration of a single degree of freedom system.xls
[/url]
JohnDoyle[Admin] 11 years ago
Dennis the chances are that the old XLC version has not been un-installed and you somehow are starting up version 01_08 which is now expired. To un-install the old version go to the windows start button and select:
All Programs>XLC>un-install XLC
To double check it has been un-installed see that XLC.dll and XLc.xll are removed from the install directory (normally C:\program files\XLC). Download XLC version 03_08 and install.
If this did not work I am perplexed but all the updating process does is replace an old version of XLC.dll with a new version of XLC.dll. The zip file you download for XLC version 03_08 includes the latest copy of XLC.dll so you can always update the old copy with a simple copy paste.
I hope this gets you going again Dennis. Let me know if you have any more troubles.
Rebel300r 11 years ago
Hi, love the animation feature. It raised a question. For the example video, how did you graph an equation? Did you list out all the numbers and then graph them or is there a way to graph an equation across a range?
This may not belong under XLC issues but it sure got me thinking. I could not find any easy way to graph an equation.
Scott
LQEngineer 11 years ago
John,
I just updated to the latest XLC v. 3.08 and was attempting to create a forumula from the Add-in menu ribbon common in Excel 2007. I keep receiving an error message that the version I am using is an old version and that it will direct me to the Excel Calc website to download the latest version. This is the latest version.
I read one of the posts on the forum and tried first to uninstall the version that I had on the computer which was successful. I had to download v. 3.08 again and I reinstalled.
I also went through the Excel options to find all add-in's and .com add-in's to make sure that I removed everything that referenced XLC before I reinstalled.
After downloading the latest version again, I installed it and started Excel back up. I found the XLC ribbon in the add-in menu and highlighted a cell to create the formula. I received the same error message:
"Your copy of the ExcelCalcs Add-in is old and you need a new copy. You'll be directed to www.excelcals.com website where you can download a new updated copy for free."
I still can not get it to work. Should I be rebooting my computer before reinstalling (which I will try) so as to unload any DLL files still loaded that can not be overwritten?
Thanks in advance.
Dennis
JohnDoyle[Admin] 11 years ago
It begining to smell like an administrator rights issue to me. can your systems administrator log in and install it? Anyway at least you have it working on two other machines. Thank for your help with this but I am tempted to hang my boots up on this issue.
gdjones 11 years ago
I have tried what you suggested, but Excel still says that xlc.xll is not a valid add-in.
I have tried installing XLC on my home machine, which has XP Home Edition and Office 2003, and had no problems. I have also successfully installed it on another XP machine with Office 2000. So it appears to be a problem with the setup of my works machine somehow.
JohnDoyle[Admin] 11 years ago
Let's do a quick check to see if it is a problem associated with XLC.xll.
Uninstall XLC and check that when Excel starts up that there are no error. OK
Now Do not install XLC.dll but go straight to PART 2 of the manual installation below. I am particularly interested in what happens at point 8.
PART 2 - Manually Install XLC.xll
=================================
7) In Excel go to Tools>Add-Ins... This displays the Add-ins form.
8) From the add-ins form select the browse button and navigate to your XLC installation directory (normally this is C:\Program Files\XLC unless you installed it elsewhere). Select the xlc.xll and press 'OK'. This has manually installed xlc.xll
9) Close Excel and restart it again.
10) If all went well when you enter "=ovd(1)/und(2)" it will evaluate it as 0.5 and not give any "#NAME" error messages.
JohnDoyle[Admin] 11 years ago
Clearly this is a problem. It is strange because I have XLC working in Excel 2003 on XP with no problems. The thing that worries me most is when you get the message 'C:\Program Files\XLC\XLC.xll' is not a valid add-in. This could also give the "Run-time error '1004': Add method of AddIns class failed." associated with installation of XLC.dll. I have exhausted all the routes of enquiry and I fear that I might not find a solution for you.
I'll ask an old college friend and programming guru if he has any ideas. I'll get back to you later.
gdjones 11 years ago
I am having the same problem, so cjscjs is not the only one.
I installed XLC.dll manually as you said in your instructions. When I open Excel, I get the error
Run-time error '1004':
Add method of AddIns class failed.
I do see the XLC toolbar at this stage but it doesn't work. Whenever I click on any of the buttons it asks me insert a hyperlink.
I then tried to install XLC.xll manually. At stage 3, I get the error message
'C:\Program Files\XLC\XLC.xll' is not a valid add-in.
If I close Excel and open it again, I still get Run-time error 1004.
JohnDoyle[Admin] 11 years ago
I am sorry you can't get it installed. I am not quite sure what the problem is all I can do is reassure you that thousands of people have managed to install it.
It would be useful if you could give me any system messages that occur against each point of the manual installation instructions.
There are two files Excel needs to have installed separately 1)XLC.dll (this is the toolbar component) and 2)XLC.xll (this contains special XLC functions).
PART 1 - Manually Install XLC.dll
=================================
Follow these instructions to register manually:
1) goto start button and select 'run'
2) type in 'cmd' this will get up a command prompt window.
3) Navigate to the xlc install directory (use 'cd' commands)
4) check using 'dir' that two files are present XLC.dll and XLC.xll
5) Register XLC.dll by typing 'regsvr32 XLC.dll' into the command prompt window. - you should get a message saying you have succeeded in registering.
6) Hopefully you can see the toolbar when you start Excel.
PART 2 - Manually Install XLC.xll
=================================
7) In Excel go to Tools>Add-Ins... This displays the Add-ins form.
8) From the add-ins form select the browse button and navigate to your XLC installation directory (normally this is C:\Program Files\XLC unless you installed it elsewhere). Select the xlc.xll and press 'OK'. This has manually installed xlc.xll
9) Close Excel and restart it again.
10) If all went well when you enter "=ovd(1)/und(2)" it will evaluate it as 0.5 and not give any "#NAME" error messages.
XLC is installed and working.
cjscjs 11 years ago
I finally gave up and deleted / uninstalled all of the files. it created more problems than what it was worth.
gdjones 11 years ago
I am having exactly the same issues as the other user in installing XLC. I have tried following the manual installation instructions but with no luck. When I try to use Tools->Add-Ins, it says that XLC.xll is not a valid add-in.
I am using Windows XP and Office 2003.
Gys 11 years ago
Wow, thanks! I just installed the update and can confirm that it works. Excellent stuff.
JohnDoyle[Admin] 11 years ago
Just a couple of glitches ironed out in version 03-08 build 03. Got there in the end.
JohnDoyle[Admin] 11 years ago
The upgrade instructions read: "Upgrading - Uninstall previous version (Start>Program Files>XLC>uninstall). Download and unzip the installation file. Run setup.exe."
Are you sure you uninstalled version 01-08 first?
mguter 11 years ago
I am trying to install Version 03_08 . It seems to go through the installation routine, but when I open the info from the toolbar it shows Version 01.08 and I can not use the software - I am getting message about installing the new copy.
JohnDoyle[Admin] 11 years ago
I have fixed the problem and updated XLC version 03-08 to Build 002. You can un-install your existing version and reinstall the [url=/repository/MS-Excel-Add-Ins/XLC-Version-03_08/]latest version[/url]. Thanks again for reporting it in Gys
JohnDoyle[Admin] 11 years ago
Thanks for reporting this in Gys. There is an odd looking period (or "." character) at the end of an equation when the EqnPrefix is set to blank. I'll take a look into this and get back to you later.
Gys 11 years ago
I just downloaded and installed this very useful add-in. It certainly looks as though I will be using this a lot.
I found that I can suppress the automatic equation numbering by setting the EqnPrefix field in the EQS function to blank. However, I then end up with an odd-looking period at the end of my equation. Is there any way to get rid of this? Or another way to stop the automatic equation numbering?
BATBAYAR 11 years ago
it s good to use
JohnDoyle[Admin] 11 years ago
Hopefully all these issues are addressed in XLC version 03-08.
JohnDoyle[Admin] 11 years ago
I am afraid I do not know I don't have a mac to test it on. If anyone out there knows I would like to know too.
cartann 11 years ago
I'd like to know too.
I'm running a PPC Imac. Excell 2007
tplatz 11 years ago
Hello anyone and everyone,
I'd like to know if XLC is compatible with mac?
Clyde 11 years ago
Thanks John,
That worked just fine. And yes, this was my laptop.
Best regards,
Clyde
JohnDoyle[Admin] 11 years ago
Hi Clyde I think you need to uninstall XLC version 01_08 first and then install the version 03_08. I had the same problem with my laptop.
markd 11 years ago
Update:
I have Excel Calcs running now.
It started working probably after I de-selected all other Add-Ins from the "Tools->Add-Ins" menu. Not sure though.
Best regards,
Mark
Clyde 11 years ago
Hi John,
I installed the file for 03_08 but my toolbar does not have the animation icon. I'm using EXCEL 2007. The inforfmation window shows version 01.08 and expires March 31. The font seems different when I use redraw. The colors will change based on the font color for the eqs cell. I still love ExcelCalcs.
Best regards,
Clyde
BridgerJeff 11 years ago
Good work on the new release. The updates are nifty and have really cleaned up some of my equations. I seam to get a extra divide slash in my equation out put. I've emailed you an example
markd 11 years ago
Hello all,
I am new to this forum, I just downloaded Excel Calcs today. Unfortunately, after having installed XLC_03_08 I get an error when opening excel:
Execution Error '1004' :
Add Method of AddIns class has failed.
The problem was partly discussed in another thread but this thread seemed to stop quite some time ago (program causes faults in excel & does not work). I could not get the solution from this thread.
Some observations and things I have tried so far:
The XLC tool bar is active', but when I click any of the icons on this toolbar I get linked to the "Insert Hyperlink" dialog box.
I have tried the following:
1) Install XLC_03_08 with the installer.
2) Install XLC_03_08 manually through the commander (regsvr..) as described in the readme file.
3) Select XCL.xll via tools->add-ins. I then get the error message: 'C:\Program files\XLC\XLC.xll is not a valid add-in
- My Excel version is Office 2003
Best regards,
Mark
MajorMagee 11 years ago
You've really outdone yourself this time. The animation function is brilliant.
JohnDoyle[Admin] 11 years ago
That's a Vista thing - only administrators can install software. XLC has no user privilege requirements.
riverberg 11 years ago
John,
Do you have to be logged in as an administrator for XLC to work? Reason I ask is as a standard or limited user, the Addins tab does not display, but as an admininstrator it appears. Is that a requirement for using XLC on Vista? Just wondering.
Thanks,
riverberg 11 years ago
I am using the setup file and running it as an administrator. I have the XLC add-in installed in Excel, but I do not have an add-ins tab. Mine stops at View. is there a reason for this?
Thanks,
JohnDoyle[Admin] 11 years ago
I am very grateful for your comments (good or bad).
JohnDoyle[Admin] 11 years ago
Are you installing using the setup.exe in the zip file. After installation you'll see XLC in the ribbon under Add-Ins (see below). [img size=559]/media/kunena/attachments/legacy/images/xlc_in_vista.png[/img]
If you can't see it then the xlc.dll is not registered
if you get a name error with the xlc functions OVD(), UND() or EQS() then xlc.xll is not installed as an addin for excel.
Let me know what is working and what is not and I can help you more from there.
riverberg 11 years ago
I am using Windows Vista and Office 2007. While I can register XLC.dll and I can use the functions in Excel (using the Add-Ins menu), the XLC toolbar does not appear and I was wondering if there is a way in Excel 2007 to add it to the ribbon or somehow customize the menu to make the XLC commands appear in a toolbar.
Thanks,
Roger Blake 11 years ago
Yes, I got error messages but it worked today.
thanks,
-roger
JohnDoyle[Admin] 11 years ago
I have just done a quick check Roger and everything appears to be working fine for me. Are you given any error messages?
Roger Blake 11 years ago
I am registered but the board denies me permission. Why?
JohnDoyle[Admin] 11 years ago
Glad you like the site. We have no plans to support OpenOffice but I would be interested if XLC can work with it. XLC itself is not open source code.
noble 11 years ago
i have tried 3 times and all the times the file I download is corrupt
RAFH 11 years ago
Aloha All,
I am delighted to find this site, it is hopefully a dream come true.
However, I have a big question, as noted in the title, is XLC and all of this generally compatible with OpenOffice's OpenDocumentSpreadsheet.ods? I am assuming it is, as everything else I've ever tried that worked in Excel has worked in OpenOffice's implementation.
The reason is I just prefer the entire attitude of OpenOffice, being it is Open Source, which seems to be the very basic nature of what this site is all about.
Hopefully all will be well.
ingle 11 years ago
I agree with Maj in regards to the expiration policy. My work computer requires admin rights to install software. Installing the software manually is against company rules and therefore not an option. However, my IT department will evaluate the software and release it if no problems are encountered during testing. This evaluation takes approximately 2 months. The problem is that each new version will require me to go through the approval process. Is there any other options?
Ponzo 11 years ago
Yes I tried it and it didn't change things. So I am convinced this has to do with the image/method my IT department uses to transfer user data from old computers to new computers.
It is quite the puzzle, but fortunately if I leave XLC installed the error doesn't show up.
JohnDoyle[Admin] 11 years ago
It is fixed in XLC version 01_08 build 0006. [url=/guide/download-xlc/]Download now[/url]. Sorry again for forgetting this problem.
[img]/images/stories/WebLog/superscriptfix.png[/img]
JohnDoyle[Admin] 11 years ago
I am really sorry DevanJ I went on holiday and clean forgot about this problem. I have only picked up on it now. I have fixed the problem along with a few others and I'll be uploading a new XLC build soon. I'll let you know when it will be ready to download.
JohnDoyle[Admin] 11 years ago
And evening for others of us Greg. Thanks for your comments. You are quite right use the 'redraw all worksheet equations' is the only way to update the equation numbers.
JohnDoyle[Admin] 11 years ago
If you have reinstalled XLC jim. I guess that you tried Start>All_Programs>XLC>'Uninstall_XLC'. Did this solve your problem?
Ponzo 11 years ago
Tried it, it didn't work so there must be something else going on related to the image/installation my IT department did. However, if I install XLC the error goes away.
Thanks anyway.
Jim
gduncan 11 years ago
Good morning (afternoon for some), The more I use ExcelCalcs the more I like it. I'm using it all the time!
I have noticed that with spreadsheets that have multiple worksheets the initial numbering of equations is not sequential. I notice this after adding equations to an existing set. The new equation(s) have are assigned numbers that are quite a bit higher than the last one on the page. When the equations are redrawn the numbers on each worksheet become sequential.
Thanks for the great product.
Greg Duncan
JohnDoyle[Admin] 11 years ago
Cheers Scott - Order restored to the universe. Thank goodness for that!
Rebel300r 11 years ago
Not only is is weird but it is un-repeatable. I rebooted and it has disappeared. Must have been something else going on at the time.
Love the program and the repository.
Scott
JohnDoyle[Admin] 11 years ago
It is playing up because XLC recognises "/" as an operator. I suggest you use a work around for the time being and I'll put it on my 'todo' list for sometime in the future. Thanks for reporting it in.
JohnDoyle[Admin] 11 years ago
I guess the easiest way is to run the un-install program but maybe you can't do this if it has been deleted. fortunately there is a manual way of un-registering XLC
Follow these instructions to un-register manually:
1) goto start button and select 'run'
2) type in 'cmd' this will get up a command prompt window.
3) Un-register XLC.dll by typing 'regsvr32/u XLC.dll' into the command prompt window. - you should get a message saying you have succeeded in un-registering.
Hopefully this will work.
kau 11 years ago
Hello, great addin...
If the equation has "n/a" in it, the equation won't show when the button is pressed on the toolbar.
[code]=IF(C68<1,"ok","na")[/code]
prints the equation.
[code]=IF(C68<1,"ok","n/a")[/code]
does not print the equation. It's not that big of a deal to work around it if its too difficult to fix.
Thanks,
Ben
Ponzo 11 years ago
I just got a new computer at work and I am getting an error that XLC.dll can not be found. I know this is because the computer doesn't have XLC installed on it. Somehow IT did an image copy of my old settings which is making the computer think XLC is installed on the computer which is not.
Before I try to install XLC over the top of the error message, does anyone have any suggestions on how to uninstall the XLC toolbar or at least get rid of themessage?
Thanks,
Jim
JohnDoyle[Admin] 11 years ago
Scott that strikes me as completely weird and I am not sure what can be going on here. Perhaps you could send me a copy of your spreadsheet so that I could take a look?
Rebel300r 11 years ago
Hi,
I have installed ExcelCalcs. When I hit the "=" button, Excel attempts to install a hyperlink. Is there some setting I have incorrect? Has anyone seen this before?
Thanks,
Scott