
Closed
Posted
I need a macro for Excel 365 to refresh a pivot table from a data input sheet. The macro should run while the workbook is protected. Requirements: - Refresh the pivot table: - Automatically when the workbook is opened. - Whenever the data is updated. - Compatible with Excel 365. - Must work while the worksheet is protected. Ideal Skills and Experience: - Proficiency in Excel VBA. - Experience with pivot tables and workbook protection. - Familiarity with Excel 365 features.
Project ID: 40552839
10 proposals
Remote project
Active 6 mins ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average ₹1,006 INR/hour for this job

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
₹1,000 INR in 40 days
6.6
6.6

Hi, I can create an Excel 365 VBA macro that refreshes your pivot table while keeping the workbook protected. What I'll deliver: Automatic pivot table refresh when the workbook opens. Automatic refresh whenever the data is updated. Works with protected worksheets using the appropriate VBA approach. Fully compatible with Excel 365. Clean, well-documented VBA code. I have experience with Excel VBA, pivot tables, worksheet protection, and automation, and I can complete this quickly. Looking forward to working with you!
₹900 INR in 40 days
5.1
5.1

@SahyadriTech #SahyadriTech Completed Projects: 1. Hotel Booking Management & Tracking System (Excel + VBA Script) 2. Appsheet: ERP system for textile business 3. MNGL Gas Incident Tracker & Dashboard (Google Sheets + Google Data Studio) 4. Daily Expenses Tracker (Google Sheets) 5. Option Scalping Strategy Automation (Excel VBA) 6. Nifty50 Live Option Chain Dashboard (Google Sheets) 7. Binary Trading Sheet (Google Sheets) 8. Customer Data Cleaning & Sorting Tool (Excel VBA & Python) 9. Historical Stock Closing Price Analysis for 2,600 Stocks (Excel & Python) 10. Power Bi dashboard for F1 Car racing insights 11. GOLD Loan tracking in Google sheet and Google Data studio 12. Local Taxi Tracking System (Google Sheets + Google Data Studio) 13. Appsheet Milk Drivers wages and attendance system (Appsheet + Google sheet ) Key Highlights: 1. Pay only if satisfied with the work 2. Expert in Power BI, Excel, VBA Macros, Google Sheets, Google Apps Script, and Python 3. Experience in 3 American MNCs 4. Skilled in Data Analytics, Automation, and Visualization 5. Proficient in Statistical Analysis 6. Offer Long-Term Support for all projects 7. Quick Delivery with multiple revisions I can deliver any project related to Data Analytics, Automation, and Reporting with precision and reliability.
₹1,000 INR in 40 days
2.5
2.5

Hi there, I can implement a flawless, automated VBA macro for your Excel 365 workbook that refreshes your Pivot Tables while keeping your sheets completely protected. Instead of using the basic, problematic method of constantly unprotecting and re-protecting your sheets—which can leave your data vulnerable if the macro crashes—I will implement the advanced UserInterfaceOnly:=True parameter. Why this is the best solution for your project: Continuous Protection: Your worksheets remain 100% locked to human users at all times, preventing them from accidentally deleting formulas or altering your layout. Seamless Background Execution: It explicitly grants your background VBA code full authority to refresh Pivot Tables instantly without ever throwing "Runtime Error 1004". Maximum Performance: Because Excel doesn't have to toggle security settings on and off with every data entry, the workbook remains fast, responsive, and free of screen flickering. Project Deliverables: Workbook_Open macro to automatically initialize the secure macro-bypass rule every time the file is opened. Worksheet_Change event macro on your data input sheet to instantly refresh the Pivot Table the moment new data is added. Fully tested, clean, and error-handled code optimized for Excel 365. I specialize in building robust enterprise automation and can deliver a perfect, macro-enabled workbook (.xlsm) within 24 hours. Let's get this running smoothly for you! Best regards, Jayaprakash Rameshbabu
₹760 INR in 40 days
0.0
0.0

Building on my skills and experience in data processing and Excel, I am confident that my understanding of the platform's logic and extensive use of technological applications as a medical researcher will place me in good stead for your project. Though not directly related, the intricate nature of medical research and data analysis mirrors that of pivot table utilization. While being detail-oriented helps me in spotting discrepancies in clinical data, my ability to consistently meet deadlines comes in handy especially when accuracy is key. My ambition to deliver quality work at affordable rates aligns perfectly with your need for someone who can provide value without breaking the bank. Choosing me means hiring someone who not only possesses expertise in VBA programming but also an individual dedicated to understanding and delivering on a client's vision. I look forward to this opportunity to leverage my skills intelligently, execute your requirements efficiently, and grow mutually along the professional road ahead.
₹900 INR in 1 day
0.0
0.0

As an experienced software developer with 7+ years in various tech fields, including being highly skilled in Excel VBA, I am well-positioned to handle your project requirement of creating a macro for Excel 365. My expertise includes working efficiently with pivot tables and workbook protection, ensuring all functionalities run without a hitch. One of the key reasons you should choose me is my proficiency in Excel 365 features. Being deeply familiar with the program's capabilities enables me to deliver precise solutions tailor-made for it. Moreover, my knack for adapting to new technologies proves vital here, guaranteeing that I can quickly understand the unique aspects and structures of your dataset, Lastly, as a tech enthusiast who loves dealing with intricate problems like this, I bring a genuine passion to maximize your satisfaction. I always prioritize meeting and exceeding clients' expectations. With me, you'll get more than just a dry execution of tasks; rather, a collaborative effort to achieve an elegant and efficient solution - just like your project demands
₹750 INR in 40 days
0.0
0.0

Mumbai, India
Member since Jul 16, 2024
₹1250-2500 INR / hour
₹12500-37500 INR
₹750-1250 INR / hour
$250-750 USD
$250-750 USD
$2-8 USD / hour
$250-750 USD
₹12500-37500 INR
₹400-750 INR / hour
£250-750 GBP
₹750-1250 INR / hour
₹600-601 INR
$500-700 USD
₹1500-12500 INR
$30-250 USD
$250-750 USD
$10-30 USD
$10-30 USD
₹750-1250 INR / hour
$8-15 USD / hour
$15-25 USD / hour
₹750-1250 INR / hour