Link to home
Start Free TrialLog in
Avatar of kb5ozcjwb
kb5ozcjwb

asked on

Notify "Read Only", "Notify", "Cancel" does not work

In a network environment, opening an Excel workbook that is already opened by
someone else, prompts me with a choice of "Open as Read-Only, or choose
Notify to be alerted when it is available". Although I choose "Notify", I do
not receive any notification when the file is closed. Is there a setting
within MS Office that needs to be configured for this feature to work?

I'm using 2010 and saving in 2003 format the rest of the user are on 2003.
Avatar of jppinto
jppinto
Flag of Portugal image

Here's the formula for the first year:

=SUMPRODUCT((YEAR($A$1:$A$29)=YEAR(A31))*($B$1:$B$29))

Please take a look at the attached file.

jppinto
formula-filter-year.xls
Wrong post! Please ignore.

jppinto
Avatar of kb5ozcjwb
kb5ozcjwb

ASKER

Anyone?
Anyone?

Can someone point me in the right direction?
bump
Anyone up for the challenge?
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Also do wait several minutes before giving up.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.