how to find where is the current file saved
 

Is there an easy way to find out where is the current openning file saved?

how to find where is the current file saved
 

You could go to

File -- Properties -- Tab "General" -- Location

hth

Carlo

On Dec 5, 2:19 pm, Holly wrote:
Is there an easy way to find out where is the current openning file saved?

how to find where is the current file saved
 

Holly,

Try this in a cell:-

Simplest and give savepath, workbook name and worksheet
=CELL("Filename")

A bit longer but information is limited to savepath
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1)) - 2)

Mike



"Holly" wrote:

Is there an easy way to find out where is the current openning file saved?

how to find where is the current file saved
 

It's a good idea to use:
=CELL("Filename",A1)
instead of
=CELL("Filename")

A1 can be any cell in the worksheet. I use the cell containing the formula.

Without that reference, then that formula will return the information from the
activeworkbook/worksheet when excel recalculated.



Mike H wrote:

Holly,

Try this in a cell:-

Simplest and give savepath, workbook name and worksheet
=CELL("Filename")

A bit longer but information is limited to savepath
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1)) - 2)

Mike

"Holly" wrote:

Is there an easy way to find out where is the current openning file saved?

--

Dave Peterson