•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Advise on Excel-One file vs multiple Files to use.
Our take
When deciding between using a single Excel file or multiple files to manage your data categories (A, B, C), consider both accessibility and performance. A single file can simplify management and ensure all data is easily accessible, but it may lead to slower performance when working with large datasets. Conversely, splitting data into multiple files can enhance speed and reduce system load, particularly if you typically focus on one category at a time. For format, Excel is user-friendly for analysis, while CSV offers lightweight storage.
I’m stuck with a small doubt and wanted to check what others usually do. I have dashboard picking data from 3 types of data (A, B, C), each of records, and I’m not sure how to store it — whether to keep everything in one single file or split it into 3 separate files (one per category). What I’m trying to understand is which option works better when data is this large in terms of storage space, speed (especially when I only need one category), and overall system load. I checked with two different tools and got opposite answers — one said keep everything in one file, another said split it — so now I’m not sure what makes more sense in real usage. In my case, I mostly work on one category at a time and usually from a local or shared drive. What would you suggest — one file or multiple files, and why? Also, any recommendation on format like Excel, CSV, or something else would really help.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Request for improved methodI work in accounts payable for a company and took over some additional duties a few months ago. One of those duties is keeping a tracker/log of all bills that come in. A tracker in excel was handed over to me. While I’ve improved many things with this tracker so far, I’m looking to make a major change but unsure how to go about it. This tracker has 110k rows of data and has columns with data up to column “FZ”. New rows of data are added daily. Old rows are “archived” as soon as possible. I’m no excel pro, but can hold my own and have learned along the way. Issue: large dataset presents challenges with excel freezing and/or crashing Disclaimer: I cannot remove any rows or columns. Question: is there a better way to handle this data? Ie. tools in excel, using something other than excel, etc? submitted by /u/Visible-Question-786 [link] [comments]
- How to handle data from different sources when columns are in different orders?I regularly get CSV exports from multiple clients. Each client uses their own column order. One puts names in column A and dates in column B, another swaps them. Manually rearranging every time is driving me crazy. What's your go-to method for standardizing columns from different sources? Power Query seems powerful but I'm not sure where to start. I've tried INDEX/MATCH with header lookups, but it gets messy when column names vary slightly. Also open to VBA solutions if they're reusable. Any tips or templates you'd recommend? submitted by /u/biggy_boy17 [link] [comments]
- Slow spreadsheet - need troubleshootingHi, I have a spreadsheet that has two tabs, one is essentially the original data which is YTD driven for a particular GL account, the company has smaller amounts of transactions, so by December we are talking about maybe 3-5k rows of transactions for the account total. The main tab being utilized, has about 30 columns of look up and sumifs formulas referencing the source data and in total approx maybe 500 rows by year end? To me it doesn’t seem excessive. I’ve dealt with way heavier spreadsheets that have more omph and run faster. But for some reason this one is slow as all hell to work in. I’ve even tried barcoded some data and not seen any improvement. I’m not too techy into what else could be slowing it down. And ideas on what to troubleshoot from here? submitted by /u/SlideTemporary1526 [link] [comments]
- Need Excel workflow advice for multi-region data cleanup and tracking progressHi excel pros, I work for a company with about 20k employees, and I’ve got a spreadsheet of roughly 2,000 people who are missing data for two required info columns. These employees are spread out across different regions, and then further down to individual locations/teams. What I need to do is send each region only their portion of the data, have them push it out to their locations to fix, and then somehow track what’s been completed and pull everything back together into one clean file. In the past, I’ve been filtering data, saving separate files, emailing them out, then trying to keep track of who’s done what and combining everything back together. I’m worried I’m going to run into version control issues or miss updates. It’s also very cumbersome and it has ended up just being a big stressful mess in the past. I feel like there has to be a better way to handle this, but I’m not sure if I’m overcomplicating it or missing something obvious in Excel. I’m very much a basic user and not super familiar with more advanced features, but I’m willing to learn. Has anyone set up a process like this before? Appreciate any advice or ideas. Even just “here’s how I’d approach it” would be super helpful. submitted by /u/Magnolia05 [link] [comments]
Tagged with
#Excel alternatives for data analysis#real-time data collaboration#data visualization tools#data analysis tools#big data management in spreadsheets#generative AI for data analysis#conversational data analysis#intelligent data visualization#enterprise data management#big data performance#data cleaning solutions#Excel compatibility#Excel alternatives#financial modeling with spreadsheets#real-time collaboration#rows.com#self-service analytics tools#large dataset processing#business intelligence tools#collaborative spreadsheet tools