Filename

Question

Hello&nbsp;&nbsp;I´m using the Cell(filename) function, and this is working.&nbsp;But I have 2 or more Excel sheets open, with the same formula but different file names.&nbsp;But when I work in one file, it changes the name in all other Cell(filename) functions, to the one I'm currently working in.&nbsp;Is there a way to fix this?&nbsp;

rajesh_sinha · Answer

Cell("Filename",CellRef) returns the current Workbook name,,, please share the file you are working with, will help us to examine.

mmourits · Answer

Rajesh_Sinha&nbsp;I tried this but this does not work.&nbsp;

rajesh_sinha · Answer

Better upload the workbook and mark the cell in which you have applied the formula and let me examine,,, also if possible show me the expected output.

mmourits · Answer

Rajesh_Sinha&nbsp;There is no problem when I rename and safe this file.&nbsp;But when I open 2 or more Excel files at the sam time, they all get the same name, instead of getting the name og the sheet they are used in.&nbsp;&nbsp;

rajesh_sinha · Answer

MMourits&nbsp;&nbsp;I got the issue ,, what you have to do ,,if you want to DUPLICATE it ,,, use SAVE as and assign another name,, rather then RENAME it.&nbsp;&nbsp;And even you have RENAME it then also it works ,,,, what I have noticed when open the file cell has ### is problem with width,,, or you just select cell E1 press F2 and finish with Ctrl+Shift+Enter.&nbsp;Check I've loaded files are 3,,, 1 is yours 2nd is after SAVED as 3 is RENAME ,, all are working.&nbsp;In case if U open all 3 together and finds the issue ,,,&nbsp;just select cell E1 press F2 and finish with Ctrl+Shift+Enter.Let me find out a smart solution the I'll return soon to U.&nbsp;

Forum Discussion

Filename

8 Replies

Resources