Errors created in executable file - SOLVED

D

dfoliver

New member
I created a workbook containing 5 sheets with no macros and 2 buttons containing hyperlinks. I’m using Excel 2007 (v12) on Windows 10 Pro. After creating my executable file using xlspadlock the workbook contains both errors (#VALUE) and strange totals in cells using the “SUM” function. The cells that are summed are blank. What am I doing wrong? Thanks for your help.
 
Last edited:
Thanks much. All is fixed. Seems I was protecting way too many formulas. I instead opted to use the “Protect Worksheet” facility in Excel and protected and hid all necessary formulas. Works well and lasts a long time as they say.

Dave O
 
Hi @gdgsupport, I too have never used the protect formula feature until today, but was shocked when SUM doesn’t work. It’s okay that it doesn’t but do you have a cheat sheet of which functions won’t work? The pdf documentation only lists INDIRECT function and advises against data validation, doesn’t say which formulas to avoid.

Thanks
Dan
 
So it seems the formulas DO work, but they show up as “ERROR” unless the user double clicks on them and then presses Enter. Why do you suppose this is happening?

50%20PM

50%20PMa

50%20PMb

53%20PM

Then when I protect and open protected version:
00%20PM

Then I must double click each formula…
56%20PM

Thanks

Dan
 
Apologies for the delay. There’s an advanced setting I stumbled upon to calculate all formulas upon workbook opening, which recalculated these and the error went away. I suppose my setup was one of the perfect storms that this advanced setting was created for.

Thanks

Dan
 
Last edited:
You must log in or register to reply here.
Back
Top