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
How to configure a linked service to Cosmos DB (SQL API) with a linked service to Azure Key Vault with parameterized database
With Azure Data Factory UI experience, one can create a linked service to Cosmos DB (SQL API) with a linked service to Azure Key Vault using the Account Key type authentication. In this particular scenario, we have added secrets to the Azure Key Vault…
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
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.
I forgot my Word 2016 password. Is there any solution to recover my password?
Im using Word 2016 in Windows 10 64bit... I created and saved the document with password, and the file is already encrypted. (I think on the first week of february) Then when i entered the password, it says that the password that i typed in…
Microsoft 365 and Office | Word | For home | Windows
A family of Microsoft word processing software products for creating web, email, and print documents.
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.
SSO URL redirects user to deprecated portal
Hello, When I use REST Api to get SSO URL to redirect user to our developer portal, the returned URL takes user to the deprecated portal: …
Azure API Management
An Azure service that provides a hybrid, multi-cloud management platform for APIs.
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.
Deactivate Office 2013
I purchased Office 2103 during the summer of 2014. The machine I had installed the license is no longer available, and I have lost my username and password for the Microsoft account I had setup for activating Office 2013 originally. How do I deactivate …
Microsoft 365 and Office | Install, redeem, activate | For home | Windows
Processes in Microsoft 365 for setting up Office apps, redeeming product keys, and activating licenses.
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.
Can you protect and unprotect all the sheets in a book at once
I have several books and I protect each sheet in the book. When I have to work on the sheets I unprotect them. Can I do this all at once or do I have to each sheet? If I protect the entire book does that do all the sheets and may be better way of…
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.