I have a spreadsheet that calculates delivery forecast by week. I have 24
weeks.
The user enters the customer's weekly demand and it autocalculates how many
they have on hand and how much we need to send in order to meet the demand.
The user is suppose to just enter what the inventory on hand is and their
weekly demands. The spreadsheet has formulas that calculates whether they
have enough inventory or tells the user how many to send at a given week to
meet the demand.
It works great in my computer but when I send it to someone else via email
and they start to enter their information, they get a #NAME? error in all the
cells that have the formulas.
I tried sending the spreadsheet with selected cells locked, the formula's
hidden and the worksheet protected. Then I tried sending it totally
unlocked, unhidden and unprotected and was getting the same error.
The formulas are correct and it works in my computer, but when I send it
someone else, it gives that error.
We checked the formatting and all are the same. What gives?
Thank you for all of your help.