Excel Filenames issue
Posted on 2011-03-21
Good afternoon, we have a user and when he has two excel spreadsheets open at a time and goes to print, the file name will be the same on both documents. I know a good fix to this solution is to shut down one of the excel files, but this is difficult when the user is trying to compare documents. His explanation of the issue is below:
When using =cell("filename") in a cell, while printing, the name and path printed is not correct if more than one excel document is open.
Any help would be great!