XLC Add-In for Excel

(4/114)

Description

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

XLC_Ribbon_2013.gif

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, 2019 and Excel365 (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 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 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”.
  • 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. 

 

User Comments

 '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.


Calculation Preview

04 Apr 2024
File Size: 647.22 Kb
Downloads: 12607
File Version: 16.05.25
File Author: John Doyle
File Rating (4/114)

 
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 625
johndoyle-admin 5 months ago
We offer free 3 month subscriptions to anyone contributing calculations to the site.
ganukarthickm1 5 months ago
3 month subcription available?
sanya 3 years ago
ok
yosso 4 years ago
Is there a way to install the addin w/o admin rights?Thank you in advance.
pepo 4 years ago
very helpfull module thank you sir
johndoyle-admin 5 years ago
See Support > FAQs > How to configure XLC in the XLC Pro mode
tkt 5 years ago
where can i get a spreadsheet related to geotechnical problems?, like bearing capacity, settlement etc.
johndoyle-admin 7 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
johndoyle-admin 7 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 7 years ago
I would like to make
johndoyle-admin 8 years ago
Please refer to this [frequently asked question](/support/faqs/repository-downloads-have-name-errors/). This will help.
johndoyle-admin 8 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 8 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 -bitI have only one active add-in: XLCP.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 8 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. 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 8 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 8 years ago
Any news?
johndoyle-admin 8 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 8 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 8 years ago
If I right click on the worksheet and select
bmt_structural 8 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).
johndoyle-admin 8 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 8 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 8 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 8 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 8 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 8 years ago
Fail attached Filename [xlc_min_max.xlsx](/images/fbfiles/files/xlc_min_max.xlsx), size 15602
johndoyle-admin 8 years ago
Priit, can you attach a sample and I'll take a look?
priit 8 years ago
The question is not about
johndoyle-admin 8 years ago
Equations can be shown in an algebraic form or a numeric form using this button **Algebra/Number**. This is documented on our [help page](/addins/xlc-help-and-tutorials).XLC may have difficulties rendering equations when the cell name includes a
priit 8 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
johndoyle-admin 8 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 8 years ago
Please find attached sample file Filename [error.xlsx](/images/fbfiles/files/error.xlsx), size 22380
johndoyle-admin 8 years ago
Could you attach a sample Excel file which I can examine?
priit 8 years ago
It messes up my all old calculations as well when I update.
priit 8 years ago
Excel 2016 64bit @ Windows 10 w anniversary update
johndoyle-admin 8 years ago
As stated in the description above
johndoyle-admin 8 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
johndoyle-admin 9 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 9 years ago
A little more error protection code has been added (for additional protection against run-time errors).
johndoyle-admin 9 years ago
I have made added some error protection features to address an issue [reported in the forum](/support/forum)
johndoyle-admin 9 years ago
[A new version of XLC is available v16.03.27](/calcs/repository/Excel-Addins/XLC-Add-In-for-Excel/). 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 9 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.
johndoyle-admin 9 years ago
Can you tell me the exact sequence of events to reproduce the error?
johndoyle-admin 9 years ago
I hope this issue has been [already solved in another thread in the forum](/support/forum). You just need to install the [latest version of XLC](/calcs/repository/Excel-Addins/XLC-Add-In-for-Excel/).
gossinnov 9 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
johndoyle-admin 9 years ago
[Download latest version of XLC](/calcs/repository/Excel-Addins/XLC-Add-In-for-Excel/). 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 9 years ago
I have made added some error protection features to address an [issue reported in the forum](/support/forum)
johndoyle-admin 9 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.
johndoyle-admin 9 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 9 years ago
johndoyle-admin 9 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?
johndoyle-admin 9 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.
johndoyle-admin 9 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
johndoyle-admin 9 years ago
Apart from the 'Settings'button does XLC function correctly?
johndoyle-admin 9 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.
peachsb 9 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 (
johndoyle-admin 9 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.
johndoyle-admin 9 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.
johndoyle-admin 9 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.
johndoyle-admin 9 years ago
The default installation directory is C:Program FilesXLC 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.
johndoyle-admin 9 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 9 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.
johndoyle-admin 9 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.
johndoyle-admin 9 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 9 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.
johndoyle-admin 9 years ago
Hi Pratto. Trial subscribers generally [download XLC by following this link](/calcs/repository/Excel-Addins/XLC-Add-In-for-Excel/). They get access to only two download directories, [Addins](/calcs/repository/Excel-Addins/) and [Trial](/calcs/repository/trial/), to see how the download process works. All the plans are [compared here](/pricing/compare-subscription-plans) and are [individually described here](/pricing/compare-subscription-plans).
johndoyle-admin 9 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.
johndoyle-admin 9 years ago
Hi Tim - In Excel goto the File>Options>Addins and press the
johndoyle-admin 9 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 9 years ago
Yes - my problem seems to be fixed.Thank you
johndoyle-admin 9 years ago
The latest version fixes the workbook calculation setting problem [reported in by Priit](/support/forum).
johndoyle-admin 9 years ago
Priit - I have just uploaded a [new version of XLC](/calcs/repository/Excel-Addins/XLC-Add-In-for-Excel/) 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 9 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 9 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,
johndoyle-admin 9 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 9 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 9 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 9 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.
johndoyle-admin 9 years ago
Can you send me a sample worksheet using XLC and I will take a look.
priit 10 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 10 years ago
File does not matter.If I uninstall xlc, then this
johndoyle-admin 10 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 10 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 10 years ago
I have contributed an excel sheet for disc brake calculations underHome> 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 10 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 10 years ago
The error message
2bmerchant 10 years ago
Hi JohnI'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 10 years ago
Just go to the Windows start button All Programs>XLC>Uninstall XLC. Thanks for your comment it may help other users.
johndoyle-admin 10 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
yvesrossignol 10 years ago
I always have the following error:Name????
yvesrossignol 10 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 meYves
johndoyle-admin 10 years ago
The procedure is [here in the FAQs](/support/faqs/how-to-configure-xlc-in-the-xlc-pro-mode/).
brownden 10 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 10 years ago
This is often asked and we offer some solutions in our [FAQs](/support/faqs/trouble-with-units/)
brownden 10 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. Filename [Steel_Angle_Lintel_L2_Design___Version_2.xlsx](/images/fbfiles/files/Steel_Angle_Lintel_L2_Design___Version_2.xlsx), size 222365
johndoyle-admin 10 years ago
I had some problems with the previous character it seemed to be the same as
johndoyle-admin 10 years ago
Thankfully Windows has already given us a shortcut:Alt +66D Hold down the alt key then
johndoyle-admin 10 years ago
JakeAs you have hinted at
johndoyle-admin 10 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.
johndoyle-admin 10 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.
johndoyle-admin 10 years ago
There are two versions of XLC most people install the ribbon version which works with Excel 2007 and later. There is also [XLC toolbar version](/calcs/repository/Excel-Addins/XLC-Toolbar/) that works with Excel 2003. It appears you have tried to install the ribbon version in Excel 2003 - which will not work.
johndoyle-admin 10 years ago
There are two versions of XLC most people install the ribbon version which works with Excel 2007 and later. There is also [XLC toolbar version](/calcs/repository/Excel-Addins/XLC-Toolbar/) that works with Excel 2003. This is explained all XLC download pages.
johndoyle-admin 10 years ago
[Follow these instructions](/support/faqs/how-to-configure-xlc-in-the-xlc-pro-mode/).
johndoyle-admin 11 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.
johndoyle-admin 11 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
johndoyle-admin 11 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 [XLC toolbar version](/calcs/repository/Excel-Addins/XLC-Toolbar/) 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 11 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.
johndoyle-admin 11 years ago
I have just added the MoreVision code signature to the installer. No change to XLC.
johndoyle-admin 11 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 11 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 [in this thread](/support/forum).
johndoyle-admin 11 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
johndoyle-admin 11 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 [Microsoft site](http://support.microsoft.com/kb/282847)). 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 11 years ago
Hi Roger sorry you are having some difficulty installing the software. Firstly did you install the the [ribbon version of XLC](/calcs/repository/Excel-Addins/XLC-Add-In-for-Excel/) 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 filesXLC) 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.
johndoyle-admin 11 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
johndoyle-admin 11 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.
johndoyle-admin 11 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
johndoyle-admin 11 years ago
I have been away for a couple of days Alex but I am pleased you managed to work this out for yourself.
johndoyle-admin 11 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.
johndoyle-admin 11 years ago
Dennis - Toolbar version and ribbon version implement XLC functions in different ways. We have a [FAQ which answers all your questions](/support/faqs/repository-downloads-have-name-errors/). Good luck with your deadline.
denniskirk 11 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
johndoyle-admin 11 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.
johndoyle-admin 11 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 [help page](/support/faqs) and in particular the requirements for a named CellIf you wish please attach your file so that I can examine it in more detail.
johndoyle-admin 11 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]
johndoyle-admin 11 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: BTW to select an image click on the 'Choose File' button then place the image in your post using the button to the right.
johndoyle-admin 11 years ago
JakeThere 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'
johndoyle-admin 11 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: Simply remove these characters and all the rendering problems will disappear.
johndoyle-admin 11 years ago
I have had no problems in building the equation from scratch (see below): 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 11 years ago
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.
johndoyle-admin 11 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 11 years ago
Don't know what ctrl+shift+j means or does BUT IT WORKEDB) Many thanks Charlie
johndoyle-admin 11 years ago
[To rectify just press the {CTRL+SHIFT+J} keys simultaneously.](/support/faqs/repository-downloads-have-name-errors) I hope this sorts you out.
charlie_james 11 years ago
What am I doing wrong?:S . I have loaded XLC ribbon
johndoyle-admin 11 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 11 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 11 years ago
Some people have been troubled with hidden equations. The latest version 13.09.02 corrects this problem. Please download.
johndoyle-admin 11 years ago
Hi DirkI 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 11 years ago
HiCan anyone help me with installing Excel calcs into Office 365. I keep on getting an errorUnable to register the DLL/OCX problemRegardsDirk
johndoyle-admin 11 years ago
It is also worth reading our [good calculation guide](/calcs/good-calc-guide) 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 11 years ago
There is a [great addin here which will do a great job of unit conversion.](/calcs/repository/links/changeunits/)
joe.tonneson 11 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.
johndoyle-admin 11 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 [these instructions specifically](/support/faqs/how-to-configure-xlc-in-the-xlc-pro-mode). When you are sure this has been done correctly use the
johndoyle-admin 11 years ago
I trust you installed the [ribbon version of XLC](/calcs/repository/Excel-Addins/XLC-Add-In-for-Excel/) rather than the [toolbar version](/calcs/repository/Excel-Addins/XLC-Toolbar/)?The ribbon version installation is generally un-problematic. Installing the toolbar version can occasionally be a little more difficult to install.
nephembani 11 years ago
thanks
johndoyle-admin 11 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.
johndoyle-admin 11 years ago
EdwardI 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.
johndoyle-admin 11 years ago
This s very strange but without being able to reproduce the error it is difficult for me to investigate.
johndoyle-admin 11 years ago
I hit the redraw button to produce the equation:
johndoyle-admin 11 years ago
RobSimply enter cell C3 in your example and click the Insert Equation button.
johndoyle-admin 11 years ago
Yes it is easy to do. Just use the XLC
johndoyle-admin 11 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.
johndoyle-admin 11 years ago
EricI 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. Filename [XLC_error2.xlsx](/images/fbfiles/files/XLC_error2.xlsx), size 1574793
johndoyle-admin 11 years ago
Could you attach a file exhibiting the problem and I'll take a look at it?
johndoyle-admin 11 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.
johndoyle-admin 11 years ago
EdwardThank 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 [link to retrieve your release code](/support/faqs/how-to-configure-xlc-in-the-xlc-pro-mode). There is some [additional help here](/support/faqs/how-to-configure-xlc-in-the-xlc-pro-mode/).If you are still having trouble drop me a line - I'm sure we get get this resolved quickly for you.
johndoyle-admin 11 years ago
Expiration date for XLC Trial users extended to 30th September 2013.
johndoyle-admin 11 years ago
MarttiI 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.
johndoyle-admin 12 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.
johndoyle-admin 12 years ago
Are you installing the toolbar version of XLC or the ribbon version?
AndrewLivingstone 12 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 12 years ago
thanks :)
johndoyle-admin 12 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 12 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 12 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.
johndoyle-admin 12 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 12 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 ([as reported in the newsletter](/support/news/training-courses-for-london-underground/)).Also modified graphics routines for better functionality with the Excel Web App and Microsoft SkyDrive.I recommend that you install this update.
johndoyle-admin 12 years ago
I have updated the [help page](/support/faqs) 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 12 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 [help page on the website](/support/faqs) again simply hover over the button graphic above the video player to reveal the help.
johndoyle-admin 12 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?
johndoyle-admin 12 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.
johndoyle-admin 12 years ago
Improvement to EQS() functionality so that it works correctly with 'Auto XLC' switched on. It is recommended that you reinstall this update.
johndoyle-admin 12 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
johndoyle-admin 12 years ago
Mmm I can't remember why - I'll take a look into it Brian and get back to you later.
johndoyle-admin 12 years ago
XLC seems to be recognising bd_Dewpoint as a cell reference (I don't entirely know why). However if you remove the
johndoyle-admin 12 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.
johndoyle-admin 12 years ago
Correction to name button problem reported [here](/support/faqs/repository-downloads-have-name-errors).
johndoyle-admin 12 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.
johndoyle-admin 12 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 12 years ago
Hi BrianThis 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
peachsb 12 years ago
Fantastic. Downloaded, installed and appears to work great. I have missed this add-in. Thanks!
johndoyle-admin 12 years ago
[XLC Ribbon Version](/calcs/repository/Excel-Addins/XLC-Add-In-for-Excel/)It's here and it support 32 bit and 64 bit versions of Excel 2010.
johndoyle-admin 12 years ago
Introducing the first release of [XLC Ribbon version](/calcs/repository/Excel-Addins/XLC-Add-In-for-Excel/) for Excel 2007 and 2010 (both 32 bit and 64 bit versions of Excel).
johndoyle-admin 12 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.
clyde 12 years ago
Hi John,I would be happy to do some Beta testing. Anything I can do to help. You know I'm
johndoyle-admin 12 years ago
Hi ClydeI 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 12 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.:(
johndoyle-admin 12 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 12 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.
johndoyle-admin 12 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
gte447f 12 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 12 years ago
I have noticed that Skype have released a version of [Skype Click to Call](http://www.skype.com/intl/en/get-skype/on-your-computer/click-to-call/windows/) which does not interfere with Excel or XLC.
arthurjm 12 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 12 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 showingRegardsArthur
johndoyle-admin 12 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 [XLC download page](/calcs/repository/Excel-Addins/XLC-Add-In-for-Excel/) 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).
johndoyle-admin 12 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?
johndoyle-admin 12 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:
    Close Excel.Uninstall XLC.Download and install the latest version of XLC.Restart the computer.
I hope this settles things down but by all means contact me again if you continue to have problems.
arthurjm 12 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
johndoyle-admin 12 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:
    Download XLC.Extract the zip into a folder on your hard drive.Right click on the file
johndoyle-admin 12 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.
johndoyle-admin 12 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.[Microsoft recommendation](http://www.microsoftstore.com/store/msstore/en_US/pd/Excel-2010/productID.216445700):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 12 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 13 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 13 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?
johndoyle-admin 13 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. 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 13 years ago
John,I have just installed and all appears to be working OK.Thanks for that. John
johndoyle-admin 13 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 13 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 13 years ago
Hi,It dosen't recognise the date format as you typed it
johndoyle-admin 13 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 13 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 13 years ago
The message you recieve from XLC should look like this:
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 . 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 13 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 13 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 13 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 13 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 13 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 [here](/support/faqs/common-misconceptions/) and [here](/support/faqs/how-to-configure-xlc-in-the-xlc-pro-mode/).
johndoyle-admin 13 years ago
Hi GregSorry 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
gfs_se 13 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
jfkatmatrix 13 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 13 years ago
It sounds like XLC.xll is installed correctly. XLC.dll is not working correctly. Have you also run
johndoyle-admin 13 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.
keithtfa 13 years ago
JohnOne 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=2c=3A= b+c = 5However in XLC it only displays formulas on the right of a formula cell and you getA=5 b+cAlso 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 workRegardsKeith Sharp
johndoyle-admin 13 years ago
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 13 years ago
OK just type inOAT=to produce what you are after. This is different to enteringOAT =which will give you automatic subscripts (what a difference a
johndoyle-admin 13 years ago
Here are some examples that I hope will help:Make sure the
johndoyle-admin 13 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.
raw01 13 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 13 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 "[Skype causing MS Excel Error](http://forum.skype.com/index.php?showtopic=783421)". Or this one "[Fix Skype addin for Cannot Empty the Clipboard in Office](https://www.online-tech-tips.com/ms-office-tips/cannont-empty-clipboard/)". its also [here](http://mobeer.blogspot.com/2009/01/excel-2007-cannot-empty-clipboard.html).
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.
johndoyle-admin 13 years ago
can you check to see if XLC.xll is correctly installed. Check Excel>Options>AddinsYou 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.
johndoyle-admin 13 years ago
SteveI 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 13 years ago
Also - please note I am using 32 bit excel on 64 bit windows.
raw01 13 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 Filename [J000028_ML_500_Feed_Chute.xlsx](/images/fbfiles/files/J000028_ML_500_Feed_Chute.xlsx), size 329593
johndoyle-admin 13 years ago
Hi Douglas - I am afraid that XLC does not work on the mac. Probably your best option for is to use the
![Image uploaded by user](/images/stories/SaveAsNativeExcel.png) button shown on the left 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.
johndoyle-admin 13 years ago
There appears to be no problem you are subscribed to the trial account. You are free to download our [XLC software](/calcs/repository/Excel-Addins/) and try out some downloads from the [XLC Trial Folder](/calcs/repository/trial/).
johndoyle-admin 13 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.
johndoyle-admin 13 years ago
adrianomv maybe I should have explained that to generate the second chart I simply copied the first table and used Excel's
johndoyle-admin 13 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.
johndoyle-admin 13 years ago
Sorry I did not reply sooner but XLC can be used to display formulas in tabular form. [You should take a look at this video](/404/).
johndoyle-admin 13 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 13 years ago
Hi Simorag. I am afraid that XLC is not compatible with the 64 bit version of Office 2010. The download page reads:
johndoyle-admin 13 years ago
This is actually the way we way we intended XLC to work. There are a number of special characters:
jfkatmatrix 13 years ago
When naming a variable in the 'no-space' manner - i.e.
johndoyle-admin 13 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.
johndoyle-admin 13 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 13 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 13 years ago
I think it might be a problem with your Windows User profile. This has occasionally troubled some people. See [url=/404/[/url]. It may also be worth doing this:
jfkatmatrix 13 years ago
Have checked the status of the addins (see attached image). I note that the
johndoyle-admin 13 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 13 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 13 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 2010When I register XLC.dll I get the following message:
johndoyle-admin 13 years ago
Hi GloriaI 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 and the equation appeared.You might want to check that XLC automatic functionality button is switched on - this means that equations will be automatically drawn when an EQS() function is inserted.You'll find more help in the [help & tutorials page](/support/faqs).
arthurjm 13 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.RegardsArthur
johndoyle-admin 13 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
arthurjm 13 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 Filename [learning_XLC.xls](/images/fbfiles/files/learning_XLC.xls), size 38400
johndoyle-admin 13 years ago
Hi Arthur you just need to follow [these instructions](/support/faqs/how-to-configure-xlc-in-the-xlc-pro-mode/) to remove the
arthurjm 13 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 13 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 13 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
johndoyle-admin 13 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
johndoyle-admin 13 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.
johndoyle-admin 14 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 14 years ago
Spacer I have sent you an email privately. Send me the file and I'll take a look at it.
johndoyle-admin 14 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.
johndoyle-admin 14 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.
johndoyle-admin 14 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
johndoyle-admin 14 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.
johndoyle-admin 14 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
crystalinv 14 years ago
I have downloadeded XLC. anytime i try installing i get this error message '***Unable to register the DLL/OCX: Redsvr32 failed with the exit code 0x5***.'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
johndoyle-admin 14 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
johndoyle-admin 14 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
gfs_se 14 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 14 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.:(
johndoyle-admin 14 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. [Part 1 is here](/404/) and [part 2 is here](/404/).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 14 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
Akinola 14 years ago
thanks
johndoyle-admin 14 years ago
I think all you need to do is enter
johndoyle-admin 14 years ago
Yes I am using it on a 64bit Vista operating system at the moment.
johndoyle-admin 14 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 [forum thread](/images/fbfiles/files/#1808). I can't reproduce the problem to debug it and understand the issue but this is probably worth a try too.
ron_mitchell 14 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 14 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
ron_mitchell 14 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 14 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 14 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 14 years ago
I am posting this email conversation in case it is useful to other users
raw01 14 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 14 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
raw01 14 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.
johndoyle-admin 14 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 14 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 14 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 14 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 helpRon Mitchell
johndoyle-admin 14 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.
johndoyle-admin 14 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: 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.
johndoyle-admin 14 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 [another website](http://www.mydigitallife.info/2007/07/25/the-call-to-dllregisterserver-failed-with-error-code-0x80004005-on-windows-vista/) and copied it below. I hope it can help you resolve the problem.
johndoyle-admin 14 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
johndoyle-admin 15 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 [XLC 10_01 build 03 here](/calcs/repository/Excel-Addins/XLC-Add-In-for-Excel/).
johndoyle-admin 15 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 [download it here](/404/).In the interests of finding a more satisfactory solution to the problem would you agree to run some tests for us?
johndoyle-admin 15 years ago
tmy1337 I have added some error handling code to XLC. I have uploaded it as [XLC 10_01 Build02](/404/). 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 15 years ago
Transcript of Live Support Discussion:tmy1337 - Anonymous from the web says (09:58): Hi Live Support says (09:58): Hitmy1337 - Anonymous from the web says (09:58): im haveing problem with getting XLC to work i get an
johndoyle-admin 15 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
johndoyle-admin 15 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.
johndoyle-admin 15 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 homeLive Support says (23:14): Hi Hermandh Yes no problem you can download as many times as you likeLive Support says (23:15): our license agreement allows a user to install on any machine he likes for his personal use.
johndoyle-admin 15 years ago
I am struggling to find a machine with Windows 7, IE8 and Office 2007 set up. Can you reply regarding the
johndoyle-admin 15 years ago
Did you hit
johndoyle-admin 15 years ago
I have been looking into the error code 0x80004005 [here](http://www.mydigitallife.info/2007/07/25/the-call-to-dllregisterserver-failed-with-error-code-0x80004005-on-windows-vista/), [here](http://www.vistax64.com/vista-installation-setup/33219-regsvr32-error-0x80004005.html) and [here](http://forums.techarena.in/vista-setup-install/667662.htm).
johndoyle-admin 15 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.
johndoyle-admin 15 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 [here](/support/forum).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 [thread](/support/forum)). Just let us know how you get on.
johndoyle-admin 15 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
johndoyle-admin 15 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 15 years ago
The only installation problems I am currently are are of are discussed in [this thread](/images/fbfiles/files/#1798). 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.
johndoyle-admin 15 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
johndoyle-admin 15 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
gfs_se 15 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.
johndoyle-admin 15 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 15 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 15 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 15 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 15 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 15 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 15 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 15 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 15 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 15 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 15 years ago
Just one other idea try running
johndoyle-admin 15 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 15 years ago
The cell displays 0.5
johndoyle-admin 15 years ago
can you insert the following formula into a cell to check if Excel recognises XLC functions?=OVD(1)/UND(2)
gfs_se 15 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 15 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 FilesXLCXLC.dlland tell me what happens.
gfs_se 15 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 15 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.
johndoyle-admin 15 years ago
It looks good to go. Please [download XLC 07_09 build 02](/404/).Thanks again for this useful feedback.
johndoyle-admin 15 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 15 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 15 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 15 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 15 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 15 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. Filename [BTH_pinned_plate_reworked.xls](/images/fbfiles/files/BTH_pinned_plate_reworked.xls), size 229888
johndoyle-admin 15 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 15 years ago
John, uploaded
johndoyle-admin 15 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 15 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 15 years ago
John, I keep seeing ending parenthesis missing in equations. Tried increasing size of
clyde 15 years ago
I reinstalled XLC and all is well now.:unsure:
johndoyle-admin 15 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
clyde 15 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
johndoyle-admin 15 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 15 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 15 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
johndoyle-admin 15 years ago
Yes that's correct David.
johndoyle-admin 15 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 15 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 15 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
Ver 15 years ago
Your graphic display routines are very easily understood by a novice user of excelcalc. Truly great guide
johndoyle-admin 15 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.
johndoyle-admin 15 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.
johndoyle-admin 15 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 [site rules](/support/faqs/excelcalcs-site-rules/). 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 RegardsJohn
MajorMagee 15 years ago
Two would give the most flexibility. That way you could keep the auto updating, but not have to use subscripts.
johndoyle-admin 15 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 15 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 15 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 15 years ago
When entering variable names thus:
johndoyle-admin 15 years ago
Moving forward from my previous post, you realise that we offer [free XLC Pro subscriptions in return for contributions](/calcs/good-calc-guide#Publish)? One idea that has crossed my mind is that I could give you a [Corporate Coupon](/support/faqs/volume-discount-when-you-buy-a-corporate-coupon/) 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 15 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.
johndoyle-admin 15 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.
johndoyle-admin 15 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
johndoyle-admin 15 years ago
I am very grateful for your feedback.
johndoyle-admin 15 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. Filename [Readme.txt](/images/fbfiles/files/Readme.txt), size 2851
johndoyle-admin 15 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 ([read more here](/support/faqs/internet-explorer-may-double-count-downloads/)).
johndoyle-admin 15 years ago
cruzcd unzip and run the attached file. The XLC setup.exe configures XLC for an administrator but the administrator needs to run
johndoyle-admin 15 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
johndoyle-admin 15 years ago
If you have had XLC installed previously you may have hidden the toolbar. On Excels Main Menus select View>Toolbars>XLC Tools.
johndoyle-admin 15 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?
johndoyle-admin 15 years ago
It can be found on the 2007 Ribbon under the 'Addins' tab.
johndoyle-admin 16 years ago
The [Microsoft support site says ](http://support.microsoft.com/default.aspx/kb/920111) 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 16 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/914232Sorry I can't be of more help.
johndoyle-admin 16 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.
johndoyle-admin 16 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.
johndoyle-admin 16 years ago
I have uploaded [XLC version 01_09 build 02](/calcs/repository/Excel-Addins/XLC-Add-In-for-Excel/) the border issue is resolved in this build.
johndoyle-admin 16 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 [vertical alignment of equations](/404) 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.
johndoyle-admin 16 years ago
mmm there is clearly some issue here to be solve. I had been following a line of enquiry under this [forum topic](/support/forum). Here is a summary of the investigationXLC works fine with Excel 2000 and you can save and open files fine.[Book2.xls](/images/fbfiles/files/Book2.xls) 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:[Microsoft](http://support.microsoft.com/kb/920111)[Ozgrid forums](http://groups.google.com/group/spreadsheet-writeexcel/browse_thread/thread/6656856820b6f799/)[Google groups](http://groups.google.com/group/spreadsheet-writeexcel/browse_thread/thread/6656856820b6f799/)
dirkels 16 years ago
HiI am having the same error with Excel 2000. File error: data may have been lost.Excel calc data.9.08 (Ed)File dataStarted 12 August 2008137 formulas6 sheetsThe 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
johndoyle-admin 16 years ago
Thanks burmie The error message
johndoyle-admin 16 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? Filename [Book2.xls](/images/fbfiles/files/Book2.xls), size 15360
johndoyle-admin 16 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 16 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!
johndoyle-admin 16 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.
johndoyle-admin 16 years ago
I am clutching at straws now but do you have full system administrator rights on your machine?
johndoyle-admin 16 years ago
When you have your
johndoyle-admin 16 years ago
OK let's do a few tests1) On the View menu, point to Toolbars, and then click Customize. 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.
johndoyle-admin 16 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?
johndoyle-admin 16 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
johndoyle-admin 16 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):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
jwt 16 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 16 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 ([read here](/support/forum)). 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.
dirkels 16 years ago
This very usefull tool when you have 89 plus formulas in spreadsheet to check!
johndoyle-admin 16 years ago
Try copying the
johndoyle-admin 16 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
jpriley485 16 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 16 years ago
What happens when you copy the
jpriley485 16 years ago
I tried your instructions, must be doing it wrong. Finally, I decided on the
jpriley485 16 years ago
LOL, sorry . . . here it is.I must have tried to upload the file as an image in the previous post. Filename [Box_Beams___XLC.xls](/images/fbfiles/files/Box_Beams___XLC.xls), size 75776
jpriley485 16 years ago
The PDF file could not be uploaded, so here's the Excel file.See next post.
jpriley485 16 years ago
Best way to describe the problem is by attaching a printout (see attached).The
johndoyle-admin 16 years ago
I don't think it is on many keyboards but there is a keyboard short cut code in MS Word:type
jpriley485 16 years ago
On my keyboard,
johndoyle-admin 16 years ago
It may not be on your keyboard John but you can copy this
johndoyle-admin 16 years ago
When you use the
jpriley485 16 years ago
A blank or nil
jpriley485 16 years ago
I wanted to see what equations would look like with an
johndoyle-admin 16 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.
johndoyle-admin 16 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.
johndoyle-admin 16 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
johndoyle-admin 16 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
johndoyle-admin 16 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
johndoyle-admin 16 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.
johndoyle-admin 16 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 16 years ago
I am afraid not Audie.
johndoyle-admin 16 years ago
I am back in the office on August 11th - I'll get back to you then when I can investigate this fully.
johndoyle-admin 16 years ago
You have to attach a spreadsheet showing the problem so I can investigate.
johndoyle-admin 16 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 16 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?
johndoyle-admin 16 years ago
Nidhee, This is strange because I downloaded all the file and did not get the
johndoyle-admin 16 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.
johndoyle-admin 16 years ago
moises I think that their is a
johndoyle-admin 16 years ago
File attachments seems to be working OK moises. I am looking forward to receiving your attachment.
johndoyle-admin 16 years ago
I am just checking the file attachments work in the forum. Filename [test_attachment.xls](/images/fbfiles/files/test_attachment.xls), size 13824
johndoyle-admin 16 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.
johndoyle-admin 16 years ago
I am putting a plan together and I'll survey user opinion so I'll get back to you on this.
johndoyle-admin 16 years ago
Seems weird - can you attach the spreadsheet so I can take a look?
johndoyle-admin 16 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.
johndoyle-admin 16 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.
johndoyle-admin 16 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.[Read the thread and Donm's remarks here.](/support/forum)I hope it works for you.
johndoyle-admin 16 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.CheersJohn
philstunell 16 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 16 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 16 years ago
When attempting to use Xcalc functions I now get a message saying
johndoyle-admin 16 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.
johndoyle-admin 16 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
johndoyle-admin 16 years ago
I have just checked the download again and it works fine. I don't think we have a problem at the site.
johndoyle-admin 16 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.
johndoyle-admin 16 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).
johndoyle-admin 16 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
johndoyle-admin 16 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).
johndoyle-admin 16 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.
johndoyle-admin 16 years ago
Scott you could check out this [Video 2 - How to Present Great Calculations in Microsoft Excel (5 min 10secs).](/support/news/excelcalcs-a-youtube-favourite/)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 [Forced Vibration of a single degree of freedom system.xls](/404/)
johndoyle-admin 16 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 XLCTo double check it has been un-installed see that XLC.dll and XLc.xll are removed from the install directory (normally C:program filesXLC). 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.
johndoyle-admin 16 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.
johndoyle-admin 16 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. OKNow 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 FilesXLC unless you installed it elsewhere). Select the xlc.xll and press 'OK'. This has manually installed xlc.xll9) Close Excel and restart it again.10) If all went well when you enter
johndoyle-admin 16 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 FilesXLCXLC.xll' is not a valid add-in. This could also give the
johndoyle-admin 16 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.xll5) 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 FilesXLC unless you installed it elsewhere). Select the xlc.xll and press 'OK'. This has manually installed xlc.xll9) Close Excel and restart it again.10) If all went well when you enter
johndoyle-admin 16 years ago
Just a couple of glitches ironed out in version 03-08 build 03. Got there in the end.
johndoyle-admin 16 years ago
The upgrade instructions read:
johndoyle-admin 16 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 [latest version](/404/). Thanks again for reporting it in Gys
johndoyle-admin 16 years ago
Thanks for reporting this in Gys. There is an odd looking period (or
johndoyle-admin 16 years ago
Hopefully all these issues are addressed in XLC version 03-08.
johndoyle-admin 16 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.
clyde 16 years ago
Thanks John,That worked just fine. And yes, this was my laptop.Best regards,Clyde
johndoyle-admin 16 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.
clyde 16 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
MajorMagee 16 years ago
You've really outdone yourself this time. The animation function is brilliant.
johndoyle-admin 16 years ago
That's a Vista thing - only administrators can install software. XLC has no user privilege requirements.
johndoyle-admin 16 years ago
I am very grateful for your comments (good or bad).
johndoyle-admin 16 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). If you can't see it then the xlc.dll is not registeredif 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.
johndoyle-admin 16 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?
johndoyle-admin 16 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.
johndoyle-admin 17 years ago
It is fixed in XLC version 01_08 build 0006. [Download now](/calcs/repository/Excel-Addins/XLC-Add-In-for-Excel/). Sorry again for forgetting this problem.
johndoyle-admin 17 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 17 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 17 years ago
If you have reinstalled XLC jim. I guess that you tried Start>All_Programs>XLC>'Uninstall_XLC'. Did this solve your problem?
johndoyle-admin 17 years ago
Cheers Scott - Order restored to the universe. Thank goodness for that!
johndoyle-admin 17 years ago
It is playing up because XLC recognises
johndoyle-admin 17 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 XLCFollow 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.
johndoyle-admin 17 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?
johndoyle-admin 17 years ago
Hi Rayviez I have this complaint from time to time but I think it must be an internet connection issue because it always seems to resolve itself by trying again later. Thousands of people have successfully downloaded. If you have access to another machine maybe you could try that.
johndoyle-admin 17 years ago
This thread is continued [here](/support/forum).
johndoyle-admin 17 years ago
I might be missing your point but I have done the same thing this time using Greek characters. I am not sure if I understand your problem.
johndoyle-admin 17 years ago
Hi netsonicyxf I think the program is working normally because the horizontal line is only drawn over an equation with something above and below the division line. When the equation has no division line it simply uses the sQRT symbol with brackets. See below.
johndoyle-admin 17 years ago
Not that I am aware of PhilJ2. I am afraid that I don't have a mac to play around with but I will makes some enquiries to see if it is possible. You are not the first person to request this feature. It may take a little time but I'll let you know if I make any progress.
johndoyle-admin 17 years ago
Thanks for reporting this in duco123. I don't seem to have any problems using XLC large SQRT symbols in either Excel 2003 or Excel 2007 (see image below and file attached). I suggest that you download and install the latest version of XLC and check again. If you still have problems could you attach the file so that I can take a closer look. Filename [SQRTExample.xls](/images/fbfiles/files/SQRTExample.xls), size 32768
johndoyle-admin 17 years ago
No the file did not upload properly. I did an upload test to check that it was not a site software problem but it worked fine for me. Maybe a connection glitch?. Have a good weekend.
johndoyle-admin 17 years ago
Thanks for your question gduncan its one I have added some notes to the site help on the [name equation button](/404) so it does not cause confusion in the future. See the text under the flash tutorial.
johndoyle-admin 17 years ago
I am not sure what has been happening here Bernard but I am glad it has been resolved. You might like to know that I have just updated XLC to include an ['Equation Cloner' button in response to user requests](/support/forum) in the forum.
johndoyle-admin 17 years ago
Finally nailed it and I have just updated the latest version of XLC which now includes an 'Equation Clone' button. Just [download XLC](/calcs/repository/Excel-Addins/XLC-Add-In-for-Excel/) and reinstall. [There is a help file too to show how it works](/404).
johndoyle-admin 17 years ago
I have played around with this a little but partly because of the existing program structure and partly because I am not clear about how it is best implemented I have not found a solution that I am happy with. The workaround I suggested works pretty well for me (copy the EQS() function and change the equation control string to
johndoyle-admin 17 years ago
I have released [XLC version 01.08](/calcs/repository/Excel-Addins/XLC-Add-In-for-Excel/) which solves this problem.
johndoyle-admin 17 years ago
Please post any comments relating to [XLC Version 01.08](/404/) here:
johndoyle-admin 17 years ago
I have emailed XLC 01_08 Beta Installation.zip to netsonicyxf and bernard. Please check your emails. It is working fine on my my two machines both Windows XP one running Excel 2003 and the other running Excel 2007. I am very grateful for your time and interest.
johndoyle-admin 17 years ago
I am delighted to hear your comments. I am just about ready to issue a beta for testing so I'll send you a copy too. I am testing it at the moment and it appears to be holding up fine. I'll be ready to send a copy by the end of the day I think.
johndoyle-admin 17 years ago
Thank you netsonicyxf, that would be a great help, I'll send you a copy in the next couple of days.
johndoyle-admin 17 years ago
Just letting you know that I am make quite a bit of progress on this issue and I am currently testing a new version of XLC. It should be ready for release within a week. The correction and modifications to the equation renderer have been extensive so I am afraid it has taken some time. I may need some help testing on Excel 2008 as I do not have a copy. However I feel confidant that if it works for Excel 2007 it will be fine for Excel 2008.
johndoyle-admin 17 years ago
I have done some tests and I think I have found a bug not in XLC but Excel 2007. I need to take this up with Microsoft. I have no idea how long it will take but I'll keep you posted of any developments. Until then I am afraid that XLC is only working with Excel versions 2000 to 2003. Thanks again for reporting this it is a very significant issue for me.
johndoyle-admin 17 years ago
I normally use Excel 2003 and everything works fine in this version. However try the same thing in Excel 2007 and I get exactly the problem you describe. Thank you for reporting this in it is certainly an Excel 2007 specific bug. I'll try to sort this out now.
johndoyle-admin 17 years ago
I have tried your problem but everything works fine for me - I have attached an image and the spreadsheet itself so that you can see what I have done. Filename [Forum887.xls](/images/fbfiles/files/Forum887.xls), size 16384 Maybe you could attach your file and I could take a look at it?
johndoyle-admin 17 years ago
I am not going to be much help here Clyde because XLC can't handle nested OVD and UND statements. The equation is rendered on two lines. I could improve on this I guess but it would take quite a bit of work and there is a work around. You are not the first to request this. Thanks for your comment.With regard to scrolling down the page to see the forum - I check that the site works with IE version 7 and Firefox/2.0.0.11 but I am aware that there are occasionally problems when content is rendered below the main menu. This looks like a blank page to the user - if this ever happens then scroll down and you'll find the content below the main menu. The joy of websites!
clyde 17 years ago
Hi John,I'm having trouble with formatting (see attached file). I'd like to know if EXCEL Calcs can format the formula like the Microsoft Equation 3.0 example (shown in the spreadsheet). By the way, I am having to scroll down to the bottom of the page on your site again.Thanks,Clyde Filename [Nested_OVD_UND.xls](/images/fbfiles/files/Nested_OVD_UND.xls), size 12800
johndoyle-admin 17 years ago
I think that you must have some internet connection problems here. I can only try to reassure you that thousands of people have managed to download and install the software correctly. Do you have access to another machine?
johndoyle-admin 17 years ago
Ivan I am glad you like XLC but I am afraid it only works for MS Excel.
johndoyle-admin 17 years ago
Well I am glad you managed to get the software working at work but I am afraid that XLC will not work with versions of MS Excel prior to Excel 2000 which is why you are having problems at home. This is covered in the FAQ section of the site.
johndoyle-admin 17 years ago
Mark - if you attach the spreadsheet I'll be glad to take a look at it. I am sure that I'll solve the problem quickly.
johndoyle-admin 17 years ago
Thanks for your suggestion JoeMiner - it would be an easy thing to implement. You are aware of the [url=/404/]
johndoyle-admin 17 years ago
Hi Digita, I rely upon users letting me know if there are any problems with the site so thank you for reporting this in. I have checked it myself and managed to download the file and run the setup.exe file with no problems. However this same problem has been reported many times but always seems to be resolved by downloading again. If it does not work after downloading again can you tell me if you can open the zip file or if you cannot can you tell me the error message.
johndoyle-admin 17 years ago
I think that you just need to [redraw](/404/) the page this will take care of all your numbering issues. Thanks to your question I have noticed that the flash help files have been deleted from the server and were not playing. This happened during a software upgrade last week but I have corrected it now. Hopefully you will now have all the help you need. Sorry for this oversight.
roofguy 17 years ago
I can't seem to reset the equation numbering. I have been tinkering with a spreadsheet to learn XLC. Everytime a make a mis-step, I delete the equation graphic and then the function. However, my sheet actually has only 2 equations and the numbering is up to 12. I can't seem to override the numbering. Am I doing something wrong?
roofguy 17 years ago
I downloaded it at home, unzipped it there, and burned the extracted files to a CD. Now I have the files on my computer at work.
johndoyle-admin 17 years ago
I have had a few reports of zip file problems. They have always been sorted simply by downloading the file again. I suggest you give it another try but if you are still having problems please get back to me.
roofguy 17 years ago
I downloaded the 09/07 Installation zip but cannot extract the exe. I get the message that it is either not standard zip format or is corrupt. I saw other threads about similar problems. Has this newer zip been installed successfully by anyone?P.S. I sent the file to our IT guy who tried to unzip it with Winzip, to no avail.
johndoyle-admin 17 years ago
Nice one Clyde - I had placed more a google ads module where the banner ads are normally placed. This was fine in Firefox (my default browser) but Explorer seemed unhappy with it. I have swapped a few things around and it seems ok in both browsers now. The joy of running a website!
clyde 17 years ago
The right side of the ExcelCalcs website is blank. I always need to scroll down to get to the information. Can this be my browser settings (Microsoft Internet Explorer 6.0)? This happens with almost all screens.
johndoyle-admin 17 years ago
Download the latest versions of XLC for incorporation of this feature.
johndoyle-admin 17 years ago
mmm... strange one this. I don't think it is a 2007 issue though. I opened your file in 2003 and hit redraw. As you say about half the equations are not drawn but on a second redraw they all appear. I look into it when I have some time but I'll probably give it a low priority it seems to sort itself out pretty quickly.Its quite a useful spreadsheet - in fact I could have used it last week for a vehicle impact assessment I am undertaking. Have you thought about uploading it?
clyde 17 years ago
Hi John,I agree with Eric. It seems to work great. There does seem to be one anomaly. When I open a 2003.xls workbook in 2007 and redraw about half of the fomulas disappear. After a repeated redraw they are OK. How do you find the time?Nice work,Clyde Filename [Example_2003-153687fdc9cc7b88333238e26c7eb321.xls](/support/forum), size 30720
johndoyle-admin 17 years ago
Can you attach the spreadsheet Jeff
johndoyle-admin 17 years ago
Can you attach a simple sample sheet with the problem. I can't seem to reproduce it here - it always works for me. As well what version of XLC and Excel are you running?
johndoyle-admin 17 years ago
You are probably right Mark and it should be easy enough to do. I'll put in in the next release. Thanks for your comment.
clyde 17 years ago
Hi John,I agree with Eric. It seems to work great. There does seem to be one anomaly. When I open a 2003.xls workbook in 2007 and redraw about half of the fomulas disappear. After a repeated redraw they are OK. How do you find the time?Nice work,Clyde Filename [Example_2003.xls](/support/forum), size 30720
johndoyle-admin 17 years ago
[Click here for XLC version 09.07 - first version to work with Excel 2007!](/404/)I would welcome some feedback before I put it up for general release - please use the forum link from the XLC 09.07 download page.CheersJohn
johndoyle-admin 17 years ago
This forum thread will track of the version history of the following download:[XLC version 09.07](/404/)
johndoyle-admin 17 years ago
Hi ClydeI think I have cracked the problem now. I have XLC equations working correctly in Excel 2007! I am running a few more checks to make sure that it does not fall down any where but I'll probably have a new XLC version compatible with Excel 2007 by the end of the day. Watch this space!
clyde 17 years ago
Hi John,I'm glad to see you are making some progress. I sent a link for the
johndoyle-admin 17 years ago
OK when I installed Excel 2007 and another machine XLC installed with no problems. So I now have exactly the same problem as you guys with the presentation of the equation objects. It seems that Excel 2007 handles graphics slightly differently to Excel 2003. I was hoping for a quick fix but I have not found one yet. At least I am getting down to the problem. Please bear with me a little longer whilst I try to sort it out.
johndoyle-admin 17 years ago
Thanks Eric for your comment. I am still having trouble getting my Excel 2007 to work with the XLC toolbar but I think this is a problem specific to one pc. I am going to install on another machine to see if I have the same problem. As soon as I get it working I think I'll be able to solve the problem pretty quickly. Please bear with me.
johndoyle-admin 17 years ago
I have managed to follow you so far and I see that both the XLC.dll com object and XLC.dll are listed as correctly installed addins. My problem is that XLC.dll creates the XLC toolbar but toolbars are not allowed in excel 2007 they have been replace by something called the ribbon.I think that I need to write some more code to generate a ribbon inequivalent of the XLC toolbar and introduce a new XLC 2007 addin which may take me some time.If you have managed to show the XLC toolbar in Excel 2007 I would be very interested in how you did this. I would be also very interested in how you managed to create equations in Excel 2007 because it has stumped me.Thanks again for your help Clyde.John
clyde 17 years ago
As stated in previous post:Office Button|Excel Options|Add-InsThe office button is the logo button in the upper left corner.
clyde 17 years ago
Hi John,I'm at work now and will have to check when I get home. Until then try
johndoyle-admin 17 years ago
Hi Clyde - I have a copy of Excel 2007 now on a new machine and I have just installed XLC. I just don't see the XLC toolbar. Toolbars are replaced in Excel 2007 with the office ribbon. can you tell me how you managed to show the XLC toolbar in 2007 it is not at all obvious to me.
johndoyle-admin 17 years ago
Its probably a bit of an oversight on my part because I rarely name cells but I understand that lots of people do. I'll give this some further thought and possibly add it to my XLC 'to do' list. Thanks for your feedback.
johndoyle-admin 17 years ago
Jeff the problem seems to be with the use of cell names. Your cell equation is:
johndoyle-admin 17 years ago
Certainly all the problems are associated with incorrect installation of two XLC files XLC.dll and XLC.xll. You try a manual installation of XLC by following the instructions [here](/404/) then you could let me know how you get on.
johndoyle-admin 17 years ago
Good - I hope you find the software useful.
johndoyle-admin 17 years ago
I am not sure if this will work for you as you may not have the rights to install manually either but you could try it and let me know how you get on.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.xll5) 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 FilesXLC unless you installed it elsewhere). Select the xlc.xll and press 'OK'. This has manually installed xlc.xll9) Close Excel and restart it again.10) If all went well when you enter
johndoyle-admin 17 years ago
XLC checks that XLC.dll and XLC.xll are present and installed as Excel addins. If they are not it will try to install them. It sound like something is going wrong with this process. Can you try the following for me1) What version of Excel are you using and what version of Windows?2) Do you have user privilege to install software?3) Have you successfully installed other Excel Addins?4) Re-install XLC5) Do you have a directory called C://program files/XLC and what files are contained there?6) Do you get a
johndoyle-admin 17 years ago
Sorry apache405 you may have misread - I am **not** intending to support Macs
johndoyle-admin 17 years ago
I am afraid that it is not written in VBA but compiled using Microsoft Visual Studio. I am not intending to support Macs I am afraid.
johndoyle-admin 17 years ago
I have no multi-language plans at the moment. I am afraid languages were not my strong point at school. I embarrassingly speak French but I am afraid my Russian is non existent.
johndoyle-admin 17 years ago
Hi sorry for not getting back sooner - I have just returned from holiday. I can't see the image attachment. Can you send me it again or a bit more information to go on?
johndoyle-admin 17 years ago
XLC is not a vba application (not a *.xla addin) it is compiled from using Microsoft visual studio, this gives it the advantage of running faster. I don't think I can compile for Macs.
johndoyle-admin 17 years ago
Hi Bridger Jeff and thanks for all your comments they are very pertinent and useful to me. There is a 255 characters string limits in XLC, this is the same as Excel's equation limit however there could well be some inconsistencies because XLC does a lot of string manipulating. In your example XLC will insert spaces between operators because this makes equations easier to read but it increases the length of the equation string. It is not an issue I have given much thought to because I have never hit a string limits problem so far. I think XLC's current limit is set above reasonable expectations of what a user might hope to get out of an equation and I can see you are pushing the program to its limits with your test equations. I will give this issue some consideration when I next get to dive into the XLC code - but at the moment I am more preoccupied with packing up for my summer holiday in Tuscany B) Thanks again Jeff
johndoyle-admin 17 years ago
I am afraid I am pretty ignorant about developing software for macs. I compile the software using microsoft compilers so I guess it probably won't be possible. Sorry apache405 that I cannot be of more help.
johndoyle-admin 17 years ago
Thanks DevanJ - You are not doing anything wrong - you have spotted a bug - I have added it to my 'To Do' list. It should be an easy fix but it may take a couple of months to get round to it I am working flat out at the moment so that I can clear my desk for my family holiday. Please bear with me and I'll let you know when I have fixed it.Thanks againJohn
johndoyle-admin 17 years ago
I am glad you have found a work around Clyde but I think I will have to get a copy of office 2007 to look into this in more detail. It could be a while though Clyde I am busy trying to clear my desk before I can get away for my holiday. Thanks again for reporting it in.
clyde 17 years ago
Hi John,Sorry to report that there is no difference in 06.07 see attached. However, I can save the 2007 (.xlsx) as a 2003 (.xls) file and use the redraw feature and all is well.Best regards,Clyde
johndoyle-admin 17 years ago
Hi ClydeI am running with Excel 2003. I have yet to upgrade to Excel 2007 so I am afraid that I cannot test this out for myself. However I think I have enough clues as to what may be going wrong from your plots. I have just added a few lines of code to XLC version 06_07 that might sort out your problem. Please download the latest version and let me know if it is any better. Thanks for reporting this in Clyde.CheersJohn
clyde 17 years ago
Hi John,ExcelCalcs is great. I've had some problems at home with formatting.I am using Windows XP and Office 2007 at home. I have Windows XP and Office 2003 at work. My problems are at home and do not show up at work.See the attached picture and file. Formatting of the formula is not working.Best regards,
johndoyle-admin 17 years ago
Without being able to replicate the error it is impossible to debug it. I am afraid all I can do is assure you that thousands of user have managed to get XLC up and running. Sorry I can't be more helpful.
johndoyle-admin 17 years ago
I have just had a play around with this, normally I log in as the windows administrator on my PC I install XLC and it appears when I start up Excel. The XLC toolbar appears as usual. I then switch user to a limited user account and start up Excel again. Excel starts but the XLC toolbar or the XLC add-in do not appear and this behaviour is what we should expect. XLC must be installed on the limited user account to work. You will need user rights to install programs or you can ask your administrator to do this for you.I hope that this helps.
johndoyle-admin 17 years ago
I have no idea what this may be. It seems very unusual and has never been reported in before. Can you run other setup.exe files?
johndoyle-admin 17 years ago
We have not had many installation issues reported in recently so thanks for letting me know your bug. Your problems sound strange so let's do a few checks to see what's happening.
1) Start Excel. Go to Tools>Add-Ins... This displays the Add-ins form and check that xlc is shown as installed. If OK then proceed.
2)Is the XLC toolbar visible? Check Excel MainMenu>View>Toolbars> and XLC Tools should show with a check mark next to it. If OK then proceed.
2) Check that XLC function are working. Type "=OVD(3)/und(6)" into a cell. If the cell returns 0.5 then XLC functions are working OK. If OK the proceed - if not install XLC.xll manually by following these instructions. 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
Let me know how you get on.
mlawson 17 years ago
awesome and easy. wish I'd had this for homework.
johndoyle-admin 17 years ago
Thanks Yogia (nice to hear from you again) - I had not noticed this either. Please bear with me, it may take some time before I can get round to fix it. I'll let you know when I do.
johndoyle-admin 17 years ago
Thankfully a quick fix - [download and reinstall version 06.07](/404/). I would be grateful if you could let me know if this resolves your problem.
johndoyle-admin 17 years ago
This is a definite bug I am afraid that I have never noticed because I set my status bar to be hidden. I'll patch it up as a priority and post a new download in the next couple of days. Please bear with me and I'll get back to you. Thanks for reporting it in.
johndoyle-admin 17 years ago
Hi ChrisI am aware of this and it is on my to do list. Its actually a little problematic but I'll nail it soon. You'll have to just bear with me until my day job calms down a bit. I'll keep you posted.
johndoyle-admin 17 years ago
Hi GregI have tested the program and the latest version is working correctly. Maybe some further explanation of how the program works is in order - it is covered in the online help under [controlling the appearance of equations](/404/). Check the EQS function in the cell underneath your equation object - if it contains 'multiplication= 1' parameter in the equation control string then multiplication signs will be shown. When you select 'show multiplication sign' from the 'about XLC and settings' form - this sets program defaults and _subsequent_ EQS() functions will contain the parameter 'multiplication= 1' but it will not change existing ones. If you want to change existing ones use Excel's Replace functions (i.e. Replace 'multiplication= 0' to 'multiplication= 1'). I hope this helps.
johndoyle-admin 17 years ago
Can you try to attach your image again it seems to be lost from this post.
johndoyle-admin 17 years ago
Yes 1) name using XLC as you have already done.2) delete the space before the
johndoyle-admin 17 years ago
I have used winzip to create it. I have checked the download and it seems fine to me. I have had quite a few posts about problems with zip files and usually downloading it again or using another zip program works.
johndoyle-admin 17 years ago
The EQS() function (EQuation Show) takes a cell reference whose formula will be rendered as an equation. So there is no reason why equations cannot be displayed below the cell containing the formula - just drag it there and hit the redraw button (equations are always rendered over the cell containing an EQS() function. The problem is with naming cells because XLC assumes that all cell names are to the left hand side of the cell that is named.Potential solutions:1) Get XLC to check if name is defined above the cell if it is not named on the left.2) Introduce a EQNAME() function which takes a cell reference as a parameter.I don't clearly see how useful this functionality would be so if iamdman could give me an insight as to what he is trying to achieve I can weigh up if it is worth developing.
johndoyle-admin 17 years ago
iamdman - Why don't you send me a sample spreadsheet of what you are trying to achieve and I'll have a think about it?
johndoyle-admin 17 years ago
Wes616, I have fixed the bug - download and install the latest version. Thanks for reporting this in - it helps to make the code more robust for all users.
johndoyle-admin 17 years ago
Zept thanks for reporting this in - I must have missed one label - it is fixed now - please download the latest version and re-install.
johndoyle-admin 17 years ago
I have done a quick test and it seems you are correct. If a named cell is one character long there must be a space before the = sign. This is a bug I'll put it on my 'ToDo' list in the mean time you will have to use
johndoyle-admin 17 years ago
If you attach your spreadsheet I'll take a closer look.
johndoyle-admin 17 years ago
Mmmm... isn't it all getting a bit complicated? I'll keep the naming functionality as it currently is but remember you can always manually reformat a name if you have any special requirements - just remember to end the name with
johndoyle-admin 17 years ago
Weird it should look like this: Judging by the number of settings you have on the form you are running an old version of XLC. Try downloading and installing the latest version I have set the colours on the form as fixed colours rather than windows system colours in the latest version 06.07 so this should fix your problem. Thanks for reporting this in Zept!
johndoyle-admin 17 years ago
Thanks for you first post zept and welcome to the site.1) The name button simply formats a cell (i.e. automatically subscripts) it appends
johndoyle-admin 17 years ago
I have corrected the 'about XLC and settings' form to shows the correct version number but I'll not ask users to download again (I think I might annoy people).Thanks again Yogi!
johndoyle-admin 17 years ago
Hi YogiI am glad you are out there helping me correct my mistakes.1) Yes the 'about XLC and settings' form shows the wrong version number - doh!2)I think 'top' and 'mid' is working as I intended but perhaps I have not explained how it works too well. When you open your 'about XLC and settings' button on the XLC toolbar you can set your EQS() equation control string preferences. So setting vertical alignment to 'top' means that _subsequent_ EQS() functions created have an EqnStyle= 0 (i.e. top vertical alignment). This will not change the display of any existing equations. The [online help](/404/) covers this topic if you need further clarification and it includes the graphic you need.Remember you can always use Excel's find/replace functions to change all occurrences of
johndoyle-admin 17 years ago
Alison it great to see XLC being used in schools so thanks for the question. XLC will not rename the Excel's Fact() function but here is a work around. Name a cell manually
johndoyle-admin 17 years ago
Not sure what happened here. I have fixed it now. Apologies.
eskelsev 17 years ago
Is there a way to remove the
johndoyle-admin 17 years ago
I can see the point in 'top' and 'mid' vertical alignment but I can't see much point in 'bottom'. I'll implement the upgrade over the weekend.
johndoyle-admin 17 years ago
Hi YogiaI think it will be possible to include a vertical align parameter. The image below shows how it could be implemented. I'll put this on my 'ToDo' list.
johndoyle-admin 17 years ago
I appreciate that this could be a problem and I have put a fix together. Now when the 'Delete XLC Functions' button is pressed a form appears allowing the user to individually select the XLC function for deletion. It also gives the user an opportunity to cancel in case the button was pressed by accident. You'll have to download and re-install XLC to get the fix.
johndoyle-admin 17 years ago
A new button called 'Delete XLC functions' has been included in XLC version 05.07. This button must be used with caution because it deletes all functions
johndoyle-admin 17 years ago
This has been included in XLC version 05.07.
johndoyle-admin 17 years ago
I am looking forward to some feedback on the first full release of XLC. Thanks in advance.
johndoyle-admin 17 years ago
A US keyboard is laid out differently to a UK keyboard or a French keyboard so it may be more difficult for some users to find the
DvdHntr 17 years ago
That's what I ended up using thanks.
johndoyle-admin 17 years ago
Yogi I have attached a simple spreadsheet displaying a formula using 3 EQS() statements with different parameters. Open it up and take a look at the three EQS statements to see how the presentation of equations can be altered by changing EQS parameters.Then hit the
johndoyle-admin 17 years ago
I tend not to name cells so I had not thought through this issue. I'll put it down on my 'todo' list and try to improve XLC in this regard.
johndoyle-admin 17 years ago
There are probably quite a few areas where we don't conform to standard mathematical notation e.g. tan^-1 will be written as ATAN(). Whilst it is feasible to rewrite certain functions I don't think I want to start because I think it could become fraught with problems and complexities. XLC equations might not always conform to mathematical standards they are at least unambiguous. I'll leave it that way for now.
johndoyle-admin 17 years ago
This is actually something I am working on at the moment. XLC has a problem if the index's name was subscripted (because a subscripted name raised as an index would be unreadable). The current work around is only to superscript numbers, as you have seen. But this is currently on my list of things to improve so subscribe to this topic and watch this space...Post edited by: JohnDoyle, at: 2007/03/30 14:24
johndoyle-admin 17 years ago
Fractions within a fraction is not available but could be intoduced at a later date. Equations could become massive though which might not be a good thing.
johndoyle-admin 17 years ago
You can restrain XLC from automatically subscripting this is cover in the online help just below the flash tutorial /content/view/52/126/.A cell entry of
DvdHntr 17 years ago
I am a structural engineer and this is a great tool to write some notes on formula.It would be better though if when naming formula you could mark items that needed superscript and not just subscript every character after the first.Also, I wish that you could show a fraction in a fraction.
johndoyle-admin 17 years ago
Thanks for your comment you have cleary read our reasons for having an expiry date on our [FAQ's page](/404/). Remember 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 so formulae in cells continue to work. Please be assured that you have nothing to loose in terms of time invested in developing your spreadsheet.
DvdHntr 17 years ago
Thanks,Pity about the fractions. I will just not format the names of the equations with XLC.
johndoyle-admin 17 years ago
The installation files have been zipped with winzip. Hundreds of people have managed to install it so far. I would try using other zip software like winrar. I know this works on my laptop and it is a free download from http://www.download.com/WinRAR/3000-2250-10007677.html Maybe there are some zip anomalies out there I had a similar post which was resolved see /component/option,com_firelboard/Itemid,106/func,view/id,62/catid,13/Let me know how you get on.Post edited by: JohnDoyle, at: 2007/03/22 14:18
johndoyle-admin 17 years ago
XLC will only draw one division line in an equation. So you can't have a fraction within a fraction. You probably need to break down the calculation into a number of parts.On your second point you can restrain XLC from automatically subscripting this is cover in the online help just below the flash tutorial. /content/view/52/126/Hope this keeps you going.
DvdHntr 17 years ago
Can I just add one more part to this?Is there a way to change the way a equation name formatted so that|fM does not subscript the M.Perhaps there is another mark to placed in to indicate that a character should be exempt from formatting (in the same way the | is used to display greek letters).
DvdHntr 17 years ago
I am trying to display a formula that has:Fsy*Ast[do-((Ast*Fsy)/(1.7*f'c*B))]Then this equation is divided by 1000000.The problem is that I want the 1000000 underneath and I can only get it to the side. I tried two pairs of OVD()/UND() but the middle pair is then displayed in the equation.
johndoyle-admin 17 years ago
Thanks for the question. In answer to the first part there are no plans to interpret the POWER() function. Generally speaking the way you input your formula will have an effect on how the equation is drawn. I am mainly worried about introducing anomalies with particular functions. For now I would keep using the '^' operator it produces a better mathematical representation.The line above the radicand (and you have taught me a new word today) only appears if the SQRT() function is nested around OVD() and UND() functions.e.g.SQRT(OVD(J10)/UND(J9))
clyde 17 years ago
See below:=(J9/4)*((J10/J9)-J11)^2 Eqn. 1=(J9/4)*POWER((J10/J9)-J11,2) Eqn. 2Both formulas do the same thing. ExcelCalcs provides two different presentations.The preferred ExcelCalcs display would be from Eqn. 1. Will ExelCalcs be able to understand Eqn. 2 in the future?Also, the square root displays the radical without the line above the radicand. In the example on the website, the line is there. And just for curiosity, will it display the index for values other than two?
johndoyle-admin 17 years ago
Carlton wroteI do not have Windows Vista installed on any of my machines or Office 2007. Has anyone out there managed to get it to run or do I need to investigate this further?
johndoyle-admin 17 years ago
Clyde askedThe short answer is yes.The longer answer is yes. All the XLC generated equations are enhanced windows metafiles (a native windows graphic) and will be stored within an excel document just like any other graphical object. If you want to send a document to a user without XLC installed the XLC functions OVD(), UND(), ODI(), UDI() & EQS() will generate a #NAME error. You can get round this by:1) Send them to ExcelCalcs to pick up a free copy of XLC!2) If you know that they do not have privileges to install software (maybe its a work machine) you can remove the functions using Excels 'Find and Replace'. The equation graphics will loose their parent EQS() definitions and the poor orphans will never be able to redrawn in response to a cell formula change - they will still hang around but they are just dumb graphics now.Post edited by: JohnDoyle, at: 2007/03/17 11:13
johndoyle-admin 17 years ago
Thanks for reporting this bug it helps us make the software more robust. When Excel starts up it triggers the XLC initialisation process. XLC checks to see if a file called XLC.xll is installed if it is not then it tries to install it. It sounds like your machine is not allowing xlc.xll to be installed and generating an error.I have done a little research into this and it seems that it is machine dependant and may be due to your security settings. Lets not get bogged down in security settings just yet and we can try to install the xlc.xll addin manually. If we achieve this then when XLC initialises it checks that the addin is installed and will not try to re-install this. Hope you are managing to follow this? Cutting to the crunch, follow these instructions:1) Start Excel (ignore the 'Add Method of AddIns class has failed') if you get it.2) Go to Tools>Add-Ins... This displays the Add-ins form and I am guessing that you will not see xlc installed.3) 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.xll4) Close Excel and restart it again. Hopefully you will not get an error message again.Let me know how you get on.
johndoyle-admin 17 years ago
You say that the file is too large to attach but the zip file should only be 327Kb which is pretty small?
johndoyle-admin 17 years ago
Hi DavidThis seems a bit strange. I have just downloaded it myself and reinstalled without a problem. Have you downloaded from this location?/component/option,com_remository/Itemid,36/func,fileinfo/id,14/Maybe you could try again but if this fails a second time I'll email you the zip file.
johndoyle-admin 17 years ago
I bow to you better knowledge yogia. I have had to just check a few things. In Office 2000, Microsoft created a new add-in architecture, called a COM Add-in, which was common to all the Office applications and the VBIDE. XLC is a COM Add-in thus it requires Excel 2000.
johndoyle-admin 17 years ago
I am sorry yogia the addin only works with Excel 2000 or later see FAQ's /content/view/30/89/The reason for this is that this is when microsoft introduced VBA into Excel (visual basic for applications) and XLC uses this functionality.
johndoyle-admin 17 years ago
Thats exactly what I did. Hopefully it's Europroof now.
johndoyle-admin 17 years ago
I have just made another tiny modification so make sure you download after I have posted this message.
johndoyle-admin 17 years ago
I have updated XLC again. The latest version should sort this problem out. Keep your comments coming they are very helpful. Thanks.
johndoyle-admin 17 years ago
Mmmm more international issues - I'll look into this. Thanks for all the great debugging work.
johndoyle-admin 17 years ago
Download XLC again - I have modified the program so that:UND() is used as the logical AND() function in German versions of MS Excel. To prevent conflicts: UDI() can be optionally used in place of UND(). and for the sake of consistency ODI() can be optionally used in place of OVD(). I have also updated the [help files](/404/)Everything appears to be working fine, please let me know if you have any problems.
johndoyle-admin 17 years ago
Can you give me a few days to work on this? I'll have a look at it over the weekend.
johndoyle-admin 17 years ago
This is a very interesting. Do you get any errors when the excel starts up due to duplication of functions? If you are inserting a cell formula and select **insert>function** is the UND() function listed once or twice? Is the OVD() function listed?I am thinking about a work around by providing another function will behave as the UND function but call it UDI().
johndoyle-admin 17 years ago
I'll send a user group mailing in case anyone else had this problem. Thanks again for reporting it Mark.Post edited by: BoJosley, at: 2007/02/27 09:40
johndoyle-admin 17 years ago
Thanks for reporting this problem. It appears that the installation was not working on some machines. I believe that I have corrected the problem and uploaded an fresh installation file. Would you mind downloading it again and letting me know how you get on?
Boffin 17 years ago
Everything should install automatically. I just ran the installation program and started up Excel. The XLC toolbar was there and everything worked fine for me.
Boffin 17 years ago
Doh! I feel a bit silly for asking now. Thanks again.Post edited by: Boffin, at: 2007/02/16 14:19
Boffin 17 years ago
I think I will be ditching MathCAD and using this instead. Then I can send my calculations to anyone then, we all have Excel whereas only a few of us have MathCAD.
johndoyle-admin 18 years ago
Mmmm I don't think so. What I tend to do is use the XLC template /component/option,com_remository/Itemid,36/func,fileinfo/id,20/ and arrange calculation cells in a vertical line. I show all equations on this page. Then I copy the equation line to the right of the page across a number of columns to make a table. Take a look at a beam bending calculations /component/option,com_remository/Itemid,36/func,fileinfo/id,17/Here I have calculated the deflection at one point and shown the calculations for this then I copy the vertical line of cell formulae to the right of the page to make a table of results for 10 points along the beam. The ten points are plotted to show the deflected shape at the end of the calculation.In this way I have managed to display the calculation method and generate a table from this. I hope this is helpful.
johndoyle-admin 18 years ago
When an equation is 'named' they are forced to end with the two character
johndoyle-admin 18 years ago
XLC does not display an equation if the cell it is referencing is just a value (i.e. it has no formula). The program does this to so it is easy to differentiate between calculation inputs (usually just values) and calculation formulae. You can over-ride this behaviour by inserting an
Boffin 18 years ago
I understand for the program help that you can't display equations if a cell has a value, it has to be a formula. Is there any way I can display just a number as an equation? Thanks for the help.Post edited by: Boffin, at: 2007/02/16 14:19
johndoyle-admin 18 years ago
The install program has been updated to automatically install XLC.xll so this should never be a problem again (hopefully).Post edited by: BoJosley, at: 2007/02/10 15:35
Boffin 18 years ago
Yes its easier than I thought it would be. Thanks for the speedy response!Post edited by: Boffin, at: 2007/02/16 14:17
johndoyle-admin 18 years ago
The equation simply takes the font attributes of the cell containing the
Boffin 18 years ago
Is it possible to change the equation font? Really elegant software by the way. I think I will be ditching MathCAD and using this instead. I can send my calculations to anyone then, we all have Excel whereas only a few of us have MathCAD.Post edited by: Boffin, at: 2007/02/16 14:16Post edited by: Boffin, at: 2007/02/16 14:19
johndoyle-admin 18 years ago
Nick I have updated the install program again and testeded it on a fresh pc. Hopefully we'll never have these difficulties in the future.
johndoyle-admin 18 years ago
Mmm Looks like I am still having problems with the install program. If you can't seem the toolbar then I think XLC.dll has not been properly registered with windows.Follow these instructions to register maually:1) goto start button and select
johndoyle-admin 18 years ago
Sorry Nick I should have explained more clearly. I emailed the new installation file to you it's called
johndoyle-admin 18 years ago
I have just posted a new installation file created with install software - Can you let me know if this works any better?
johndoyle-admin 18 years ago
Have you seen the installation tutorial? /content/view/35/91/
Web Analytics