A quick question about Excel

astina

We often save files somewhere but later on can’t find where they are. What I used to was to leave a link on the cover page that I printed and filed. Then if I can’t find a file, I would look for the hard copy from which I can easily see the directory and then digged it out from a million layers underneath.

So the question is: what is the command to leave the link? I vaguely remember it is sth like =path(“cell”) but couldn’t figure it out exactly. Haven’t used this for quite a while. Can any one help?

Thanks

jasonliu234

page setup - header & footer - cutomer footer - insert file path

jasonliu234

insert file path 是一个像文件夹的icon

astina

great it works.

But I am still curious what is the command I remember. Tried =path(“file”) but not working

大饼

推荐一个微软小工具。
可以自动生成某个目录下所有文件的列表
http://www.finrepinc.com/prod02.htm

astina

原帖由 大饼 于 2008-7-24 10:30 发表
推荐一个微软小工具。
可以自动生成某个目录下所有文件的列表
http://www.finrepinc.com/prod02.htm

Thanks triangle cat. This looks awesome.

大饼

I don't use such tools at all. As long as the file is in PC and you name the file properly, you can use search *.xls to find it.
But my wife,she needs it.

jasonliu234

=INFO("directory")

astina

I usually rely on my own memory but this new place is hopeless. They have a million files located at thousands of different layers. The guy sitting to me still finds it painful to locate a file after working here for 18 months.

astina

原帖由 jasonliu234 于 2008-7-24 10:40 发表
=INFO("directory")

this is what I was after.

Thanks a lot

xingbu

我也是用insert file parth.

=INFO("directory")

在那里输入才会显示directory啊？

astina

you can put in any cell you like . Give it a try and you will see.

典

Your company needs MS Sharepoint

chengzhuang

I like to use the toolbar: web.. right click on the menu list choose web, you could see the directory.

xingbu

原帖由 astina 于 2008-7-24 12:23 发表
you can put in any cell you like . Give it a try and you will see.

that's awesome!

it works!

麦嘟

But I just get the result of :C:\Program Files\Microsoft Office\Office12\        " ??

astina

One more question: for word and ppt documents, how do I know and record their directory?

FRED

For "MS Word"

insert  -> field   
Categaries -> Document information
Field names -> FileName
Field properties -> none
tick "Add path to filename"
OK

joaquin

我一般是用footer

不过新公司的文件系统完全不一样，根本hijack了office……这下footer不能用了，郁闷

xingbu

原帖由 FRED 于 2008-7-24 15:36 发表
For "MS Word"

insert  -> field   
Categaries -> Document information
Field names -> FileName
Field properties -> none
tick "Add path to filename"
OK

word 2007里找不到insert-field

FRED

2007 没用过
2003 是可以的

xingbu

I hate Office 2007

大饼

我一直没搞明白在文件里面放一个 path有啥用

xingbu

阿斯不是说了方便她在电脑里找不到文件的时候可以看hard copy上的路径从而知道存在哪里麻！

大饼

原帖由 xingbu 于 2008-7-24 16:12 发表
阿斯不是说了方便她在电脑里找不到文件的时候可以看hard copy上的路径从而知道存在哪里麻！

每个文件都弄个hardcopy？

Ausbear

If you know the file name, you can always search it in file explorer, by right click the root folder and serch.

Sometimes I use dos window, then type "dir /s filename.xls"

Ausbear

原帖由 astina 于 2008-7-24 14:11 发表
One more question: for word and ppt documents, how do I know and record their directory?

for word, click "cntrl -k " then click "file" to browse and choose the file.

小昭

=CELL("filename")

jasonliu234

原帖由 xingbu 于 2008-7-24 16:01 发表


word 2007里找不到insert-field

有的
insert - quick parts - fields

quick parts 在text box 又上

bulaohu

There are already many solutions to this file housekeeping problem. The most famous approach now, is by Google: "search, don't sort." A GSA (Google Search Appliance) will index all files it can find on a company's internal network so that no matter where they're, they can be located quickly and easily.

http://www.google.com.au/enterprise/gsa/product_models.html