Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Problem resolved. I found after I closed the spreadsheet and reopened it the values appeared. May have been that the tools options settings did not apply themselves to the spreadsheet until after it had been shut down.