psctornado
06-23-2015, 05:06 AM
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 )
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 )