LinkBack URL
About LinkBacks
it_electronics2000 
I received a worksheet from Excel Forum the result of all cells showing correctly but
when i click on enable editing so the whole formula cells shows #VALUE Error how
can i resolve it.
I received a worksheet from Excel Forum the result of all cells showing correctly but
when i click on enable editing so the whole formula cells shows #VALUE Error how
can i resolve it.
Last edited by it_electronics2000; 10-07-2013 at 05:16 AM.
Please try this updated file.
Please click 'Add reputation', if my answer helped you.
41579 shows in A42 either C46 Text Value and A6 shows Red color either Normal White color in background.
Please replace with the below mentioned formula in A42
=CONCATENATE(ptrName,"'s Time Sheet for ")&TEXT(ptrPeriod,"mmmm, yyyy")
Last edited by ramananhrm; 10-07-2013 at 06:04 AM.
Does this mean I have to find an error in the sheet? I am trying to use an Excel Template for Daily Work Schedule. I also get Value error when I enable editing but surely there is no error on excel's own template?Originally Posted by ramananhrm
Template is in link below. The DAY(DATEVAL) formula in B£ returns an error when the date is changed using the drop down menus.
http://office.microsoft.com/en-gb/ct...n=15&Result=2#
Nice Work ! Thank you so much Ramman Dhanewaad !
Does this mean I have to find an error in the sheet? I am trying to use an Excel Template for Daily Work Schedule. I also get Value error when I enable editing but surely there is no error on excel's own template?
Template is in link below. The DAY(DATEVAL) formula in B3 returns an error when the date is changed using the drop down menus.
http://office.microsoft.com/en-gb/ct...n=15&Result=2#
mullatron,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks