•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Idea Company Excel reporting
Our take
Hello,
At Idea Company, we rely on an Excel file hosted on SharePoint, featuring multiple tabs for each department, updated by various team members. Monthly, we export these metrics to PDF, but we frequently encounter synchronization challenges. We're seeking a more efficient solution or alternative tool that can better accommodate our needs. While I’ve considered Power BI, I’m concerned about maintaining essential elements like comments, images, and charts. Your insights on a more cohesive reporting solution would be greatly appreciated. Thank you!
Hello,
At our company, we have an Excel file on SharePoint with several tabs, one for each department, and these tabs are updated by different people. All the metrics are exported to PDF once a month. However, we're experiencing numerous synchronization issues. Do you know of a better solution? Or another tool? I considered Power BI, but this file contains comments, images, and charts.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Cleaning up Excel → PowerPoint workflow for monthly management reportsEvery month I build a management report for board-level distribution. Current workflow: Pull data from source into Excel Build charts in Excel Paste charts into PowerPoint template Spend 45-60 minutes fixing alignment, font sizes, and chart formatting that shifts on paste Export to PDF The main friction points I haven't been able to solve: — Charts lose formatting consistency when pasted across slides (colours shift, font sizes change) — When source data updates I have to rebuild or re-paste rather than refresh — Maintaining consistent styling across 10-15 slides is manual and error-prone I've tried Paste Special → Picture to lock formatting but then charts aren't refreshable. I've tried linking charts directly but the formatting still drifts. We have Power BI available but it's worse for this specific use case, visual customization is too limited for board-level output and the document format is painful to work with. Has anyone solved the refresh + consistent formatting problem in a clean way? Specifically looking for an approach that works across 10-15 slides monthly without rebuilding from scratch each cycle. submitted by /u/Top-Ant-4492 [link] [comments]
- I need a way to combine multiple workbooks to use in a pivot table that can be refreshed through sharepoint.I have 5 spreadsheets in a folder on sharepoint and one on a separate folder in the same team site. These track contacts made by clients. Each workbook is for a LGA (location) and have the same structure. they have a sheet for each month and a table for that month. I initially struggled to use the Sharepoint Folder to combine these so created queries in Power Query. for each workbook I created a query which combined the 12 tables and then created a query which appended them. I was able to put this in a workbook and a pivot table to summarise where we were up to. it worked really well. the permissions were set using organisational account. this lasted about a day and now I cannot refresh it. I can refresh in the power query editor but not in the spreadsheet. I have opened it in the desktop version and also the same problem. I am now getting errors about legacy connections. I then tried the Sharepoint folder which finally worked but seem I can combine the January tables for the five spreadsheets but then I would need to do the same for each month. I would love any suggestions for this to consistently work and refresh from our sharepoint site (excel online). submitted by /u/Eastern_Echidna5680 [link] [comments]
- How do you handle version control when multiple people touch the same Excel file?My team has a shared Excel file on SharePoint that three of us need to update throughout the week. Nothing crazy, just sales forecasts and pipeline data. The problem is we keep overwriting each other's changes accidentally. One person opens it, forgets to close, someone else saves over their work. We tried naming conventions like v2 and v3 but that got messy fast. I know co-authoring exists but sometimes people just don't refresh or they open the desktop version while someone is in the browser. What systems or workflows actually work for keeping things straight without a dedicated data person? Curious if others have found a simple method that doesn't require everyone becoming an Excel expert. submitted by /u/Southwesterhunter [link] [comments]
- Tools for exporting data from PDF to ExcelHi everyone! I started a new job a few weeks ago and a big part of my role involves extracting data from numerous PDFs (e.g., invoice numbers, amounts, total packages, etc.) and entering them into a massive Excel master file. This file acts as a registry and the foundation for other documents. I’m looking for something that saves me from doing 'copy-paste' all day, hundreds of times over. Browsing this group, I noticed some people suggest Power Query for similar tasks, but I’m not familiar with it and would have to learn it from scratch. Does anyone have any tools to recommend, perhaps something more user-friendly than Power Query? submitted by /u/BomboGanoush [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#rows.com#natural language processing for spreadsheets#generative AI for data analysis#financial modeling with spreadsheets#interactive charts#Excel#reporting#synchronization#Power BI#SharePoint#metrics#departments#solution#PDF#file#company#comments