Hi,
Need some help on below:-
There is 5 different folders containing many excel sheets and all are password protected.
I created a sheet to pull certain data from files from all 5 folders (files are named date wise)
Made a column with heading “date 1” and linked required data to populate from all 5folder. (Linking was done this way- openes both the sheets, “=“ and clicked on the cell on other sheet)
Once date 1 was linked.
I copy pasted the same formula under “date 2” and all i have to do is to replace the date which shows in the formula, once i hit replace it keeps on asking password of the linked file. (It works smooth with non protected files)
Is there a way to deal with this… like it should not ask me password.
Need some help on below:-
There is 5 different folders containing many excel sheets and all are password protected.
I created a sheet to pull certain data from files from all 5 folders (files are named date wise)
Made a column with heading “date 1” and linked required data to populate from all 5folder. (Linking was done this way- openes both the sheets, “=“ and clicked on the cell on other sheet)
Once date 1 was linked.
I copy pasted the same formula under “date 2” and all i have to do is to replace the date which shows in the formula, once i hit replace it keeps on asking password of the linked file. (It works smooth with non protected files)
Is there a way to deal with this… like it should not ask me password.
