In this section we give additional information about Excel capabilities not described in Excel Environment.

Topics:

- Built in Excel functions
- Built in Excel statistical functions
- Data conversion and reformatting
- Table lookup
- Special charting capabilities
- Keyboard shortcuts

HELLO

I Aslam one enquiry abt excel i had cretaed one workbook having more than 500 sheet and in one sheet 100 to 1200 columns are using to save data is there any limited capability for excel workbook if so how much thus did i lose my date

Hello Aslam,

Sorry, but I don’t know the limits on the number of sheets in an Excel workbook. I would think this this is largely governed by the amount of memory available.

Charles

Hi,

I am trying to automate the binary logistic regression function from your add-in. I have several tables that I need it to be run on (over 10). Is there a way to use Excel VBA code to automate the binary logistic regression?

Thank you for your help and please let me know if you need any additional information.

Thanks,

Justin

I should mention that the data in the tables will be changing, hence the reason for needing it automated. I am trying to avoid running the binary logistic regression manually every single time the data changes. Thanks.

Justin,

See the following webpage

http://www.real-statistics.com/real-statistics-environment/calling-real-statistics-functions-in-vba/

Charles