It sounds like the developer of your document applied Calculation Conditions to some of the object, and replaced the standard Error Message "Calculation Condition Unfulfilled" with a custom error message "please tighten your selection".
If this is the case, it was done on purpose, to avoid heavy calculations on long lists. If you'd like to modify these behaviors, open Object Properties, General tab, and revise the Calculation Condition.
thanks for clarifying my message, but the setting that you have circled is not quite that.
The Calculation Condition should contain a Boolean condition that limits the amount of data. For example:
Then, the text "Please tighten your selections" would be found under "Error Messages" - the button located at the bottom of the screen in your image. This would be an overriding message for the standard message "Calculation Condition Unfulfilled".