
Closed
Posted
Paid on delivery
I keep one master workbook in Excel Online where every region’s sales lives on its own tab. I need a clean way to publish that file to a shared OneDrive/SharePoint location while guaranteeing that each tab is only visible to the email addresses I approve for that region. Key points to solve: • Platform is Excel Online, so whatever you build—Power Automate flow, Office Scripts, VBA-free splitting routine, or another cloud-friendly method—must work natively there. • Authorized users may be added two ways: I might type them in one-by-one for small changes or bulk-import a list (CSV/Excel) when many regions update. Please include both options. • I want to maintain the master once; regional viewers should never see other regions’ data yet always have the latest numbers. What I expect back: 1. A working solution (script, automation, or documented process) deployed to my tenant. 2. Step-by-step notes so I can repeat or tweak it later without your help. 3. Brief validation that regional users can confirm they see only their sheet. Send a detailed project proposal that explains your approach, any Microsoft 365 tools you’ll rely on, and the timeline to get this running.
Project ID: 40522704
40 proposals
Remote project
Active 1 day ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
40 freelancers are bidding on average $141 USD for this job

Hello Sir/MAM I am a skilled full stack developer. Having rich experience in Java , C++ , C , C# , Python , Eclipse , Sql , Mysql , .Net ,Oracle , Object Oriented Programming , Data Structure , Algorithms, Linux , Windows , Cloud , Azure . I have a perfect grip on “Artificial Intelligence” “Automation” , and work in “Machine Learning” Deep Learning ”. My track record as demonstrated in my 100% job completion and 5-star review rating showcases My ability to deliver exceptional results on time and with utmost quality I believe that my skill set makes me the ideal candidate for this project Please come on chat we will discuss more about this I will be waiting for your reply . Thanks and Best Regards
$113 USD in 1 day
5.9
5.9

I have done a similar project a week ago. I am sure you will give me more projects after this. I am interested to do this project too and ready to complete this within the timeline. Kindly check my profile to see all rating and reviews given by clients. Hoping to hear from you soon. Payment after completion.
$100 USD in 2 days
5.0
5.0

Excel Online doesn't support secure sheet-level permissions, so I'll create an automated solution using Office Scripts, Power Automate, SharePoint, and OneDrive that splits your master workbook into region-specific files and publishes them with region-based access controls. The solution will support: • Manual user management for quick updates • Bulk CSV/Excel imports for large permission changes • Automatic refresh from the master workbook so regional users always see the latest data • Secure access ensuring users can only view their assigned region Deliverables: ✔ Fully deployed solution in your Microsoft 365 tenant ✔ Step-by-step documentation for future maintenance ✔ Validation testing to confirm users only see authorized data Estimated timeline: 4–5 days. Let's discuss your workbook structure and I'll share the most efficient architecture for your environment.
$450 USD in 7 days
4.2
4.2

Hi ClientFirstName, I can see the hidden risk here: one wrong sharing step and regional users could expose the master workbook. I’ve worked on Excel Online, SharePoint/OneDrive workflows, and cloud-friendly automation, so I can build a secure sheet-level distribution process that keeps one master source while each region only accesses its own data. I’ll design the solution using Microsoft 365 tools such as Power Automate, Office Scripts, and SharePoint permissions, with both manual email entry and bulk CSV/Excel import for approved users. The setup will keep the master workbook as the single source of truth, automatically publish region-specific access, and include clear repeatable notes so you can manage it later without help. I’ve shared an initial estimate based on your description, and once we go over a few technical or functional details, I’ll confirm the exact cost and delivery schedule. I can also validate the flow with sample regional users so you know each one only sees the correct tab. If you’d like, I can start by mapping the permission logic and the split/publish flow first, then deploy it in your tenant. Do you want users to view the data directly in Excel Online, or is a per-region published copy acceptable if it stays automatically synced? Best regards, Asad
$125 USD in 3 days
4.3
4.3

Hello, I’m interested in this project because it matches exactly the kind of Microsoft 365 automation work I do—building clean, secure workflows around Excel Online, SharePoint, and Power Automate. What you’re trying to achieve makes sense: keep one master workbook, but make sure each region only ever sees its own data, with no risk of leakage. I’ve built similar setups where Excel Online is used as the source, and Power Automate + Office Scripts handle the secure separation and controlled publishing in the background. My approach would be to keep your master file untouched, then automate the process of splitting or filtering by region and distributing it through SharePoint with strict email-based permissions. I can also set up both manual and bulk user management (CSV/Excel upload), so adding or updating regional access stays simple for you. I’m a good fit for this because I focus on making these systems not just work, but stay easy to maintain after delivery—so you’re not dependent on constant technical help once it’s live. Before I start, I do have a couple of quick questions to make sure the solution fits perfectly: Do you prefer separate files per region, or a controlled single-file viewing approach? And how often is your master data updated—real-time, daily, or on demand? Looking forward to your thoughts. P.S. Happy to jump on a quick call or chat to clarify the structure before we begin.
$113 USD in 5 days
3.8
3.8

As a seasoned and agile technology team, we approach your project with a comprehensive skill set and unwavering focus on performance. Our wide-ranging talent in web development, software engineering, databases, and automation aligns seamlessly with your Secure Sheet-Level Sharing Setup needs within Excel Online. In our many years of delivering robust solutions for businesses worldwide, we completely appreciate the importance of discretion and data privacy. With precision, we'll engineer a solution using Microsoft 365 tools like Power Automate flow or Office Scripts to ensure secure sheet visibility to the right eyes only. Furthermore, our expertise in bulk-importing email addresses from CSV or Excel will allow you maximum flexibility while keeping your database up-to-date effortlessly.
$100 USD in 7 days
3.7
3.7

As a seasoned web and software developer with a strong background in automation, data management and a deep understanding of Excel Online, I am uniquely equipped to create the secure and efficient solution you seek. My technique is centered around deploying innovation coupled with a highly organized approach, which aligns perfectly with your need to maintain the master workbook while ensuring regional viewers only see relevant data. I’ll utilize my expertise to build you a future-ready SharePoint setup, complete with Power Automate flows and Office Scripts,that will guarantee secure sheet-level sharing for each region. In addition, I'll provide step-by-step documentation so that you are empowered to tweak and repeat the process as needed. Furthermore, I’ll add value by integrating the option to bulk import a list of authorized users using CSV or Excel files. A major strength of mine lies in translating complex requirements into clean digital systems and I assure you that each region's users will see only their respective sheets while still having access to the updated data - all handled natively in Excel Online.
$100 USD in 3 days
3.3
3.3

You need a secure Excel Online solution that splits a master workbook by region and restricts each tab so only approved users can view their assigned data via OneDrive/SharePoint. I build Microsoft 365 automation using Power Automate, Office Scripts, and SharePoint permissions. At Cloudstaff, I implemented data workflows that controlled access to large transactional datasets and automated reporting pipelines across teams using structured permission logic. For your setup, I’ll design a cloud-native workflow using Power Automate + Office Scripts to dynamically separate region data and publish controlled files to SharePoint folders. Each region will have isolated access via Microsoft 365 permission groups, ensuring no cross-region visibility while keeping the master file as the single source of truth. I’ll also include CSV/Excel bulk user import and manual assignment flow for flexibility. Delivery: 2-3 days. Can you confirm whether your users are already organized in Azure AD groups, or should I build the permission mapping from scratch?
$100 USD in 3 days
3.0
3.0

I looked at your Excel Online master workbook and see you need each regional tab visible only to approved email addresses, with both manual and bulk import options for user management, all running natively in the cloud without VBA. My approach uses Power Automate to copy each tab into a separate file when the master updates, then manage permissions via SharePoint site groups or OneDrive sharing links. For bulk imports, I will build a small lookup table in a separate Excel file or SharePoint list that maps regions to user emails, which the flow reads dynamically so you can update it by pasting a CSV or typing directly. I can implement both options: a simple manual entry form for small changes and a bulk upload process that accepts a CSV/Excel list for larger updates. For validation, I will provide a test user account so you can confirm each regional viewer sees only their sheet. Deliverables include the deployed Power Automate flow, step-by-step documentation for setup and maintenance, and a brief validation test showing regional access control working correctly. Price is 120 USD based on 2 work days at 60 USD per day rounded. Duration is 2 days. Do you have a SharePoint site or OneDrive folder already set up for sharing the regional files? Should the flow run on a schedule or trigger automatically when the master workbook is saved? Let me know your answers. I can start right away. Ricardo
$120 USD in 2 days
2.9
2.9

Hello, I carefully reviewed your requirement regarding publishing a master Excel Online workbook where each region’s data must remain fully isolated and visible only to approved users. I understand this is not just an Excel task, but a secure data distribution and automation problem inside Microsoft 365, where the master must stay single-source while access must be strictly controlled at the regional level. I can design a clean, scalable Microsoft 365 solution where your master workbook remains centralized, and regional visibility is handled through automated splitting and SharePoint-based permission control. This ensures each region always sees only its own updated data, without ever exposing other tabs or datasets. Please confirm: • SharePoint setup? • User format? • Bulk file? I specialize in Microsoft 365 automation systems, including Power Automate workflows, Excel Online (Office Scripts), and SharePoint-based permission structures. I regularly build automated data distribution systems where a single master dataset is securely transformed into role-based or region-based outputs with zero manual intervention. My focus is always on reliability, security, and maintaining a low-maintenance architecture that scales easily as users grow. I would be glad to implement a fully automated and secure setup for your workflow with a clean deployment and simple documentation so you can manage it independently going forward. Best regards. Mukesh
$250 USD in 7 days
2.7
2.7

Hello there, I can help with Power Automate flow, which process every selection from your sheet and share with a designated region/team. Fell free to contact me via messages and discuss your project.
$100 USD in 3 days
2.9
2.9

The setup exactly as described isn't possible, in Microsoft 365, sharing permissions apply at the file level, not per worksheet, so any tab in a shared workbook is visible to everyone who can open it. Your goal is fully achievable two ways, though: 1) you keep maintaining one master file, and a script automatically distributes each region's data into separate, individually-permissioned files. 2) we use Power BI to build granular per-region reports straight from your master.
$100 USD in 7 days
2.3
2.3

Hello, Excel Online – you need a clean way to publish a master workbook so each region’s tab is visible only to its approved email addresses. I’ll build a Power Automate flow that copies each sheet to a separate workbook in SharePoint, then applies per‑file permissions using Azure AD groups. This keeps the master single‑source and guarantees sub‑second access for regional users. If a region’s user list changes, the flow can ingest a CSV bulk‑import and automatically update the SharePoint ACLs, avoiding stale permissions. Do you already have a SharePoint site ready for the per‑region files, or should I create the folder structure as part of the setup? Looking forward to working with you. Artur Giżycki
$100 USD in 5 days
2.0
2.0

As a seasoned Data Analyst with over a decade of experience in the industry, I've honed my skills to not only manage data, but also apply innovative solutions to unique problems - just like the one you've presented. Over the years, I've developed a deep expertise in Excel and its various functionalities, including Excel Online which aligns perfectly with your project's requirements. I'm adept at creating automated workflows using tools like Power Automate, Office Scripts and VBA-free splitting routines that will allow you to maintain a single master workbook while ensuring that each tab is accessible only to approved email addresses for their respective regions. In terms of user management, I have worked on projects involving both manual entry and bulk-import options for authorized users; so you can trust me to build a comprehensively flexible system that suits your changing needs. Let's connect soon and lay out the roadmap for your project together!
$500 USD in 2 days
1.5
1.5

Hello, I am Amna, a seasoned professional with 6+ years of expertise in Automation, Excel, Google Sheets, and Data Management. I understand your requirement for setting up secure sheet-level sharing in Excel Online. I will create a solution using Power Automate flow or Office Scripts to ensure each region's tab is only visible to approved email addresses. I will provide options for adding authorized users individually or through bulk-import (CSV/Excel). Your master workbook will be maintained seamlessly, guaranteeing regional viewers access to their data only. With over 210 projects completed, I offer a comprehensive solution that aligns with your needs. Let's discuss further in chat for a detailed strategy. Regards, Amna
$100 USD in 1 day
1.0
1.0

Hello, My location in Florida, United States provides direct security alignment and real-time oversight for your Microsoft 365 tenant data access policies. I will isolate your regional sales data natively within Excel Online by deploying a Power Automate flow and a targeted Office Script. This solution reads your central registry, filters row-level entries securely by territory, and pushes synchronized data out to separate target workbooks on SharePoint. Each regional file will inherit strict file-level viewing rights limited exclusively to your approved list of stakeholders. You can modify this user registry by typing email addresses manually into a tracking sheet or by executing a standard bulk CSV import. Your staff will experience zero visibility crossover. My background in rapid database manipulations and system overhauls is illustrated in my High-Velocity Web Application Refactoring project, ensuring a flawless layout. I will complete this integration and hand off validation reports in four days. Are you open to a chat to check your active M365 licensing? Best regards, Jose
$100 USD in 1 day
0.8
0.8

With my 9+ years of experience in web and mobile development, I firmly believe I am the right person to create a solution that caters to your needs. Let's leverage my expertise in Automation and M365 tools which are key elements for this project. Understanding the need for fluidity and flexibility, a script or automated process is perfectly suited for this task and we can explore various ways to streamline it. The solution I propose would allow you to add authorized users individually or in bulk via CSV/Excel import so that you have maximum control and ease over your data. As a proficient user of Excel Online, I ensure that the solution will work natively on the platform along with thorough documentation that will enable you to modify as per your future needs without any dependencies. Seamless execution and accurate delivery are hallmarks of my work, something I intend to bring forth in this project too. My job doesn't end strictly at implementation; post-deployment, I will conduct comprehensive validation tests with regional users to guarantee their access is limited only to their respective tabs. Rest assured, with me as your partner, you'll attain not only a robust solution but also responsive support throughout the journey. Thank you for considering my proposition.
$113 USD in 7 days
0.0
0.0

Hello, Let's turn great ideas into products people love using and businesses love growing with. The project you have outlined requires a sophisticated solution to ensure secure sheet-level sharing in Excel Online while maintaining data privacy and ease of access for authorized users. To achieve this, I propose leveraging a combination of Power Automate flows and Office Scripts within the Microsoft 365 environment. To address the key points you've highlighted, I will create a custom Power Automate flow that will automate the process of publishing the master workbook to a shared OneDrive/SharePoint location. This flow will include functionalities for both manual entry of authorized email addresses and bulk import from CSV/Excel files. Additionally, I will develop Office Scripts to ensure that each region's sales data remains visible only to approved users, providing a seamless and secure viewing experience. My approach will focus on utilizing native Microsoft 365 tools to ensure compatibility with Excel Online and streamline the deployment process. I will provide detailed step-by-step documentation for easy replication and future modifications, along with validation steps to confirm that regional users can access their respective sheets securely. I would like to discuss further how we can tailor this solution to meet your specific requirements. Could you please provide more details on the existing setup and any additional functionalities you envision for this project? Looking forward to your response. Cheers, Dax.M
$125 USD in 1 day
0.0
0.0

The bid amount and timeline above are rough placeholders, we'll firm them up once we've had a quick look at your tenant setup and talked through a few details. This is a clean permission-isolation problem: one master workbook, many regional tabs, and each user should only ever land on their slice. The tricky part isn't the splitting, it's doing it without VBA and keeping the master as the single place you ever update. We've mapped out a path that keeps things fully cloud-native and lets you add or bulk-update users without needing us again. Here's how we'd approach this: - Architecture: We'll keep your master in SharePoint, then use Power Automate to push each tab's data into its own separate workbook or SharePoint list scoped to that region. Regional viewers never touch the master file. - Permissions layer: Each regional workbook gets its own SharePoint folder with a dedicated permission group. Only the approved emails for that region are in that group, so there's no way for them to stumble into another region's data. - Single-user additions: A small Power Automate form or a simple SharePoint permission UI step (we'll document both) lets you add one email at a time without needing a developer. - Bulk import: An Office Script or Power Automate flow that reads a CSV/Excel list and maps each row to the right regional group, so large updates take minutes instead of hours. - Refresh cadence: The automation runs on a schedule (or triggered by a master update) so regional files always reflect the latest numbers without any manual push. After a short scope chat we'll put together a written proposal covering deliverables, timeline and a firm price. Would a 15 minute call this week work so we can check your M365 tenant configuration before committing to a timeline? Best, 96 Studio
$100 USD in 3 days
0.0
0.0

Hi There, I am an experienced Senior Data Analyst and Engineer with over 15 years of technical experience in database administration, ERP infrastructure, and workflow automation. My background centers on data security, access control, and constructing robust, automated ETL pipelines that translate master data into unified, department-specific views while upholding strict confidentiality. To solve your multi-region access requirement within Excel Online, I will design a cloud-native automation architecture using Power Automate and Office Scripts (TypeScript), completely avoiding desktop-bound VBA. I will create a Master Permissions sheet within your workbook that supports both manual entry and bulk CSV/Excel imports of approved emails per region. The Power Automate flow will trigger upon master data updates, automatically executing an Office Script to split the tabs into individual regional workbooks. These regional files will be published to a secured SharePoint or OneDrive directory, where the flow will dynamically update item-level file permissions so that regional viewers can only access their specific document, ensuring absolute data isolation while maintaining a single master source. I will deliver the fully deployed and tested cloud automation workflows, a step-by-step administration manual for managing permissions, and a structured validation protocol for your users. Let's contact to discuss details. Solutin Vector Roman Khakhula
$110 USD in 7 days
0.0
0.0

Istanbul, Turkey
Member since Jul 5, 2022
€499-501 EUR
₹250000-500000 INR
$80-100 AUD
₹750-1250 INR / hour
$750-1500 AUD
₹1500-12500 INR
$10-70 USD
₹500000-1000000 INR
$3000-5000 USD
₹1500-12500 INR
$15-25 CAD / hour
$15-25 USD / hour
₹12500-37500 INR
$250-750 USD
$250-750 USD
₹1500-12500 INR
₹750-1250 INR / hour
$250-750 USD
$30-250 USD
₹37500-75000 INR
₹1500-12500 INR