External Links - How to remove user name?

[psctornado]

Hi All,

Would anyone have a suggestion as to how one can remove user names from a formula. Essentially I have a shared workbook, that is launched via a bat file, and is used by several people. Other than myself, all other users are getting an 'external links' pop up when launching the workbook.

Upon checking it out, I found that a handful of cells that have the user name, then formula ahead of it. Is there a way to save the workbook so that the username / link is not ahead of the actual formula?

example :

="C:\User\B123456\ValueDisc( C259, C260, C261, C262, C263, C264, C265, C266, C267 )"

Ideally, I would like it show just :

=ValueDisc( C259, C260, C261, C262, C263, C264, C265, C266, C267 )

[psctornado]

[psctornado]

Anyone have any thoughts?

[Paul_Hossler]

Are you sure the formula(s) don't look like this?

='C:\User\B123456.xlsm'!ValueDisc( C259, C260, C261, C262, C263, C264, C265, C266, C267 )

[SamT]

Let's see the Batch file?

[snb]

I lost a lot of thoughts recently. Still trying to recollect them.