ExcelCalcs Trailblazers
I have been chasing up feedback from new users signing up to XLC Pro accounts in the last month. I am delighted with their positive feedback. “I started using XLC but I am now insisting that my whole team use the add-in .“ “It is a great tool for validation and pres...









US +1 617 5008224
Toll Free:


Comments
The workbook depends on two other workbooks:
1) schTechLib
2) schStruMtrl
can find hyperlinks to above.
These files need to be placed in shared documents folder in subfolder ExelCalcs (note spelling error: not Excel)
The material file in a further subfolder materials.
When the workbook is opened, go to edit/links menu option and open the source files. If necessary adjust the locations if want to place the workbooks somewhere else. Note the workbook needs to be on the c drive. If not then Excel will adjust all link paths by changing the drive reference.
If schStruMtrl is not open then the drop down lists will not work. Strictly Excel 2003 does not permit creating drop down validation lists to data in other workbooks. But it doesn't stop moving worksheets or copying cells. So central library files can be created, just a hindrance to use. Need to use Excel/SaveAs menu option, to save file to another drive, without automatic change of link paths.
on first input line on Section.
No izes shown
What am I doing wrong?
RSS feed for comments to this post