formulas changing on their own within a protected sheet

[malagash]

I have a workbook with three pages that I use for my bakery. The first page is an Order sheet where I enter the orders that are called in to me. The second is a Delivery Slip. I enter the quantity delivered for a given item adn that number is compared to the quantity ordered for that item to make sure that I am sending the right amount. The third page is the Invoice which takes the amount shipped from the Delivery Slip and calculates the amount due for each line item. Formulas on pages 2 and 3 look for data from previous pages.

For some reason and, with no regularity formulas from some cells disappear. The cells with formulas are locked and the pages are protected. The computer is running Win 2000Pro and is fully updated, not conencted to the internet and is on a battery backup.

I cannot understand why this would happen randomly and without warning. If anyone can give me a clue I would appreciate it.

Thanks

 

[malagash]

Should mention that it is Office 2003

 

[SkipVought]

hi,

Do you have any macro's running in this application?

Do you have to Enable Macros, when your workbook opens?

Did someone else design this application? If so, your workbook could be running event-initiated code, that unprotects sheets, modifies cells that are locked and then protect the sheets.


Skip,

_[red][/red]

 

[malagash]

No Macros and I built the application

"could be running event-initiated code" -- could you explain this one?

Thanks Skip

 

[SkipVought]

I you made the application and there are no macros, there would be no event-initiated code that would delete anything.

Try Help/Detect and repair

Skip,

_[red][/red]

 

[malagash]

I think that will be the next move if not a total uninstall/reinstall.
Thanks

 

[buitenhek]

Take each page (click between A and 1 to get entire page highlighted)and go to Format-Protection. Check both locked and hidden.

Go back to page and selectively highlight each cell you want to able to change and remove the locked/hidden protection. Obviously do not give any formula cell this privilege.

Go to Tools and select Protection. Make sure only 1 check mark for unlocked cells only. Now lock the sheet.

Do this for each sheet.

Note: you can lock each worksheet with or without a password. Try locking a troublesome worksheet with a password only you know. I predict you will not have anymore inadvertent formula changes.

Regards
Peter Buitenhek
ProfitDeveloper.com

 

[malagash]

Thanks Peter I shall give that a go