When I use the above function with more than one Excel File open, then both
files end up with the same file name.
I live with more than one file open, and I am constantly going back & forth
correcting the file name.  Is there any way to get the file name & path in

My calculated field in a pivot table does not summarize by average. Excel
allows me to change field setting to average, and the title changes to
“Average of filed1”, but actual calculated value is still the sum not the
average. Is this a bug in Excel?

I am getting a error message:  To prevent loss of Data, Excel cannot shift
nonblank cells off the worksheet etc.  Never saw this before