Everyday Excel 1-2-3

Using Microsoft Excel 2013, Everyday Excel 1-2-3 is designed to share some "everyday" experiences, tips or tricks for Microsoft Excel users. Target reader experience will range from Beginner to Expert and posts will often reach out to each group but not every group always. Comments are welcome and highly encouraged. Suggestions for topics are welcome, but solutions to specific problems will not necessarily be provided. Part of learning is struggling, and we're all struggling together.

Thursday, March 6, 2014

Question for the Audience...

Okay all, I have a problem that I don't know how to fix. HUGE points to one who has an appropriate solution.

The Problem: How do I default a text value slicer selection WITHOUT using VBA? Is it even possible?

Why no VBA? Our company is a bit behind the times in upgrading us all to the same version of office. I have Excel 2013, but the rest of the world is using 2007 (No slicers available). Therefore, I post my files to a SharePoint site and the end users are able to use them via Excel Services (hence the no VBA).

I am searching all over for this answer right now and will gladly share the how-to if/when I figure it out. I would gladly host a "Guest Post" if you know how to do this already.

Thanks!

1 comment:

AdminMarch 13, 2014 at 9:44 AM
So... The best solution I can come up with at this time is to save the file uploaded to Sharepoint with the default slicers pre-selected. Definitely NOT optimal, but it got the job done. Scoreboard: Workaround(1) - Excel(0)
ReplyDelete
Replies

Add comment