Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel 97 - updating links on file open returns #N/A
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...- pdem
- Thread
- Replies: 5
- Forum: Microsoft: Office
-
Excel 97 - how to change message when protected cell is used
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...- pdem
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
