• Does excel 2007 on Win 7 64 bit create temp files?

    We have a user who was working on a file for a long period of time when the power went out. She had not saved it recently but shouldn’t we be able to grab a temp file? Excel 2007 on a Windows 7 laptop. 64 bit.

    Karl Gechlik9,860 pointsBadges:
  • Proper Excel 2007 macros to identify table

    dear sir/madam i have a table such as the left table and want to extract a table like the right one please give me the proper macro. best regards. hamid [table style="border-collapse: collapse; width: 300pt;" border="0" cellpadding="0" cellspacing="0" width="400"> [col style="width: 63pt;"...

    Hamidirani575 pointsBadges:
  • How to export excel data to Sql server 2005

    How to export excel data to Sql server 2005

    Rasheed1802075 pointsBadges:
  • Multiple Names in Excel 2007

    I have a Excel sheet with hundreds of names and the same person may be repeated twice How do I create a formula so that I can like it to a new sheet and it only show a persons name one time

    Maine325 pointsBadges:
  • Problem in Data Downlod from SAP to Msoffice 2007

    Problem in Data Downlod from SAP to Msoffice 2007. If i use data export option from SAP to Excel 2007 a blank xls sheet open but no SAP data apear in sheet.

    Mkamil5 pointsBadges:
  • I wish to have my macro copy a cell from a tab, then go to another tab and search specifically for the value of the initial cell.

    Hi.  I wish to have my macro copy a cell from a tab, then go to another tab and search specifically for the value of the initial cell.  i.e. the VB code should allow the "Cells.Find(What:=) to be VARIABLE based on what is pasted.  Any suggestions?

    ThomasRichardJohnson5 pointsBadges:
  • VBA Excel – paste not working

    I have the following piece of code attached to my Excel worksheet:         ActiveSheet.Shapes("Object 407").Select         Selection.Copy         Range("BP106").Select         ActiveSheet.Paste The code is activated by making a choice in a drop down in the worksheet. ...

    Paustin5 pointsBadges:
  • Excel limiting access

    I want to be able to give access to a spreadsheet for a certain period of time, or until a specific date. Can this be done, and what is the most effective way?

    AussieNewcastle5 pointsBadges:
  • Embedding Microsoft Excel spreadsheet 2007 into Notes 6.5

    My computer is running Notes 6.5 and Excel 2000. I have a request to display data in Microsoft Excel and for my computer it works fine. But when I try it on a laptop running Vista, Notes 7 & Microsoft 2007 the embedd statement doesn't work. I have it coded as: Set object =...

    Gsplmgc70 pointsBadges:
  • Converting Lotus Approach files to Excel 2007

    I received a Lotus Approach 97 .APR file extension file on a flash drive. I need to import it into Excel (Microsoft Office 2007). I am a beginner with Excel and I need to know the steps required to import the Lotus Approach 97 file on the Flash Drive to Excel. I would appreciate any information or...

    MelanieYarbrough6,345 pointsBadges:
  • Enter key does not get translated when doing a mail merge into word from excel

    We are using Mail merge to automate status report generation for our projects. The data source is excel 2007 spreadsheet. The merge field in excel has multiple lines concatenated with a enter key coded as Char(13) in excel. In some places this key gets translated as _x000D_ in word. This happens...

    Tskn5 pointsBadges:
  • Filter & sort data tables in excel 2007

    When I create a table in excel with data from an external data source using MS query, the resultant excel table doesn't allow me to filter or sort the data (the menu options are greyed out) If I add columns with formulae to the right of my data table, it seems to view the two ranges separately and...

    Helenacvdm5 pointsBadges:
  • excel 2007 chart automation

    hi, I have a code that copy charts from one sheet to another sheet and plot graphs. But when I run multiple instances of excel simultaneously sometimes it copy all graphs and sometimes 2 ,4 or 6 charts. This application is working fine with EXCEL 2003 but with EXCEL 2007 giving above problem....

    Ps777self5 pointsBadges:
  • Excel 2007 Large file issues

    I use Excel 2007 to do a fairly large multidepartmental Financial forecast and results package. The file size is currently at 48,000 KB and will continue to grow. I have this file open along with others of its size at the same time during use. Frequently Excel will crash during an autosave, when...

    Excelguy5 pointsBadges:
  • Matching Items in 2 worksheets

    This is probably incredibly basic and has a simple answer - at least I hope it does.  I am using Excel 2007. I have 2 worksheets run from 2 different systems.  The systems are supposed to have the exact same information, but unfortunately Sheet A has 1350 results and Sheet B has 1365 results. ...

    Natoma5 pointsBadges:
  • Problem refreshing excel 2003 ms query using excel 2007

    I have several ms queries that were created using excel 2003. Now I have excel 2007 and I can't refresh or even edit the queries. I get odbc errors like 'data source name not found and no default driver found. I can create new ms queries in 2007 from the same database with no problem. I just...

    KA5 pointsBadges:
  • Transfer particular pieces of data from Excel into Word over a large number of documents

    Thank you for coming and reading my question! I am trying to write a letter in Microsoft Word 2007 that will be personalized with the names and addresses of about one thousand donors to a non-profit organization. I have a spreadsheet containing everyone's name and address in Microsoft Excel 2007,...

    JeanClaudeWasTaken5 pointsBadges:
  • SQL 2005 SSIS 64 bit EXCEL

    How do you configure driver to read EXCEL 2003 for SSIS on 64 bit SQL Server? How do you configure EXCEL 2007 for SSIS on 64 bit SQL Server?

    Oldmickey65 pointsBadges:
  • Re-linking data source in Word 2007

    I have a bunch of word documents that are linked to an Excel spreadsheet (master sheet) for mail-merge reasons. Now all these documents are templates on a server. I need to Copy-Paste the entire folder (Including all documents and the Excel sheet) onto my computer before editing them. My problem is...

    Minggggy5 pointsBadges:
  • Macro permission in 2007

    As occurs in Excel 2003, I would like to have a dialogue box prompt me when I open a spdsht regarding whether I want the macros enabled.  I have not found that option yet.  Any suggestions?

    Sfe5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following