A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
VBA code to copy Master worksheet Values and rename to current date then hide / protect the sheet
Hi I'm entirely new to VBA coding I'm creating a my first macro. This file is designed to keep track of 100+ individuals historical data. all work will be completed on one sheet called "Master" I want the macro to copy values from…
Microsoft 365 and Office | Excel | For home | Windows
Has anyone else experienced the same issue as me?
I couldn't access my work email this morning. Please help me
Outlook | Web | Outlook on the web for business | Sign in
Accessing Outlook on the web for business using organizational credentials.
SharePoint Error: Unable to delete Custom Content Type
I am trying to delete a custom content type in Site Settings. I received the following error: The content type "Branded PowerPoint Presentation" is part of an application feature. What does this mean? How can I remove this type from the…
Microsoft 365 and Office | SharePoint | For business | Windows
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
Fill pie chart slice depending on alternate data
Hi everyone, So I'm not sure quite how to ask this, and I definitely don't know how to do it, but I will do my best. I already have a pie chart: Each slice represents the total cost of a group of related projects. I have a column for each project…
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
How to set new view as default view in OneDrive for Business default Document library?
Hi Team, I have created a new view in OneDrive for business default Documents library but not able to set it as 'default' view. Could you please assist me on how to do this? Thank you. Kind Regards, Akshay Deshpande
Microsoft 365 and Office | OneDrive | For home | Windows
A Microsoft file hosting and synchronization service.
Microsoft Teams - Installer for Mac Error
Trying to install the Microsoft Teams application on Mac OSX 10.12.3 and I receive an error "A JavaScript error occured in the main process" The only option is to click OK. I've removed the app, cleared the trash, rebooted, re-downloaded and…
Microsoft 365 and Office | Install, redeem, activate | For home | Other
Processes in Microsoft 365 for setting up Office apps, redeeming product keys, and activating licenses.
How to get data from an encrypted 2016 access database in excel 2016
I am trying to get data from a 2016 access database into excel 2016. If I apply no encryption to the access database it's very easy to access tables in excel simply by selecting Data->get-data->from-database->From Microsoft access database then…
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
Protect locked cells in multiple sheets
I would like to protect locked cells in MULTIPLE sheets in one workbook but it would take much to long to do each one individually. How do I do it across all sheets in one go?
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Use VBA to query SQL Azure Database
I'm a PC Excel developer. I use ADODB a lot. I have a workbook that allows users to enter search terms and uses those terms to query a database on SQL Azure. It works perfectly. I need to make a version for Mac. YIKES! A whole new world. I've read and…
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
User delegated SAS token generated by Powershell command and Azure Portal different with SAS token created by Azure CLI
A User delegated(AD) SAS token created for storage account created by Azure portal or Powershell is different with a SAS token created by Azure CLI. Example: Azure CLI: az storage container generate-sas --account-name --name …
Azure Storage
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
Autofill date when another cell is filled in (not blank) but need the cell to stay blank and not update when the file is opened.
Autofill date when another cell is filled in (not blank) but need the cell to stay blank and not update when the file is opened the next day. Using cells V1 and O1, in cell O1 I have =IF(A1<>"",TODAY(),"") but the date always…
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Opening a Word Document
I've been using Word for 15 or so years! Since it first came out! And a new document always opened as Document1.doc. Of late a new document comes out as Template1? And all my settings are gone, as I like certain margin settings. It always reverts…
Microsoft 365 and Office | Word | For home | Windows
A family of Microsoft word processing software products for creating web, email, and print documents.
Retrieve SharePoint Online Root Site Collections list using CSOM lib or REST API without admin creds
Hi All, I'm trying to solve simple task : To retrieve root site collections list automatically. I know the easy way to do it using admin credentials and C# CSOM library, but it would be much better to use something like admin-consent (Graph API) flow to…
Microsoft 365 and Office | SharePoint | For business | Windows
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
microsoft, I can't Login to OneDrive
I am connected to internet, but it shows this error.
Windows for home | Windows 11 | Apps
How to automate the process of locking cells when they contain data
In Excel 2003, to protect data entered in cells, and allow only editing empty cells, I do the following: In an empty worksheet, I select all cells, and Format | cells | protection | uncheck locked property. After I enter data in some cells, I select…
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Changing Form Field highlight and/or background color when document is protected
Can it be done? I am able to change the form field color programmatically, provided the document is not protected, but when not protected the document is much less useful as a form, because it is too easy for the user to accidentally delete the form…
Microsoft 365 and Office | Word | For home | Windows
A family of Microsoft word processing software products for creating web, email, and print documents.
Azure AD Connect password sync
Hello, we have installed office 365 and Azure AD Connect to migrate from on-premises DC. Noticed that the sync tool makes sync every 3 hours. I am wondering, if I want to block a user or change a password is there any way to trigger these changes so they…
Microsoft 365 and Office | Subscription, account, billing | For home | Windows
Microsoft 365 features that help users manage their subscriptions, account settings, and billing information.
Outlook outage
Okay, MSN...what's the update now? All day, nuthin.
Outlook | Web | Outlook.com | Email
Sending, receiving, and organizing email in Outlook.com
Color coding the check in a check box
Is there a way to color code the marking in a checkbox so that if someone marks certain checkboxes, they will stand out in color? For example, I have checkboxes for "Yes", "No", and "NA". If "No" is checked, I want…
Microsoft 365 and Office | Word | For home | Windows
A family of Microsoft word processing software products for creating web, email, and print documents.
How to Look up EX1550543.
How to Look up EX1550543. I logged in a the administrator, but got the following message: "Switch to an account that has permission Your account doesn't have permission to view or manage this page Login is not supported for consumer users without…
Exchange Online
A cloud-based service included in Microsoft 365, delivering scalable messaging and collaboration features with simplified management and automatic updates.