Good Morning All



I have a problem that might need a solution. I don't know if the issue is on my side or the client.

A client e-mailed me his workbook on a fortnightly basis (for us to fill in his time sheets) as we do his payroll. He is currently on Microsoft Office 2007. Its quiet a large spreadsheet with conditional formatting etc.

We are on office 2013 Professional. Now here is the problem. Sometimes when we work on the spreadsheet whether to find something using find and replace or inserting amounts or forumlae or functions our excel system freezes (sometimes the system goes blank or hangs) and I have to auto recover the sheet again (auto save is on for 1 min intervals), sometimes I loose half the work due to the Excel crashing and it only saves some of the work

Is it my office system or theirs , I have tried it on different office 2013 Pcs and they do exactly the same Both Office 2013 PCs are patched. However I am unaware of the 2007 Office if its patched or not, will it work if I tell the client to upgrade to 2010?

Looking forward to the reply

It is difficult to tell what the problem is but I am not at all convinced that upgrading to Excel 2010 will help. Hefty use of conditional formatting may be one of more reasons.

I am willing to take a look if you (via personal message) will share the file (hiding sensitive data if necessary).

Its only with this one workbook , the rest is fine. Will let you know.

@ xor
Hi
please do not ask OP's to PM files, the forum should be for everyone to see and learn, don't you think?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi Pecoflyer There its actually a confidential workbook with Salaries on it that I need to be checked why its freezing, If its formatting issues then the solution will be revealed. As I am busy with the book it happens so there is no indefinite screenshot I can attach

@Pecoflyer

I fully agree that the forum should be for everyone to see and learn. I just thought that a PM might be a possibility if RSCOMP don't want to upload the file here at the forum.

I don't see how it is possible to help the OP if we can't some way or other see the file.

Hi

I will upload the file. I just have to ask permission from my client to do so. You will see the file later in a PM