Excel or something else?

Tim P CFI

New Member
Joined
Feb 8, 2021
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
I need help to determine whether there is a better/more appropriate tool I should use rather than Excel for a data tracking/analysis project. My current process overwhelms and slows Excel to a crawl or prompts a (not responding message).

To be clear, I recognize that my current process could be streamlined and automated in Excel with macros/VBA code: however, my real question is should I be using something other than Excel or something in addition to Excel to perform the analysis I need?

Currently, I have cobbled together multiple Excel Workbooks (5), some containing multiple sheets that I use to analyze and track data that I import/compile from outside sources (reports generated in other apps/software then exported to excel). Most of the source data requires me to manually push a report to Excel including one source from which I use an RTD output to live stream data into excel.

My process has been to get the report data into Excel then use formulas to format, extract, sort, translate, and combine the information (including multiple instances of VLookup across multiple sheets and/or workbooks) in order to prep the data then run the analysis.

After the basic Analysis is run and directed to a single sheet, I then need to produce different output reports formatted based on different queries/criterion such as date, value, size, title, quantity, and in some instances relative value versus numbers from a streaming data source.

My current process seems to overwhelm Excel 2016, even with a reasonable processor speed and RAM on Windows 10 Pro.

Any suggestions are appreciated.
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

diddi

Well-known Member
Joined
May 20, 2004
Messages
3,276
Office Version
  1. 2010
Platform
  1. Windows
cell manipulation of data in excel is very slow compared to using vba and doing array manipulation. vba can also be used to open remote files directly this removing the need for importing a heap of junk. if you are bringing in pdfs, there are simple utilities that convert them to text, which can then be parsed and sorted in vba. and if you really want, the result can be dumped to a text file thus removing all cell manipulation from the project.
the value of using excel is that most people have it so your work can be implemented easily whereever needed. custom set ups are a pain to install
 

Watch MrExcel Video

Forum statistics

Threads
1,127,843
Messages
5,627,215
Members
416,230
Latest member
jdaitchman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top