r/MSExcel • • Oct 21 '24

How to stop Excel to check link before opening

3 Upvotes

I have a excel sheet with many shopping sites, most of them are opening without any problem, but some showing error.

for example, "https://zbotic.in/"Β this is one of the link that excel refuse to open. showing,

But when I copy the link & paste on browser the link working just fine.

Tried solutions: (but all failed)

Uncheck the box for "Update Links on save", &

reg add HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\16.0\Common\Internet /v ForceShellExecute /t REG_DWORD /d 1
reg add HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Common\Internet /v ForceShellExecute /t REG_DWORD /d 1
reg add HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Common\Internet /v ForceShellExecute /t REG_DWORD /d 1
reg add HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Common\Internet /v ForceShellExecute /t REG_DWORD /d 1
reg add HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Common /v DisableHyperlinkWarning /t REG_DWORD /d 1

To be Honest & to the point, I want MS Excel to open any link to the browser (even a dead links) and not check it before open it to browser, Just like MS Word do.

Is this simple task possible...?


r/MSExcel • • Aug 03 '23

Microsoft excel certification.

3 Upvotes

I am planning to take the Microsoft excel certification. Can anyone please recommend me the sources ? Thanks


r/MSExcel • • May 26 '23

125+ Excel Functions/Formulas

3 Upvotes

125+ videos on Excel formulas are here to help you master the art of spreadsheet calculations. Each video is designed to be short and to the point, making it easy to follow along and learn at your own pace. https://www.youtube.com/playlist?list=PLN5XHQr1r5K5GjdBPH7P6Hp-lYN9zdeSf


r/MSExcel • • Jul 04 '20

VLOOKUP IN EXCEL.............................

3 Upvotes

r/MSExcel • • Sep 18 '24

I have 2 columns, one with duplicates and the other with related unique data, I would like to consolidate the duplicates into unique columns with their values listed below them.

2 Upvotes

This should be pretty simple and I'm sure I'm going to feel silly when I get it, but I'm not even sure what to google to find it.

Right now I have this:

A11
A22
B11
B22
C333
C444
D333
D22

But I want this:

ABCD
1111333333
222244422

EDIT: I noticed I said unique in the title but column B has duplicates in my example, in my data everything in column B is unique.


r/MSExcel • • Oct 24 '23

Formula question (IFS and AND?)

2 Upvotes

Hi everyone. I have a formula question for MS Excel. I want to create a formula that does the following: if (sum of columns E+F) > (sum of columns G+H) > (sum of column I+J) then produce "text A"; if ( (sum of columns G+H) > (sum of columns E+F) > (sum of column I+J) then produce "text B"; otherwise produce "text C". I was trying to use an IFS function with nested AND functions but could not figure out how to produce my needed result. Thanks very much.


r/MSExcel • • Jul 24 '23

Ultimate formula and functions playlist

2 Upvotes

Unlock the power of Excel with our ultimate formula and functions playlist! πŸ“ˆπŸ”’ Learn time-saving tips and master complex calculations to supercharge your data analysis. Become an Excel wizard! πŸ’»

https://youtube.com/playlist?list=PLN5XHQr1r5K5GjdBPH7P6Hp-lYN9zdeSf


r/MSExcel • • Feb 04 '22

[Video] [Discussion] Not sure if these will be helpful but been creating some shorts on YouTube and want to know if they help people in the excel community? Genuinely interested so please let me know.

Thumbnail
youtu.be
2 Upvotes

r/MSExcel • • Aug 16 '21

NO need for vlookup and HLookup: use single formula xlookup in Excel : Please see once most important for daily use . Also Please subscibe us.

Thumbnail
youtube.com
2 Upvotes

r/MSExcel • • May 23 '21

How to quickly create Pareto Chart in Excel

2 Upvotes

Hi Guys

Posted a new video on how to quickly create Pareto Chart in Excel. Check it out by clicking on this link

Hit the like button if you find this video interesting then SUBSCRIBE to the channel if not done already.

Subscribe to Tech Reflections


r/MSExcel • • Apr 11 '21

Difference between excel and csv files

2 Upvotes

r/MSExcel • • Feb 09 '21

Hi guys This video explains how we can make a quiz with the help of google forms.

Thumbnail
youtu.be
2 Upvotes

r/MSExcel • • Jan 25 '21

Learn top 50 Excel Shortcuts Part 5

2 Upvotes

Hi Guys

Posted a new video on Excel shortcuts. This is the 5th video of video series which will cover top 50 Excel shortcuts, & in this video we will talk about the 10 more Excel shortcuts. Check it out by clicking on this link

Hit the like button if you find this video interesting then SUBSCRIBE to the channel if not done already

Subscribe to Tech Reflections


r/MSExcel • • Dec 08 '20

Learn top 50 excel shortcuts Part 2

2 Upvotes

Hi Guys

Posted a new video on Excel shortcuts. This is the 2nd video of video series which will cover top 50 Excel shortcuts, & in this video we will talk about the 10 more Excel shortcuts. Check it out by clicking on this link

Hit the like button if you find this video interesting then SUBSCRIBE to the channel if not done already

Subscribe to Tech Reflections


r/MSExcel • • Dec 02 '20

Learn top 50 excel shortcuts Part 1

2 Upvotes

Hi Guys

Posted a new video on Excel shortcuts. This will be a video series which will cover top 50 Excel shortcuts, & in this video we will talk about the first 10. Check it out by clicking on this link

Hit the like button if you find this video interesting then SUBSCRIBE to the channel if not done already

Subscribe to Tech Reflections


r/MSExcel • • Oct 05 '20

INDEX & MATCH function in Excel is easier than you thought (Part 1)

2 Upvotes

Hey Guys! Posted a new video on basics of INDEX & MATCH function. You can find the video by clicking on this link

Hit the like button if you find it interesting and if you haven't Subscribed already then do it now by clicking on link below!

Tech Reflections


r/MSExcel • • Aug 14 '26

Looking to Hire ms excel work

1 Upvotes

πŸ“Š Need Excel Work? I Can Help!

I provide professional Microsoft Excel services, including:

βœ… Data Entry

βœ… Data Cleaning & Formatting

βœ… Excel Spreadsheets

βœ… Formulas & Functions

πŸ’Ό Looking for reliable Excel support?

Send me a message and let’s discuss your work.


r/MSExcel • • Jun 19 '26

Excel File Grew from 400MB to 650MB β€” Even an M4 Mac Is Struggling. What Are My Options?

Thumbnail reddit.com
1 Upvotes

r/MSExcel • • Jan 20 '26

Give a free mini-template NSFW Spoiler

1 Upvotes

Share a simple Budget / Expense Tracker (Google Drive link) + ask for improvements.


r/MSExcel • • Sep 20 '25

Creating a spreadsheet to track staffing requirements based upon time

1 Upvotes

Hello All,

I am trying to create a staffing model that allows someone to add or remove SOP's to rows of testing methods that will then sum the total time, and the time for each staffing level. This is to help understand staffing requirements based upon Method sample volumes.

I've been able to write a manual formula that works, but it isn't elegant and would need to be manually modified if SOP's are added or removed to a Method. I was looking into Lambda, but I'm struggling to get it to work. I've YouTubed, Googled, AI'ed and asked friends, and I'm still struggling. So any assistance you could render would be greatly appreciated.

I have a spreadsheet that lists each testing method sample volumes for the last three years. Each method has a total time and up to seven different staffing levels. Each method can have one or more standard operating procedures that lists out the batch size, task, staff responsible and the time required to complete the task. I have added Names to each SOP for the Batch_Size, Total_Time & Staff_Level_Time. I have also pulled all SOP's and Staff_Level_Time into a table thinking it would be easier

My basic formulas are as follows, and is repeated for every SOP assigned to that method.
=iferror((roundup([FY##]/SOP###_BatchSize,0)*SOP###_Time),"-")
=iferror((roundup([FY##]/SOP###_BatchSize,0)*StaffLevel##_SOP###_Time),"-")

FY## = Financial Year
SOP### = Standard Operating Procedure (70)
Testing Methods = Different tests performed on samples utilizing one or more SOP
StaffLevel## = Staffing Level (1 - 7)
BatchSize = Number of samples processed in a group per SOP
StaffLevel##_SOP###_Time = Total Time allotted in SOP for a given staff level to complete the task


r/MSExcel • • May 22 '25

Ms excel learning with fun way

Thumbnail bubsg8snjd.app.youware.com
1 Upvotes

r/MSExcel • • Feb 12 '25

From where we can learn ms excel from zero to advance for job for free and good content also?

1 Upvotes

r/MSExcel • • Dec 09 '24

What is this weird animation that keeps popping up in Excel?

1 Upvotes

Mystic Light sounds like something from my MSI motherboard, but I can't find anything in its management software that would explain why I'm getting this in Excel and nowhere else.


r/MSExcel • • Dec 03 '24

MASTERING MS EXCEL AND TALLY

Post image
1 Upvotes