Excel ask for 64Bits system

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?

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.

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.

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.

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.

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.

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

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.