Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-28-2022, 02:19 PM
marcwade marcwade is offline One spreadsheet with different looks Mac OS X One spreadsheet with different looks Office 2016 for Mac
Novice
One spreadsheet with different looks
 
Join Date: Nov 2022
Posts: 1
marcwade is on a distinguished road
Question One spreadsheet with different looks

I have a spreadsheet with six columns of data. I've created three different views, each of which uses a different filter on the data.

Is it possible to, for example, provide a link to a view or sheet that defaults to one of these filters? And is it possible for a view to hide one or more columns without affecting the other views? If it's not possible with Views, is there another way?



I'd like to share this sheet with others who have different needs for the information. Some might need to see all columns, some might need just a few columns and filtered in a certain way.
Reply With Quote
  #2  
Old 12-01-2022, 06:59 AM
kilroyscarnival kilroyscarnival is offline One spreadsheet with different looks Windows 10 One spreadsheet with different looks Office 2021
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

If I'm understanding the situation correctly:

You'll have all these different "views" as separate worksheets in the same workbook, and you want different users to be guided directly to the tab or worksheet that is set up for them?

You can use a hyperlink, but I think with some caveats, especially given that you're on Word 2016 for Mac and I have Windows, so I'm not sure this will work exactly.

If your workbook is at X:\Work Files\Spreadsheets\DataWorkbook.xlsx

You would simply add the sheet name, preceded by the # symbol, and optionally a cell at the top of that sheet, preceded by the ! symbol.

X:\Work Files\Spreadsheets\DataWorkbook.xlsx#Overview!A1

That hyperlink should take the user to the page and view needed. I've read on another site, though, that this may or may not work exactly with different versions of Word. Hopefully someone else can weigh in, but I think in some older versions, the sheet name was to be inside 'Sheet1' single quotation marks, inverted commas or however you call them.

Another option would, I think, be to set up different workbooks, all pulling from the same source of data, but in different filters, so that you could direct them to different workbooks entirely. This might require updating links every time you open it.

Are you talking about filtering as in Data/Filter, or the newer Excel =FILTER function? I think you need 365 for that, but I'm not sure. Leila Gharani had some great intro videos on this feature. I used this (https://www.youtube.com/watch?v=Onudkw9DMlU) to make some updating tasks much easier.
Reply With Quote
  #3  
Old 12-07-2022, 03:07 PM
Guessed's Avatar
Guessed Guessed is offline One spreadsheet with different looks Windows 10 One spreadsheet with different looks Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

On the View ribbon there is a button called Custom Views. You can use this to store and retrieve your different views.

Start with adding a Show All view. Then customise your workbook view and add each one as a new view.

When you save a custom view you can choose to include print settings, hidden rows/columns and filter settings.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #4  
Old 12-08-2022, 08:41 AM
Logit Logit is offline One spreadsheet with different looks Windows 10 One spreadsheet with different looks Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

You could also consider create a single, log in sheet for all employees. Each login is different and takes the user to a different worksheet designed specifically for them.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
One spreadsheet with different looks Macros Spreadsheet PomDave Excel 7 11-08-2020 07:59 PM
Mac 2011 - When I close a spreadsheet, there is a blank spreadsheet left on dock. wvinyard Excel 0 07-27-2017 11:32 AM
Need Help with spreadsheet Yasemin Excel 12 05-09-2017 11:20 AM
Spreadsheet Lock medavidcook Excel 1 03-06-2014 09:33 AM
One spreadsheet with different looks Spreadsheet Help furface00 Excel 1 12-14-2012 08:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft