Search results for query: *

Glenn I checked all the files, the file type is "Excel Workbook Workbook (*.xls). This is the default line. Further down the list I see Excel 95/5.0 Workbook and EXcel 97/95/5.0 workbook, but none of my files were saved under these options. I tried to experiment by saving a file under Excel 97...

Hi Glenn Yes all my files are saved as workbooks. The subfiles were all based on one file, which I saved under 10 different names. They were then modified by adding or deleting a few lines as necessary (and changing data). I thought that I might have formatted the source cell as text or...

My summary file links to 10 subfiles. When I open the summary file and update the links, certain links return #N/A. I have also tried automatically updating links in Tools, options, edit with the same results. The formula in cell B24 is ='H:\[PO 6769.xls]Summary'!B3 which returns #N/A instead...

Found it at thread707-522755 My law (as opposed to Murphy's) is that I find the answer immediately after I ask the question. I am going to stop spending hours researching...

I have created a "Data Form Button" for users to enter data. My worksheet involves formulas. As I have not found a way to protect the formulas when using data forms, the users, in spite of repeated training, insist on typing directly in the cells, overwriting vlookups, etc. My...