Forum Discussion
Solved
Excel file changing formula for SharePoint location
I have a formula for a quote system for our sales team. I have had it in place for a couple of years with updates. I have an index function that looks up our centrally stored price list, one formula ...
fuelforce Perhaps silly to suggest, but do you happen to have the Pricing sheet open? Because, then Excel will only show you the workbook name in the formula. Close the Pricing file and you should see the entire file path.
fuelforce Perhaps silly to suggest, but do you happen to have the Pricing sheet open? Because, then Excel will only show you the workbook name in the formula. Close the Pricing file and you should see the entire file path.
Riny_van_Eekelen That was the issue!! Thanks. I didn't realize Excel would do that with an open sheet. Saved my bacon there!
