Kapalı

EXCEL EXPERT TO FIX LAGGING SPREADSHEET

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)

Beceriler: Veri Girişi, Veri İşleme, Excel, Microsoft Office, Visual Basic

Daha fazlasını gör: excel expert to organize data, expert php help needed to fix and create, find an expert to fix code, how to speed up excel 2013, excel file slow to respond, improve excel performance with large files, excel running slow windows 10, excel slow calculating 4 processors, excel lagging 2016, how to speed up excel processing, how to fix slow excel file, i need an excel expert to come to my office, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s, i want an excel expert who works on my excel sheet according to my requirements, i want to hire an excel expert in the leesburg va area, looking for php expert to help fix simple issue, need an excel expert to organize some data for me i need t, need word press expert to fix website, we are looking typing expert freelancer for my project we have millions of images to type in ms word files separated use font cl, freelancer to fix corrupted excel

İşveren Hakkında:
( 1 değerlendirme ) Smeaton Grange, Australia

Proje NO: #19940468

Bu iş için 34 freelancer ortalamada $169 teklif veriyor

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 Daha Fazla

$250 AUD in 4 gün içinde
(338 Değerlendirme)
7.9
ShiaFirst

Hello, This project is quite easy for me, but I got couple of questions to clear before we proceed [login to view URL] message me to have a quick chat.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(82 Değerlendirme)
6.8
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 in 3 gün içinde
(324 Değerlendirme)
6.8
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 Daha Fazla

$250 AUD in 3 gün içinde
(78 Değerlendirme)
7.0
wsh2

Yikes! - Regardless of MsEXCEL version, that is one slow workbook.. {groan). While there are enhancements we can make to the workbook, the very best performance solution would be to icorporatee the data aspects of the Daha Fazla

$240 AUD in 7 gün içinde
(52 Değerlendirme)
6.3
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(96 Değerlendirme)
5.9
royalcalif

Let me review the spread sheet raw data and your preferable format as well. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(84 Değerlendirme)
5.8
aimefx

Hi, good morning. it is working and there is no white screen in Excel 2016. [login to view URL] However, I can make it better. you have created a new sheet for each day. It is better to use the forms for data en Daha Fazla

$140 AUD in 7 gün içinde
(73 Değerlendirme)
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 in 3 gün içinde
(103 Değerlendirme)
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 Daha Fazla

$99 AUD in 2 gün içinde
(103 Değerlendirme)
5.5
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Daha Fazla

$100 AUD in 2 gün içinde
(100 Değerlendirme)
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 Daha Fazla

$200 AUD in 3 gün içinde
(56 Değerlendirme)
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 Daha Fazla

$200 AUD in 3 gün içinde
(28 Değerlendirme)
5.1
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 Daha Fazla

$140 AUD in 2 gün içinde
(29 Değerlendirme)
4.8
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 Daha Fazla

$61 AUD in 2 gün içinde
(22 Değerlendirme)
3.8
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 Daha Fazla

$250 AUD in 6 gün içinde
(7 Değerlendirme)
3.5
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 Daha Fazla

$833 AUD in 5 gün içinde
(1 Yorum)
2.3
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 Daha Fazla

$120 AUD in 7 gün içinde
(1 Yorum)
2.4
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 in 5 gün içinde
(4 Değerlendirme)
2.0
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 Daha Fazla

$50 AUD in 3 gün içinde
(1 Yorum)
0.6