AddIn Default Path - Moving Spreadsheed between Users/Computers

J

John C. Liss

When moving a spreadsheet between two users on two different PCs the cells
containing any AddIn functions get changed/modified preventing seemless
operation.

Steps:
1. A spreadsheet is created with cells which call out a functions contained
in AddIn
2. The spreadsheet is saved, and when re-opened on the same PC all is Ok!
3. Spreadsheet is opened by another user on a different PC, a message is
display stating an invalid path exists on the AddIn links
4. Regardless of if I use the default paths or force a path (say
"C:\AddIn") the message always comes up when the spreadsheet has been saved
on one PC then moved to another.

How can this be configured to be seemless when passing a file between
several users>

Thanks in advance,
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Differences Between Two Spreadsheets ? 2
Hyperlink File Path Changes. Hair loss imminent. 4
Connection between Solver add-in and file path code 0
How can I Lock a Link? 0
copying VBA from one Excel file to another 1
Problem distributing User Defined Function 3
Using .NET and C# for Excel addin functions 1
Excel can't open some spreadsheets sometimes (so very very odd) 1

Top