hi, every time I open a workbook, it ask me to edit sources , that the values cannot be updated, is there a way to prevent this or to automate it?
hi, every time I open a workbook, it ask me to edit sources , that the values cannot be updated, is there a way to prevent this or to automate it?
Is there a link (that you know of ) to another workbook?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
oh yes, there are 4 columns that refers to another workbook. but I don't know how I can automated to update the links because everytime I open the sheet, it asked me.
I dont think you can stop it from asking that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks