issues from switching office 32bit to 64 bitt

The 32bit versions often limit this as a result of the hard coded limitations of 32 bit MSO. Essentially you give users more memory/higher limits to improperly do things in files that eventually cause corruption. It is possible to write a macro that is compatible in both, but doing so often requires additional code which many VBA programmers either dont know how to do or are too lazy to do.ĭata Connections - While they should work, I have heard of and seen cases in which making data connections to databases and such will not work (or works but requires modifications to the parameters or query) when using 64bit MSO.įile Corruption via poor practices. Not limited to, but largely responsible for this are libraries and API's that have 32/64 bit versions.

Macros - Just about all macros are written in/for 32bit MSO which will not run on 64bit versions without modification. Here are some other important considerations: Has anyone without a specific use case for one version vs the other made the jump to 圆4? Did you end up finding a handful of incompatible add-ins you didn't know where in use?ģrd party add-ins was only part of the reason behind recommending continued use of 32bit MSO. wim because deploying and then updating it during OSD adds about 40 minutes to the imaging process for each system the helpdesk deploys. We use SCCM for operating system deployment and software delivery and Office is the only thing I've baked into the. Luckily our environment is 100% Windows 10 Enterprise 圆4. We're already deploying a 64-bit Oracle client which means we're now stuck deploying a 32-bit Oracle ODBC driver to a medium sized subset of machines so other teams can connect directly to sources in Excel. We've squashed the final widely used 32-bit only add in that one department used.

It seems now their documentation just lays out the reasons you would select one over the other. I remember Microsoft's documentation used to basically say, only deploy 圆4 if you have business need to manipulate large data sets in Excel.

Historically the x86 vs 圆4 Office Client decision was driven by the lack of availability of many 3rd party 64-bit add-ins for Office applications.

Issues from switching office 32bit to 64 bitt