Excel ask for 64Bits system

For some reason, it's been many times we have customer who work on Excel files and it take a lot of time to open it or working on it. It shows a message saying that we need a 64Bits system. But the File is not so big than that. It's on the network and we have done the test copying the file on the computer = same result

do you have any idea ?

It's on Excel 2013 and windows 7 32bits

Regards
pub66Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tel2Commented:
Hi pub66,

I have a few questions for you:
Q1. Please provide a screen shot of the error message.  If you can't do that, then please "quote" the exact wording.
Q2. How big are these spreadsheets (in KB or MB)?
Q3. How many rows (maximum) do they contain?
Q4. Do they have a lot of formulas or buttons or what?
Q5. Are you able to provide us with an sample spreadsheet which has the problem?
Christopher Jay WolffWiggle My Legs, OwnerCommented:
Hi.  I'm guessing the problem might be your client uses 64 bit Office and you have said you use 32.  There are compatibility issues.  The first link discusses why you might choose 32 or 64 versions, and the complications you will run into, so I include it to round out the info here, just for the record.

https://support.office.com/en-us/article/Choose-the-32-bit-or-64-bit-version-of-Office-2DEE7807-8F95-4D0C-B5FE-6C6F49B8D261

Here is where I suspect you may want to spend some time investigating more about what the client is putting into these complicated spreadsheets.  I have highlighted what you might look at in blue.

Differences between 32 and 64 Office.

This if from the following link.

https://support.office.com/en-us/article/Choose-the-32-bit-or-64-bit-version-of-Office-2DEE7807-8F95-4D0C-B5FE-6C6F49B8D261

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Christopher Jay WolffWiggle My Legs, OwnerCommented:
I might have added,  to keep the client happy, you may want to get a machine to dedicate for Office 64 just to work with your client's data, using the reasoning outlined in the links above.
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

tel2Commented:
Hi Chris,

I'm no Excel expert, but which of those items you've raised could result in:
a) speed problems,
b) with no loss of functionality?


Hi pub66,
Chris's comments raise some more questions for me.  Please answer these also:
Q6. Were these slow spreadsheets created in Excel 64bit or 32bit?
Q7. When you say "...it take a lot of time to open it or working on it...", how long (approximately, in seconds) does it take to open them, on average?
Q8. How long does it take to open other (fast) spreadsheets (e.g. small ones recently created with the same PC as you're opening it with)?
Q9. Apart from speed issues, are there any other problems with working with these spreadsheets (e.g. things that don't work)?

Thanks.
Christopher Jay WolffWiggle My Legs, OwnerCommented:
Hi Tel2-
Good questions.  I've never used 64.  I'm only guessing.  :-)  I'm only basing my guess on decades of using Excel and Word.  


Speed issues with no loss of function.
As you may know, if formulae or macros must be translated for file and program compatibility issues, sometimes it involves waiting for timeout limits to be reached while Excel is waiting for something that doesn't exist, or running translating algorithms when things designed to be had are not available, or having to handle memory management differently when an Excel sheet is designed for 64 bit architecture and only keeps finding 32.  Very similar issues in trying to open different file formats of Word docs, where Word tells you what functinality you will lose if you use a different version of Word or save the file in a different format.

As I read pub66 comments it sounded like the error requiring 64 bits is only a lot of the time.  Not all the time.  So I figured some sheets from their client maybe have declare statements or something that cause an error requiring 64 or a rewrite of the declare statement.  Other sheets from the client may not have declare statements so do not fail, but may have other compatibility issues that make it run slow while it looks for things that aren't there.

My experience has shown me that sometimes the software engineering team will design something like a beautiful Excel 64 designed to run on 64 systems and then marketing or someone comes in and says it has to be compatible with 32.  Then they stick some stuff in to make it kinda compatible with 32 and include a list of what you have to still do to get it to run on 32.

I could be wrong.  I've been wrong before.
tel2Commented:
Thanks for that, Chris.

> "I've been wrong before."
Amen to that.  What human hasn't?  I'd guess most of us are wrong in things most minutes of our waking lives, but not all of it is communicated for others to see (e.g. incorrect assumptions and attitudes).  Otherwise we wouldn't have much need for things like backspace keys.
But I appreciate your humility.
Here ends today's philosophy lesson...unless I'm...wrong.
Christopher Jay WolffWiggle My Legs, OwnerCommented:
tel2-
Ahhhh.  Yet another expert with a sense of humor!!  Yes!!

pub66-
I suppose this may take some time since you have to test a theory?  Good luck.
pub66Author Commented:
hi there,

Thanks for all the answer, we are going to investiget because it's not the first time that's happen. I will let you know.

Pablo
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.