Hello Everyone, I am not a professional excel user nor do I have loads of experience with troubleshooting it. I am a café supervisor and use a worksheet to tally up the registers at the end of the day. I have been using this worksheet for years the person whom created it is no longer here. I seriously cannot get the calendar to work anymore. I've tried right clicking it to try and see the properties. I have attached the worksheet if anyone can step by step help me with this..
Thanks!!
Do you have an older file which is functional before the corruption?
If not, then you'll need to first identify and fix the below #REF! (reference) errors in the below fields (within the Bank - OUT worksheet)
- Cell: L13 | Error: =INDEX($M$2:$X$10,MATCH($U$1,#REF!,0),1) listed behind the calendar
- Cell: BG19 | Error: =#REF!
- Cell: BG25 | Error: =#REF!
- Cell: BG29 | Error: =BG19+BG20 (fix BG19)
- Cell: BH37: Error: =IF($J$20>500,#REF!," ")
As for the calendar, you'll need to indentify the missing info which belongs between the two quotes (see below)
- Calendar: error: =EMBED("","") something should be listed here =EMBED("MISSING INFO"
Update: Investing further: after removing the background color, I noticed another form starting at AB101:AT155
Last edited by Syrkrasi; 08-07-2017 at 02:04 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks