Some random questions, can't find anything that answers these specifically so apologies if they have already been answered.
I work with an awful lot of vlookup queries, however sometimes when vlooking up from one workbook to another, when I drag for a table array it doesn't work, I get no broken lines and nothing fills my vlookup function wizard. The only way I have around this is to copy all of the data in a sheet into a blank sheet in the same workbook I am using (I lookup from many workbooks). It seems to occur randomly, I assume this is down to some formatting somewhere but for the life of my I can't find consistent instances of this to diagnose.
Conditional formatting - is there any way to see what cells have any conditions assigned to them without having to click and go through every single cell?
Security - I have a document that only myself and a few other people should edit, that many can access. Tools > Options > Security gives me the option to require a password to modify which is exactly what I want, however this happens as a user opens the document. I ideally want them to have to enter a password to save it when they're done.
On a different problem I'm locking a lot of cells and only allowing a few columns to be unlocked (with the parameters of select unlocked cells). I'm also allowing auto filter, but on potentially a huge amount of data, the Find function is key but this doesn't seem to work on locked cells. Is there any easy way round this?
Many thanks,
I work with an awful lot of vlookup queries, however sometimes when vlooking up from one workbook to another, when I drag for a table array it doesn't work, I get no broken lines and nothing fills my vlookup function wizard. The only way I have around this is to copy all of the data in a sheet into a blank sheet in the same workbook I am using (I lookup from many workbooks). It seems to occur randomly, I assume this is down to some formatting somewhere but for the life of my I can't find consistent instances of this to diagnose.
Conditional formatting - is there any way to see what cells have any conditions assigned to them without having to click and go through every single cell?
Security - I have a document that only myself and a few other people should edit, that many can access. Tools > Options > Security gives me the option to require a password to modify which is exactly what I want, however this happens as a user opens the document. I ideally want them to have to enter a password to save it when they're done.
On a different problem I'm locking a lot of cells and only allowing a few columns to be unlocked (with the parameters of select unlocked cells). I'm also allowing auto filter, but on potentially a huge amount of data, the Find function is key but this doesn't seem to work on locked cells. Is there any easy way round this?
Many thanks,