502,465 questions

Sort by: Updated
6 answers One of the answers was accepted by the question author.

Hyperlink Text in a Excel Row Automatically

I have one excel sheet called product.xls and an Excel template with product detail fields. I open this excel sheet. Whatever I type in the first column, should get converted to a hyperlink. So let's say I typed 'Roger' in A6. Roger should be…

Microsoft 365 and Office | Excel | For home | Windows
asked 2011-10-09T03:53:11+00:00
Anonymous
edited an answer 2026-11-13T05:16:21.3066667+00:00
Anonymous
1 answer

MS Outage on 12-11-26

Hi MS Support, Any update on the the system outage on 12-11-26? Appreciate your feedback. regards Jayden

Microsoft 365 and Office | Other
asked 2026-11-13T04:34:44.5966667+00:00
Kapi, Jayden 0 Reputation points
answered 2026-11-13T05:16:17.4766667+00:00
Kai-Ex 2,655 Reputation points Microsoft External Staff Moderator
7 answers

Is it possible to lock a formula on a template without protecting the sheet?

I'm trying to lock the formula cells so that they can't be tampered with, but if I protect the sheet it prevents rows from being copied and pasted (even with the "insert rows" option ticked) without unprotecting the sheet, and when the sheet is…

Microsoft 365 and Office | Excel | For home | Windows
asked 2011-10-06T15:07:52+00:00
Anonymous
edited an answer 2026-11-13T05:16:14.9933333+00:00
Anonymous
1 answer

How to password protect a folder in Microsoft Office 2003

I need to  password protect an entire "FOLDER in Microsoft Office 2003. I am also on a network, using a Buffallo drive, back up system, trash flies adn want to make sure all content filex in this folder as password protected etc.  I am using Windows…

Microsoft 365 and Office | Word | For home | Windows
asked 2011-08-13T15:11:18+00:00
Anonymous
edited an answer 2026-11-13T05:16:14.1766667+00:00
Anonymous
11 answers One of the answers was accepted by the question author.

How do I bold a word or date in a formula

Hi, I need to bold a word in a paragraph in excel.  There is a reference to the cell in the paragraph but it is not formatting the information the same as the cell when it goes into the paragraph. Examples below. This Order Form is valid only for…

Microsoft 365 and Office | Excel | For home | Windows
asked 2011-08-29T21:32:10+00:00
Anonymous
edited an answer 2026-11-13T05:16:10.56+00:00
Anonymous
42 answers One of the answers was accepted by the question author.

insert row in protected sheet by keeping formula

Hi I have a protected sheet contain formula in each row depends to above row( for example C2=C1+1; C3=C2+1;...).and cells contained these formula are locked. I like to allow users to insert row everywhere by keeping formula without unprotecting the…

Microsoft 365 and Office | Excel | For home | Windows
asked 2011-08-13T08:15:07+00:00
Anonymous
edited an answer 2026-11-13T05:16:10.05+00:00
Anonymous
5 answers One of the answers was accepted by the question author.

Protect sheets but still allow VBA code to run

HI, I have placed a code in excel workbook to protect all sheets by VBA. The code is as follows: Sub protectSheets() Dim i As Long     For i = 1 To Sheets.Count         Sheets(i).Protect Password:="password", userinterfaceonly:=True     …

Microsoft 365 and Office | Excel | For home | Windows
asked 2010-11-26T13:33:32+00:00
Anonymous
edited an answer 2026-11-13T05:16:02.84+00:00
Anonymous
1 answer

Macro to save as read only

Can anyone help me with a macro that will save a worksheet as a read only with a password to open (editable)?  Thanks

Microsoft 365 and Office | Excel | For home | Windows
asked 2011-03-30T16:26:46+00:00
Anonymous
edited an answer 2026-11-13T05:16:01.08+00:00
Anonymous
0 answers

Office Add In Single Sign on - Access token Expiry

I have a word addin which uses Office.auth.getAccessToken for authenticating with azure. Does this access token has an expiry defined ? I could not see any expiry key on the response from getAccessToken().

Microsoft 365 and Office | Development | Other
Microsoft Security | Microsoft Entra | Microsoft Entra ID
Microsoft Security | Microsoft Graph
asked 2022-08-05T09:17:33.167+00:00
Dhiluraj V 46 Reputation points
0 answers

Macro - Query MySQL Database with DSN-less Connection

Can anyone help me with writing a macro to query a MySQL database? From Excel? I can successfully query the remote MySQL db using MS Query and a DSN.  But I need to make it more portable, so multiple users can grab the file and work on it anywhere. I…

Microsoft 365 and Office | Excel | For home | Windows
asked 2010-11-09T21:30:54+00:00
Anonymous
1 answer

File saved by VBA won't open

I have a routine that works correctly up until it saves a file that it wrote. The file looks OK when it's still open, but after I close it I can't reopen it. The Save statement is shown below. Would like suggestions about what is causing this.    …

Microsoft 365 and Office | Word | For home | Windows
asked 2011-02-02T17:20:41+00:00
Anonymous
edited an answer 2026-11-13T05:15:54.2566667+00:00
Anonymous
1 answer

VBA, ODBC Authentication, and Passthroughs

My company is in the process of meeting certain guidelines to make steps toward going public.  One of those steps involves analysts to have to change their ODBC passwords every 30 days.   Not awful for adhoc type deals, but I have a reporting box that…

Microsoft 365 and Office | Access | For home | Windows
asked 2011-02-23T16:19:35+00:00
Anonymous
edited an answer 2026-11-13T05:15:51.7433333+00:00
Anonymous
6 answers

You cannot use this command on a protected sheet.

I have created a worksheet in which I've group certain rows. When I protect the sheet, the group function is no longer useable, I get the following error message: "You cannot use this command on a protected sheet. To use this command, you must first…

Microsoft 365 and Office | Excel | For home | Windows
asked 2010-11-03T16:57:04+00:00
Anonymous
edited an answer 2026-11-13T05:15:50.0233333+00:00
Anonymous
3 answers

Can I allow macros to run on a protected sheet?

Maybe the answer is a simple no, but I figured I'd ask. I just want to run a simple macro that performs a filter function so I can hide the filter arrows and simplify the filtering. When I try to run the macro while the sheet is protected, I get the…

Microsoft 365 and Office | Excel | For home | Windows
asked 2010-12-08T21:40:19+00:00
Anonymous
edited an answer 2026-11-13T05:15:49.6233333+00:00
Anonymous
14 answers One of the answers was accepted by the question author.

Insert row in a table on protected worksheet

Excel 2007 tables have this feature to add row by pressing the keyboard tab on last cell of last row. But if the workbook is protected the error message is displayed saying "cannot use this table feature with protected worksheets". I want to…

Microsoft 365 and Office | Excel | For home | Windows
asked 2011-03-29T09:40:23+00:00
Anonymous
edited an answer 2026-11-13T05:15:47.5066667+00:00
Anonymous
0 answers

COnverting multiple pages in a single Word document to individual pages

I have a Word document that contains 12 seperate job descriptions, each is a seperate page within the document.  Is there a quick way to save each page as it's own document??

Microsoft 365 and Office | Word | For home | Windows
asked 2010-07-30T14:56:01+00:00
Anonymous
2 answers

Downloadable Send to OneNote 2007 Print Driver for 64-bit System?

I purchased MS OFfice Home and Student 2007 in 2007 specifically because it had OneNote (which I use to send program files as well as Internet pages to in order to save, organize and print).   Recently my HP Vista laptop died the blue-screen-of-death. …

Microsoft 365 and Office
Microsoft 365 and Office

A comprehensive suite of productivity tools and cloud services that enhance collaboration, communication, and efficiency. Combining classic Office apps with advanced Microsoft 365 features, it supports both personal and business needs

3,088 questions
asked 2010-04-06T19:31:15+00:00
Anonymous
edited an answer 2026-11-13T05:15:40.2166667+00:00
Anonymous
3 answers

Access 2007: "Not a valid password" error

Hello, I am trying to save the output table (tbl_test) of a Make-table Query (mtqry1) from my current access database(db1.mdb) into another access database(db2.mdb). But the another database i.e. db2.mdb is encrypted with an alphanumeric password. So…

Microsoft 365 and Office | Access | For home | Windows
asked 2010-05-19T19:21:52+00:00
Anonymous
edited an answer 2026-11-13T05:15:35.83+00:00
Anonymous
2 answers

Images, compression, & file size

Hi Folks, I have an Excel file I am working on with an image box that has click event code to insert a picture. I've been trying to include code to automatically compress the image. The file size gets huge. The file size is 48 kb, if I insert a 5.0 MB…

Microsoft 365 and Office | Excel | For home | Windows
asked 2010-10-20T15:13:56+00:00
Anonymous
edited an answer 2026-11-13T05:15:33.1433333+00:00
Anonymous
3 answers

How to allow 'Group/Ungroup' on a Protected and Locked Worksheet

Right, this may be structures and security so lets try... I have a pretty big Excel Progress Claim workbook, that is 'organised' with worksheets (tabs) like below: Actual Claim summary, working over 968 lines for the Project work items Several tabs…

Microsoft 365 and Office | Excel | For home | Windows
asked 2010-08-24T01:30:46+00:00
Anonymous
edited an answer 2026-11-13T05:15:32.0233333+00:00
Anonymous