Pages

Search

Excel IT Pro Discussions Forum: Excel ODBC / TNSNAMES issue...

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel ODBC / TNSNAMES issue...

Running Windows 7 SP1 (32-bit), Office 2010, Oracle Client 11g, and two System DSNs that point to Oracle databases.  I can resolve both ODBC conenctions via a command prompt and tnsping, and I can connect to the ODBC connections via TOAD for Oracle.

Where I'm stuck is that when I attempt to connect within Excel / Power Pivot, it returns a TNS listener error.  The issue is user specific as I can switch users and connect via Excel with no issues.  Looking for a user-specific setting, registry setting or even a cache setting that may store this info.


Fuel

Excel Help Forum - Excel Programming / VBA / Macros: Copy and Paste Filtered Data

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Copy and Paste Filtered Data
I need to copy all the filtered data only from "Sheet1" over to "Members" currently I am just having it select and copy / paste, but this takes a great deal of time. I've looked through some forums to try and figure this out, but can't seem to locate a helpful answer, any ideas? This is what I...

Excel Help Forum - Excel General: Multiple sumproduct criteria

Feed2Mail notification - new post on Excel Help Forum - Excel General
Multiple sumproduct criteria
First off, let me apologize if the title is misleading. I could not think of a proper way to label or search what I am trying to accomplish. I have attached a sample document to help illustrate the tab layouts. The goal is that if an ID listed on the Search tab under Column G has "SHOW" listed...

Office IT Pro General Discussions Forum: Comctl error on Access 10

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
Comctl error on Access 10

Access 10 database Comctl.ocx comes up with OLE Server error, which prevents the control working.

I have successfully re-registered the controls, mscomct32.ocx, mscomctl2.ocx and comctl.ocx, but the listview function in the application still doesn't work.

The application is running on windows 7

Excel Help Forum - Excel Charting & Pivots: Multiple graph in a single chart using dropdown list

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Multiple graph in a single chart using dropdown list
Hello All, I have a raw data and from the data i have created n no of tables based on pivoting different combination of fields/Columns.Now my manager asking me to give the common single dynamic graph which holds all the graph and he should select which type of graph he want. I came to know...

Excel Help Forum - Excel Programming / VBA / Macros: VBA to Concatenate Variable Range

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
VBA to Concatenate Variable Range
*Dear All,* I have a problem with a worksheet that my company accounting system exports every month. Attached : sample of the worksheet. In column ( F ) , I need a macro to do the following calculations: 1- Check for the Title – if it begins with "Cost Center" 2- Check for the Title – if...

Excel Help Forum - Excel General: Importing data and update, query?

Feed2Mail notification - new post on Excel Help Forum - Excel General
Importing data and update, query?
Hi, I'm looking to create a "tool" with information coming from two different documents (excel), one with price info etc and one with sales figures etc. These individual documents are going to be updated now and then (and need to stay as seperate documents), and I want the combined "tool" with...