What's the trick to get Conbeam to work
What's the trick to get Conbeam to work
(OP)
Hopefully IDS/Doug sees this, or maybe someone else has run into this.
I downloaded Doug's ConbeamU spreadsheet, but for the life of me I can't repeat any results. Is there a "calculate" or "solver" macro command that needs to be run?
This looks like a useful tool, if I could get it run.
I downloaded Doug's ConbeamU spreadsheet, but for the life of me I can't repeat any results. Is there a "calculate" or "solver" macro command that needs to be run?
This looks like a useful tool, if I could get it run.
RE: What's the trick to get Conbeam to work
It should just auto-recalc when you change any input cell, but I'll have a look and get back to you.
It may be something to do with the new Excel automatic array feature. What version are you using?
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: What's the trick to get Conbeam to work
RE: What's the trick to get Conbeam to work
I meant what version of Excel, and does it support dynamic arrays?
The problem most likely is with the dynamic arrays, so I have attached a copy with all the output arrays converted back to static array format.
For documentation see the Functions sheet for brief documentation of each function, and the Using Array Functions sheet for more details on using static arrays.
Also search the blog for ConbeamU for numerous articles on the development of the spreadsheet.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: What's the trick to get Conbeam to work
Microsoft® Excel® for Microsoft 365 MSO (Version 2301 Build 16.0.16026.20002) 64-bit
I tried the linked file. Same thing happened. I changed one cell, and everything went blank.
RE: What's the trick to get Conbeam to work
Do all the output ranges on the other sheets go blank, or just the sheet where you change the input?
Which worksheet are you using?
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: What's the trick to get Conbeam to work
RE: What's the trick to get Conbeam to work
Do other spreadsheets with VBA code from external sources work for you?
If you press Alt-F11 does it display the VBA code?
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: What's the trick to get Conbeam to work
https://techcommunity.microsoft.com/t5/excel/udf-n...
It's not very helpful, but a few things to check:
1. You are not using the on-line Excel (it doesn't support VBA)
2. The spreadsheet is not being run from a Download folder.
3. It is being run from a trusted location.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: What's the trick to get Conbeam to work
RE: What's the trick to get Conbeam to work
Looks like I missed that yesterday.
What did you have to do to unblock the macros?
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: What's the trick to get Conbeam to work