Automating Monthly Net Salary Reports in Excel from Online Data Sources

Question

Automating Monthly Net Salary Reports in Excel from Online Data Sources

Giuseppina rinaldi 40

Hi everyone,

I’m working on automating a monthly salary report in Excel for Italian employees. The goal is to make the sheet automatically calculate net salary calculation 2025 [calcolo stipendio netto 2025] values showing the full breakdown from da lordo a netto, including IRPEF, INPS, and regional taxes without manually updating rates each month.

Right now, I’m using data from reliable calcolo stipendio netto tools online, but I’d like Excel to fetch these updates automatically. Ideally, the workbook should connect to an online data source or use Power Query to refresh the tax and contribution values whenever they change.

Has anyone tried something similar for payroll or HR dashboards? Would Power Query or an API connection be the best approach for keeping these calculations up to date?

Thanks in advance for your help!

If someone wants more details I will edit my question and add the web source.

Locked Question. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

rao abdullah 0 Reputation points

2025-11-01T21:55:06.0133333+00:00

Hi Jeff, frequent BSODs with different errors usually point to a driver or hardware issue rather than Windows itself. Since memory seems fine, try updating or reinstalling your graphics and chipset drivers from your PC or motherboard manufacturer’s website — not through Windows Update.

Also check the Event Viewer → System logs for recurring driver or hardware faults right before each crash. If you see ntoskrnl.exe or driver.sys mentioned, it’s almost always driver-related.

You can also run Driver Verifier (verifier command) to identify faulty drivers. Let it run for a while and see which one triggers the crash. That info will help narrow it down fast.

Hopefully this helps you isolate what’s causing the blue screens.

Humanize 120 words

Answer accepted by question author

0 additional answers

rao abdullah 0 Reputation points

2025-11-01T21:55:06.0133333+00:00

Hi Jeff, frequent BSODs with different errors usually point to a driver or hardware issue rather than Windows itself. Since memory seems fine, try updating or reinstalling your graphics and chipset drivers from your PC or motherboard manufacturer’s website — not through Windows Update.

Also check the Event Viewer → System logs for recurring driver or hardware faults right before each crash. If you see ntoskrnl.exe or driver.sys mentioned, it’s almost always driver-related.

You can also run Driver Verifier (verifier command) to identify faulty drivers. Let it run for a while and see which one triggers the crash. That info will help narrow it down fast.

Hopefully this helps you isolate what’s causing the blue screens.

Humanize 120 words

Answer 1

Hello @Giuseppina rinaldi,

Thank you for reaching out to the Q&A forum!

Although your concern is typically outside the scope of my usual support responsibilities, I’ve taken the time to research it, and I’d love to share what I found to help you move forward.

In this case, Power Query is a very suitable solution. If the website presents the tax data in a clear HTML table, you can use Power Query in Excel to:

Connect directly to the URL
Extract the relevant data

Note: You may need to refresh the query daily, depending on how frequently the site updates its tax rates.

To get more advanced support and connect with others working on similar payroll automation scenarios, I highly recommend posting your question on Home | Microsoft Community Hub or Newest Questions - Stack Overflow

User's image

These platforms are large technical communities where developers and data professionals frequently share solutions to complex scenarios involving Excel, Power Query, APIs, and automation.

They are focused on technical topics and include experienced moderators and professionals who can offer deeper guidance and practical insights.

I apologize for redirecting you to a different community. To help you receive faster and more accurate assistance, I’m guiding you toward a more appropriate platform where your questions can be addressed more effectively.

Thank you for your patience and understanding; I truly appreciate your time and cooperation.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

Automating Monthly Net Salary Reports in Excel from Online Data Sources

0 additional answers