User Profile
SWalter2937
Brass Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Sheet Vew activating continuously every 5 - 10 minutes
We are running Excel 365, (Version 2108, Build 14326.20404) when using co-authored files 2 of the 6 users have the "Sheet View" activate all on it's own, continuously throughout the day. They have to keep exiting "Sheet View" so they can see the changes made by others in the group. They will have the file open on one of their monitors, while they are working in a different application on their other monitor, all of a sudden, boom, black outline on the Excel worksheet in the file that they are not even working in? Now it is in "Sheet View" and they have to now go to that screen activate Excel and close ("exit") sheet view to see the current file. Has anyone else seen this? It is super annoying and I don't understand why it is basically turning itself on?Issues with Personal View filtering and running Macros(VBA)
We use a shared Excel 365 (co-authored desktop) file to track our work orders, the data from our ERP system is updated by the users multiple times during the day. They paste the new ERP data into blank “update” tab, go to their current working tab, then click a “Run Update” button that triggers an update macro that runs and updates their current working tab data. This has been working relatively well, but now we are having an issue with the “sheet view” option that was added with Microsoft 365 update Version 2007 (Build 13029.20308). The macro uses the code “ActiveSheet.AutoFilter.ShowAllData" to clear the filters before the update runs. But, this code does not remove the filter of any user that is has “sheet view” set to “personal view”, that users view does not change and somehow that carries over into the update data. This is a big problem because there is no way the other users know (that I am aware of) if someone has a “personal view” active on the worksheet. They run the update with another user in personal view mode, causing the update data to be flawed, missing rows, having blank rows within the data table and etc. Luckily the data is corrected if everyone closes out of “personal view” and the update is ran again. I don’t know if there is even any VBA code that would remove the “sheet view” filters of all users in “personal view” of that workbook/worksheet?Both Hub Menu and Top Bar Disappear in split screen view?
We have just rolled out SharePoint Online/O365 to our first test group and found that the menus are disappearing if you go to split screen view? We are new to SharePoint so I don't know if this is a known behavior or a setting somewhere? I have attached screenshots of normal view and split screen views.Re: Update: Document Sets in Modern Document Libraries
LincolnDeMaris I sure hope this May delivery holds, we are looking at using these, but the classic view is not going over with the management stakeholders. No update from Microsoft in the Uservoice discussion thread on this. Also disconcerting that the 365 road map was updated after this post, and stills says in development?Can Managed Metadata Hierarchy limit inputs
I am new to SharePoint online and using Metadata. I am trying to use Managed Metadata to do cascading limiting of available terms. Example, we are a dealer with many manufactures pieces of equipment. What I would like to do, if is possible, is to limit the available selections under the "Models" column based on what "Make" has been selected in that column. I have created a term set named Manufactures, with manufactures Names at the next level, and under those manufacturer names the models are listed. I have attached a file that probably displays it better than I describe.
