not sure if this is the correct place for this...
When opening excel 2007 and invoking the Cognos 8 functionality one our users gets an error message that says:
"Unable to set the Linestyle property of the Border Class"
This is a new message that hasn't happened before, and no changes have been made to the install. Anyone else run into this with Analysis for Excel? My guess after doing a quick search online is that this is an Excel error. Any thoughts?
thanks
Jeff
Hi Jeff,
I know this is an old post and you have probably resolved this but thought I would share for the benefit of others.
We had the same issue and found that it is protection on the worksheet that results in this error when changing filters. Turn sheet protection off and this resolves the issue.
Regards
Eugene