computer name instead of drive letter

[Chrissirhc]

Hi,

When I save a sheet down on my PC on the c:\ drive and then give the sheet to someone else, the UDFs that were just =Myfunc("Apples") turn into =\\mycomputerName\directory\functions.xla!myfunc("apples").

Any ideas why this happens and it could be prevented?

Thanks,

Chris

 

[DirkStruan]

Hi Chris

Aren't you using functions from an add-in (.xla) that the other users haven't got set up on their machines?

If so, getting them to goto Tools/Add ins (/browse... I guess) and "installing" the .xla file should make the UDFs readily available to them and get rid of the pathname in the cells.


Dirk

Everything useful perishes through use....Should I not rejoice at being useless?

 

[Chrissirhc]

No the other users have it on their machine in the exact same location c:\ (obviously their machine name is different). Which is what is very strange about this issue. This seems to happen accross quite a few of the addins and I'm wondering what the underlying issue is...

Thanks.

 

[combo]

Is the add-in installed while the file is saving/opening?
You can try to save add-in in global add-ins folder, search for 'Program Files\Microsoft Office\..\Library'.

combo

 

[Chrissirhc]

Sorry Combo I don't quite understand. However the addin has to be in a specific location. In previous places I've worked the addins have been in similar locations on the c:\ and this has not caused this issue...

Could you clarify what you mean the addin installed?

Thanks a lot,

Chris

 

[combo]

There are two default locations for the add-in:
- global: where MS excel add-ins are,
- local: user personal profile, where excel points you when you try to save workbook as an add-in.
Files in both sites are visible as available add-ins when you choose Tools>Addins... However, you are free to save it anywhere, or point new 'xla' file from anywhere.

In the add-ins box you can tick or untick given add-in. This process means installation or uninstallation of the add-in. The appropriate add-in file is opened or closed. Installed add-in files are automatically opened on excel startup.

You can open an add-in as regular workbook, however it will have no window. For excel application it will be a regular workbook (more or less).

The ideas behind my post are:
- was the source add-in with your UDF installed properly in both cases, i.e. when you saved the workbook and user opened it? In this case you could be sure that you use the same source of UDF.
- try to keep (copy) your add-in in the global place, should be available for all users from one place/path.

combo

 

[Chrissirhc]

If I pick a sheet up from someone elses share on the c:\ references to ranges on that sheet are also prefixed with \\machinename\filename!range

Why is this? Hasn't happened to me at other places...

Thanks,

Chris

 

[combo]

Chris,
are you suprised that within the network regime references to closed files use URI standard? For opened files there reference is '[FileName.(xls)]SheetName'Address, it changes when you close the source the path is added, either 'DriveLetter:\FullPath' for local files or '\\ServerName\FullPath' for external ones.

combo

 

[Chrissirhc]

The file is local (i.e. on the c:\ drive). Is there any way to make it reference c:\ when you save it rather than the machine name? What in the environment is making that happen?

Thanks,

Chris

 

[Chrissirhc]

Any ideas on this?

Thanks,

Chris

 

[Chrissirhc]

Does anyone have any ideas about this? Maybe it is an Excel setting?