ericcellis
New Member
- Joined
- Nov 25, 2010
- Messages
- 10
Hello,
I have an excel workbook that grabs data from another workbook. I run a family business and my wife and daughter need access to the file too. So the workbook is shared. The problem I am having is excel is changing the path inside cells, and thus making them not work properly.
Here is how the cell should be:
=IF(ISNA(VLOOKUP($A4086,'C:\_excelfiles\inventory\[Inventory.xlsx]Pull Sheet'!$B$1:$P$65536,6,FALSE)),"0",VLOOKUP($A4086,'C:\_excelfiles\inventory\[Inventory.xlsx]Pull Sheet'!$B$1:$P$65536,6,FALSE))
After someone else on the network opens the excel workbook while shared the cell changes to:
=IF(ISNA(VLOOKUP($A4086,'\\eric\_excelfiles\inventory\[Inventory.xlsx]Pull Sheet'!$B$1:$P$65536,6,FALSE)),"0",VLOOKUP($A4086,'\\eric\_excelfiles\inventory\[Inventory.xlsx]Pull Sheet'!$B$1:$P$65536,6,FALSE))
How can I keep the path from being changed as the cell doesn't update properly when it has the network path?
I have an excel workbook that grabs data from another workbook. I run a family business and my wife and daughter need access to the file too. So the workbook is shared. The problem I am having is excel is changing the path inside cells, and thus making them not work properly.
Here is how the cell should be:
=IF(ISNA(VLOOKUP($A4086,'C:\_excelfiles\inventory\[Inventory.xlsx]Pull Sheet'!$B$1:$P$65536,6,FALSE)),"0",VLOOKUP($A4086,'C:\_excelfiles\inventory\[Inventory.xlsx]Pull Sheet'!$B$1:$P$65536,6,FALSE))
After someone else on the network opens the excel workbook while shared the cell changes to:
=IF(ISNA(VLOOKUP($A4086,'\\eric\_excelfiles\inventory\[Inventory.xlsx]Pull Sheet'!$B$1:$P$65536,6,FALSE)),"0",VLOOKUP($A4086,'\\eric\_excelfiles\inventory\[Inventory.xlsx]Pull Sheet'!$B$1:$P$65536,6,FALSE))
How can I keep the path from being changed as the cell doesn't update properly when it has the network path?
