Search results for query: *

But the new file that you paste the PT area to - it becomes like a normal sheet, rite? So its no longer like a pivot table where you can drag columns, re-order, etc? Thanks for the help

Thanks for the response - no, we are not using VBA but simple pivot table using the wizard. The VBA is used only when opening the report through the code (refreshing the query, connection string).

No we don't use Project 2003. It is a simple Pivot Table which can be called from Visual Basic or Access 97 (for refreshing of query and connection string). A user also can double click it and just view the report and move around the columns etc.

Hi We have several pivot table reports (Excel 97) that we distribute to our users. The reports connect to an SQL Server 2000 database. Some of the reports use trusted connection (windows) and others use non-trusted (SQL login). These reports can easily be opened using VBA or in Excel 2007...

My current domain has no Sharepoint. Recently, we installed MOSS 2007 on a test machine and production users began having problems with Outlook e.g. word attachments in email messages. We plan to put our Sharepoint test environment on a separate domain. My question is - is it possible to have a...

Hi I desperately need help on this as well. Someone please answer...... Thanks!!!