Disable vlookup formula for an excel sheet (Emergency)

[ekram]

Hi all, I am extremely needed a help to disable vlookup function on my excel workbook. Any how I need to disable it . It is so much urgent , so , please help me to do this.

[rossg]

copy then right click, paste special, paste value

alternatively click into the formulas ribbon (at the top) then in calculation options click manual....



depends what your trying to do really

[ekram]

Thanks rossg, but it doesn't work. I actually need to disable vlookup , lookup and other formulas like these formulas for a file permanently . I need this very urgently .

[dredwolf]

there are many formula's that work this way...disabling all of them is not a 2 minute fix...

[dredwolf]

if this is a security issue, rename the workbook(s) and protect the workbooks with passwords....other than that, I am not sure what else you can do

[ekram]

Thanks dredwolf, in this way other file can't link my file , but I want to disable formulas in my files.
Suppose , my file is test.xls/test.xlsx , I want to disable these formulas for test.xls/test.xlsx.

Is there any way?

[dredwolf]

I cannot think of any way to disable specific formulas in Excel, after all, that is what the Program is all about...there may be a way to do it, but I have never heard about or seen it done, sorry

[arlu1201]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.