EXCEL EXPERT TO FIX LAGGING SPREADSHEET

Ditutup Dipasang 4 tahun yang lalu Dibayar saat pengiriman
Ditutup Dibayar saat pengiriman

We have been using a spreadsheet for numerous years and iterations of Excel. This has now seeing extreme latency. (WHITE SCREEN OF DEATH)

Replicate via copy and paste of rows, insert of rows, deleting of rows/columns

Spreadsheet contains:

- 365 worksheets

- 1 data sheet

- large amount of conditional formatting.

- each worksheet contains 100's of vlookups (have to use non-exact, FALSE)

I have 'cleansed' the sheet of all conditional formatting, refined the vlookups, tried in x64, tried on 32GB machine etc. However, still have this issue. This issue didn't exist in MS Excel 2013 to the extent we are having issue now with MS Excel 2016. (base spreadhseet attached with all conditional formatting still in there)

Entri Data Pemrosesan Data Excel Microsoft Office Visual Basic

ID Proyek: #19940468

Tentang proyek

33 proposal Proyek online Aktif 4 tahun yang lalu

33 freelancer rata-rata menawar $171 untuk pekerjaan ini

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Lebih banyak

$250 AUD dalam 4 hari
(344 Ulasan)
8.0
dgled

Hi, I can collect the daily sheet to one database and then enable you to get a chosen daily report in the TEMPLATE sheet and to print it or export it to PDF or separate excel file. I am an expert and guru in Financial Lebih banyak

$250 AUD dalam 3 hari
(84 Ulasan)
7.1
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

$150 AUD dalam 3 hari
(345 Ulasan)
6.9
lightingdavid

Hello. I 'm expert in "Visual Basic, Data Processing, Data Entry, Excel, Microsoft Office" and I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project description care Lebih banyak

$140 AUD dalam 1 hari
(100 Ulasan)
5.9
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards Relevant Skills and Experience Data entry, excel

$133 AUD dalam 3 hari
(103 Ulasan)
6.2
sourabhg98

Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer, currently at the post of Forum Expert at www.excelforum.com. I checked the attached workbook. Broadly speaking you workbook has Lebih banyak

$99 AUD dalam 2 hari
(121 Ulasan)
5.7
Taisho

Hello, no amount of optimization can make this file in its current state work smoothly. It is an architecture issue. It opens incredibly slow even with manual formula calculation (though it is much more responsive afte Lebih banyak

$200 AUD dalam 3 hari
(64 Ulasan)
5.3
Logo199

I have total 7 years of working experience in process mapping , process documentation , data entry , data analysis and expert in MS office application including MS word , MS powerpoint , MS excel , Photoshop , Adobe Lebih banyak

$140 AUD dalam 2 hari
(35 Ulasan)
5.0
katiewells3

I am an Australian business analyst with over 15 years experience working with advanced level Excel. I would love the opportunity to take a look at optimising your workbook. As you mention there are 365 sheets, would Lebih banyak

$200 AUD dalam 3 hari
(28 Ulasan)
5.1
writingapp

Hi. Do you want replace vlookup by macro vba? Great app writer for your projects. I have writen scraping app for many years. I am ready to write your project. Thank you for visiting my profile

$100 AUD dalam 5 hari
(19 Ulasan)
4.6
maguirrer

Hello, I can help you with this problem, please send me a message with the file .slxm attached, because the file attached is just .xls. And if its possible with an screenshot of the problem. I can start working on it i Lebih banyak

$61 AUD dalam 2 hari
(26 Ulasan)
3.9
arash18k

Hi, Your Excel file is so huge, and that why this happens. The first thing you can do is to save this excel as "Excel Binary Workbook" (It so simple, just go to save as and choose the Excel Binary format), this will he Lebih banyak

$250 AUD dalam 6 hari
(7 Ulasan)
3.5
emilianoreyes70

Hello! Yes, the conditional formatting becomes ver heavy- Its better to merge the data intp one sheet and look to it via visualization or report, it means that some atotumatization (macros) is needed- Im abble to do it Lebih banyak

$120 AUD dalam 7 hari
(2 Ulasan)
2.9
josephmanseau

I see a few possible fixes. First, instead of having 365 tabs for each date, the sheet can be coded so that the date is selected from a drop down menu, or entered manually. A template will populate correctly depen Lebih banyak

$833 AUD dalam 5 hari
(1 Ulasan)
2.3
diepkha

hi I have 6 years of experience and a lot of skills in processing data in Excel VBA. You will get the correct and fast data. I will convert the entire Welding VBA welding form and you will have a file with a very small Lebih banyak

$50 AUD dalam 3 hari
(1 Ulasan)
1.1
outerga

Bonjour, je suis très intéressé par ce projet et j’espère être votre choix car je suis toujours face à des ordinateurs, je connais bien les programmes et je terminerai n’importe quel projet en moins d’une journée.

$55 AUD dalam 1 hari
(0 Ulasan)
0.0
rapidwork25

Dear Conerned, I am interested in doing the above job and will complete it by the deadline given. And pay if you are satisfied with the work. Also if you can elaborate more on the job that how you want the sheet to be Lebih banyak

$240 AUD dalam 5 hari
(0 Ulasan)
0.0
cybertechnologix

I see your Excel sheet and analyses data , i want to suggest you have need an customize application for this purpose, so you can put data in application and fetch or generate reports in any format like execl, cvs, pdf, Lebih banyak

$140 AUD dalam 7 hari
(0 Ulasan)
0.0
aynulhassan5

I have reviewed the excel sheet and there are some changes like formula is complex and there are a lot of searches which are useless are required to be removed using formula changes, which will definitely affect the pe Lebih banyak

$150 AUD dalam 7 hari
(0 Ulasan)
0.0
amiemabunga

I worked as a call center agent in the BPO for more than three years. When I got pregnant, I started my own business. Bookkeeping and social media advertising became very helpful in my business. Relevant Skills and Ex Lebih banyak

$155 AUD dalam 3 hari
(0 Ulasan)
0.0