Closed

Excel spreadsheet very slow in Excel 2016

Hello,

I have a spreadsheet that runs fast in Excel 2010, but very slow in Excel 2016. I was not the person who created the spreadsheet but I have to get this spreadsheet to run fast in Excel 2016. The issue is when a value is changed in a cell a series of Formulas get updated. While this happens Excel 2016 states its "unresponsive" for about 60 seconds. Additionally we see the memory consumption spike. If you save and exit the spreadsheet and then go back into the spreadsheet the memory consumption goes back to normal.

I need someone who is VERY good at Excel formulas.

We are looking for someone to identify the issue and then fix it so the formulas run in less than 5 seconds. Perhaps there is a better way to write the Formulas?

Ideally you would already have Excel 2016. If not, I can provide remote access to a PC that has Excel 2016 and the spreadsheet on it.

Due to the confidential nature of the spreadsheet I unfortunately can not share the spreadsheet except with the winning bidder.

Thanks

Skills: Excel, Visual Basic for Apps

See more: spreadsheet excel php write website, making address contact info spreadsheet excel, example weighted criteria spreadsheet excel, excel, microsoft excel, bowling tournament spreadsheet excel, copying pasting excel spreadsheet excel spreadsheet, bank statement spreadsheet excel, copy paste spreadsheet excel websites, copy excel spreadsheet excel spreadsheet, copy pdf spreadsheet excel, copy spreadsheet excel, evaluation spreadsheet excel, copy browser spreadsheet excel code, putting existing spreadsheet excel, word spreadsheet excel, project status spreadsheet excel chart

About the Employer:
( 150 reviews ) Faridabad, India

Project ID: #11379708

16 freelancers are bidding on average $24 for this job

laurajiannaras

Hello, I would like to accept the challenge of identifying problem areas that are causing your Excel workbook (spreadsheet) to take too long to process as it is recalculating cells associated with a change to any pa More

$20 AUD in 3 days
(3 Reviews)
2.5
jesus21282

Dear employer, My name is Jesus Gonzalez, a perfect mix of experience and value for this task. I am a 2yr-experience bachelor telecommunications engineer who have worked for 12months as an Excel data analyst. In More

$25 AUD in 1 day
(1 Review)
1.9
Mamduh9

I have read through the project description and I know am the best man for the job. I currently have a typing speed of 36-45 WPM. Iam will to work over time to get the work done fast for you, if awarde this project. I More

$25 AUD in 1 day
(1 Review)
1.0
shiyardavid

A proposal has not yet been provided

$25 AUD in 1 day
(1 Review)
0.8
sokullu

I'm advanced in VBA. The only problem is that I have 2013 installed here with me. Since the remote access can turn this more difficult than it should be, pick me only if you can't find anyone with 2016. I'll find a w More

$25 AUD in 1 day
(1 Review)
0.8
$25 AUD in 1 day
(0 Reviews)
0.0
nnnssssunil

A proposal has not yet been provided

$25 AUD in 1 day
(0 Reviews)
0.0
roxxano

Hello, I will solve you problem. There are some issues with Office 2016 that can be the cause of slowing down your spreadsheet, one of them can be to disable Cortana (if you are using Windows 10). If you select me More

$15 AUD in 10 days
(1 Review)
0.2
ethanherron5

I work in excel all day every day. Your request seems like a simple task. I have excel 2010 and 2016 along with a team full of people who can solve the problem if I can't. I can remote into your computer if need be, bu More

$10 AUD in 1 day
(0 Reviews)
0.0
sravanipanch

A proposal has not yet been provided

$20 AUD in 1 day
(0 Reviews)
0.0
$25 AUD in 1 day
(0 Reviews)
0.0
$25 AUD in 1 day
(0 Reviews)
0.0
rombai

We are expert in Excel and its formulas. We can solve the problem you got. ............................................................................................................................................ More

$30 AUD in 10 days
(0 Reviews)
0.0
$27 AUD in 1 day
(0 Reviews)
0.0
hashimmughal5722

$20 and 3 days i want work and i hope i do best in the market so give me that project i know [login to view URL] is a good website for people.

$25 AUD in 1 day
(0 Reviews)
0.0
dhruvconversions

I can review your screen and fix this issue. If require, I can re create formulas for the sheet. I have over 7 years of experience working with spreadsheets and automation. Let's discuss your requirement in details. Th More

$23 AUD in 1 day
(0 Reviews)
0.0
kumbharsomnath2

I am VBA macro Expert and have working knowledge of automation development for below applications: 1. Excel 2. MS Word 3. Power Point 4. Web scrapping 5. PDF 6. Mainframe 7. SAP CRM 8. MS outlook mails 9. M More

$25 AUD in 1 day
(0 Reviews)
0.0