How can I use same Excel files in 64 & 32-bit Systems

Problem Description:

How Can I use same Excel files in 64 & 32-bit Systems?

Is it possible to have a connection setup in an Excel file and be able to refresh on either a 64 or 32-bit system?

I know it’s possible on the same (64 or 32) as long as the DSN’s have the same names but I wasn’t sure about “crossing” between systems.

Solutions:

Yes, You can create a QRemote DSN with the same name on all the machine on which you would like to use Excel.

Your Excel file need to use a common name DSN, For Example, "QODBC-Excel"

Please refer below example:

1) Machine A of 64-bit OS has 64-bit Excel - create a DSN "QODBC-Excel" under 64-bit ODBC Administrator/Manager:

Start >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source 64-bit:

Go To "System DSN" Tab >> Click on the Add button to create a new DSN "QODBC-Excel".

Select the QRemote for QuickBooks option and click on the Finish button.

Configure the DSN enter name "QODBC-Excel" and provide the IP address and Port as listed under “QRemote Server”

Now we can see newly created DSN "QODBC-Excel" in System DSN list.

2) Machine B of 64-bit OS has 32-bit Excel - create a DSN "QODBC-Excel" under 32-bit ODBC Administrator/Manager:

Start >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source:

Go To "System DSN" Tab >> Click on the Add button to create a new DSN "QODBC-Excel".

Select the QRemote for QuickBooks option and click on the Finish button.

Configure the DSN enter name "QODBC-Excel" and provide the IP address and Port as listed under “QRemote Server”

Now we can see newly created DSN "QODBC-Excel" in System DSN list.

3) Machine C of 32-bit OS has 32-bit Excel - create a DSN "QODBC-Excel" under 32-bit ODBC Administrator/Manager:

Start >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source:

Go To "System DSN" Tab >> Click on the Add button to create a new DSN "QODBC-Excel".

Select the QRemote for QuickBooks option and click on the Finish button.

Configure the DSN enter name "QODBC-Excel" and provide the IP address and Port as listed under “QRemote Server”

Now we can see newly created DSN "QODBC-Excel" in System DSN list.

Now you can use same Excel file on above machine whether machine 32 or 64-bit. Also, you can use same Excel file on the different architecture (i.e. You can use 32-bit Excel file on 64-bit Excel vice-versa.)

To apply newly created DSN to old Excel files.

Open Excel file, Please Go To Data Tab & click on "Connections".

You can see existing connection details, please click on "Properties".

Please select connection name & remove it.

Now manually write newly created DSN name for this example it is "QODBC-Excel" & click "OK".

Now you can see updated connection details. Please click on "close".

By clicking on "Refresh All" button, you will get updated data from newly created DSN.