Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
x
or
x
Register  \/ 
x

or
×

file Unable to open a filter settings scenario

More
6 months 3 weeks ago #3495 by lamathers
Replied by lamathers on topic Unable to open a filter settings scenario
Same problem. I cannot save a filter scenario that can be reused. I have to create all scenarios from scratch each time I use the same workbook. I can save the scenarios but can't use them. Each time the error message comes up "Before opening a filter settings scenario, you must open a workbook first." This has been an ongoing problem through many upgrades of Kutools and Office 365. Very annoying. I have to recreate complex filtering every time I open and use the same spreadsheet every day. I've tried everything I can think of to get around this problem, it keeps occurring. Recreating spreadsheets, deleting every saved scenario, etc. Sometimes, it will work with a new spreadsheet. But after a couple of saves, the problem occurs and any saved scenarios are unusable and have to be created from scratch. Super Filter does not recognize there is an open workbook while working in an open workbook. 

Thanks for any help on this. 

Please Log in or Create an account to join the conversation.

More
2 years 2 months ago #1917 by khvitaliy
Replied by khvitaliy on topic Unable to open a filter settings scenario
Have the same problem,disabled all add-ins, still shoes the message.  Please assist!

Please Log in or Create an account to join the conversation.

More
3 years 6 months ago #908 by qiuhongkun
Replied by qiuhongkun on topic Unable to open a filter settings scenario
Hello,
Sorry, we cannot replicate this issue.
Please try to disable all the other add-ins in your Excel add-ins manager first and then try your operation again.
Thanks in advance.

Please Log in or Create an account to join the conversation.

More
3 years 6 months ago #877 by MikeH
Replied by MikeH on topic Unable to open a filter settings scenario
Jay, please can you update me on this? The software is unusable for me until this bug is fixed.

Please Log in or Create an account to join the conversation.

More
3 years 7 months ago #835 by MikeH
Replied by MikeH on topic Unable to open a filter settings scenario
It's not a workbook specific problem. It's a bug, I think. This is what happens:

Open Excel > New Sheet > Click the 2nd icon from the left in Super Filter.

A list of Scenarios appears. Click a scenario. "Before opening a filter settings scenario, you must open a workbook first"

Obvious Book1 is open so this message isn't right.

Please Log in or Create an account to join the conversation.

More
3 years 7 months ago #834 by qiuhongkun
Replied by qiuhongkun on topic Unable to open a filter settings scenario
Hello,
Can you please send the workbook which can replicate this issue to us? We will keep your file confidentially. :)
You can contact us via jaychivo@extendoffice.com.

Please Log in or Create an account to join the conversation.

Moderators: ExcelfansOfficeFansAmanda Lee