Solved

Excel workbook getting large and cumbersome, Need a better system, any suggestions?

Posted on 2014-04-02
4
353 Views
Last Modified: 2014-04-02
Hello all,

Just wanted to ask some experts out there on opinion of what a person should do.  I have an excel workbook that has been in use for the past 8 or so years that has a lot of data in it regarding equipment serial numbers and notes on what has been done with that equipment and so on.  The file is 5.4mb in size but the problem really is in that it becomes corrupt from being accessed by so many users who have to use it to check on data and enter it as well.  It is cumbersome and whenever it is shared so that multiple users can access at the same time and enter their data, well we all know that is disaster waiting to happen as it doesn't handle that too well.  The data has the first 3 columns used for serial numbers, type/model, and then Date Recieved.  Then the rest of the columns are filled with movement details of the equipment from column G to AZ, and there are 11022 rows.  So long story short I was wondering what would be the best option to organize this data better and what to use for our employees to input data in and allow searches and queries to be done on it for reference.  Is there an easy way to import it into a inventory management system or software? Or what would be my best option? Access? Just reaching out to get ideas for best options.  I am attaching my test sheet that I have so you can see what I am working with.
Inventory-test.xlsx
0
Comment
Question by:IT Tech
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 19

Accepted Solution

by:
Delphineous Silverwing earned 500 total points
ID: 39973074
If you move this data into an Access (or SQL, if you've got it) Database, then you will be able to have multiple persons work on the data, run reports against it, etc, etc.

Begin by making your basic database with the tables and fields you need to be able to import the spreadsheet.  Once you've got your spreadsheet imported, then you can go into designing forms, reports, etc.

Or - you can launch Access then open your Excel Spreadsheet (within Access).  Access will automagically add it as a table using a wizard.  Then you can work from there.
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 39973099
The best solution is to go with Database as expert suggested here.

However as a work around you can start using google docs, where in multiple users can access the data from a single sub system and the chance of corruption will be less, as its maintained by google.

you can start looking out for uploading and working out with google docs solution.. this link will help you in getting started

http://www.wikihow.com/Upload-and-Share-a-Spreadsheet-on-Google-Docs
0
 

Author Closing Comment

by:IT Tech
ID: 39973104
Thank you for the quick reply on this, it was kind of what I was thinking already just needed the confirmation of it mostly.
0
 

Author Comment

by:IT Tech
ID: 39973110
Thank you Waimibm for the additional information. I will look into it as well and see what will suit us.
0

Featured Post

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question