Question about Microsoft Office Professional 2007 Full Version for PC

1 Answer

Excel stops responding when i click on a graph data point to see its value

The excel version i am using is excel 2007, the general appearance is great but whenever i use excel to tabulate signal processing results and then plot the results graphically excel takes forever to plot the graphs, and if i try to check the value of a data point by clicking on it excel stops responding alltogether, i dont know if i am using too many data points but i dont think so because i used to perform the same kind of operations on excel 2003 and it worked just fine, i also thougt that my computer wasnt ''good enough'' to run excel 2007 but my computer is actually quite powerful (t8100 2.1 Ghz core2duo processor,3gb ram,nvidia8400gt)so i dont think that its the problem.please help me ,i really like excel 07 and i dont want to go back to using excel 03!

Posted by on

  • mecha_a_z Mar 07, 2008

    no im not using wizards, im using excels built in software (the data is obtained from labview software) all i use excel for is to plot the graphs in a more presentable manner, thanks for the help ill try step 1.

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Mentor:

    An expert who has written 3 tips or uploaded 2 video tips.

  • Contributor
  • 51 Answers

Step 1: Go to Msoft update and make sure you have all the latest Office service packs/issue fixes for Office 2007.

If that doesn't work, go on to:

Step 2: Are you using wizards to create the code to do this functionality and if so, what ones? Post here.

Posted on Mar 07, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I have several excel files stored on my system. I used these files from the same computer daily. Yesterday, when i tried to open several files in Excel 2007 then i found following error on my co,puter...


  • Navigate to the folder containing the XLSX file you want to repair.
  • Right-click the file and select "Copy" and then right-click on a blank space within the folder and select "Paste." This action generates a backup copy of the corrupted file.
  • Open Microsoft Excel 2007 or later.
  • Click the "Office" button in the top left corner of the window and select "Open."
  • Navigate to the folder containing the copy of the XLSX file you generated previously and select it by single-clicking its icon.
  • Click the arrow located to the right of the "Open" button and select "Open and Repair."
  • Select "Repair." If you previously attempted this method and the process failed, try to extract only the values and formulas by selecting "Extract Data" instead. Regardless of the method you choose, your data will appear on the screen within a few seconds if the process completes successfully.
  • Dec 11, 2014 | Microsoft Office Professional 2007 Full...

    Tip

    How to recover Excel 2007 password


    Microsoft Office software developers have been paying more and more attention to the means of protecting users' information, and Microsoft Excel has not been overlooked. Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them. The methods include completely blocking access to a document, forbidding saving changes to it. Besides, some expert team even designed Excel password recovery tool to recover Excel 2007 password for those who have lost Excel password.
    Set a password to open or modify Excel 2007 password
    Set a password to open Excel 2007
    • 1. Click the Microsoft Office Button 3dac3a8.gif, point to Prepare, and then click Encrypt Document
    • fd07008.gif
    • 2. In the Password box, type a password, and then click OK.
    • You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.
    • 3. In the Reenter password box, type the password again, and then click OK.
    • 4. To save the password, save the file.
    Set a password to modify a Excel 2007 Spreadsheet
    • In addition to setting a password to open an Excel spreadsheet, you can set a password to allow others to modify the spreadsheet.
    • 1. Click the Microsoft Office Button office.gif , click Save As, and on the bottom of the Save As dialog, click Tools.
    • 2. On the Tools menu, click General Options. The General Options dialog opens.
    • 3. Under File sharing, in the Password to modify box, type a password.
    • 4. In the Confirm Password dialog, re-type the password. Click OK.
    • 5. Click Save.
    Remove password protection from an Excel spreadsheet
    • 1. Use the password to open the spreadsheet. (Note: If you don't know the open password, you have to recover Excel password with the third Excel password recovery tool)
    • 2. Click the Microsoft Office Button 3dac3a8.gif , point to Prepare, and then click Encrypt Document.
    • 245e5bd.gif
    • 3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
    • 4. Save the spreadsheet.
    Recover Excel 2007 password with Excel Password Unlocker Excel Password Unlocker is a popular Excel password recovery tool that can recover Excel password from Excel 97 to Excel 2007

    on Jun 09, 2010 | Audio Players & Recorders

    Tip

    How to set, modify, remove and recover Excel 2007 password?


    Microsoft Office software developers have been paying more and more attention to the means of protecting users' information, and Microsoft Excel has not been overlooked. Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them. The methods include completely blocking access to a document, forbidding saving changes to it. Besides, some expert team even designed Excel password recovery tool to recover Excel 2007 password for those who have lost Excel password.
    Set a password to open or modify Excel 2007 password Set a password to open Excel 2007
    1. Click the Microsoft Office Button office.gif , point to Prepare, and then click Encrypt Document. excel-document.gif
    2. In the Password box, type a password, and then click OK. You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.
    3. In the Reenter password box, type the password again, and then click OK.
    4. To save the password, save the file.
    Set a password to modify a Excel 2007 Spreadsheet In addition to setting a password to open an Excel spreadsheet, you can set a password to allow others to modify the spreadsheet.
    1. Click the Microsoft Office Button office.gif , click Save As, and on the bottom of the Save As dialog, click Tools.
    2. On the Tools menu, click General Options. The General Options dialog opens.
    3. Under File sharing, in the Password to modify box, type a password.
    4. In the Confirm Password dialog, re-type the password. Click OK.
    5. Click Save.
    Remove password protection from an Excel spreadsheet
    1. Use the password to open the spreadsheet. (Note: If you don't know the open password, you have to recover Excel password with the third Excel password recovery tool)
    2. Click the Microsoft Office Button office.gif , point to Prepare, and then click Encrypt Document.

      excel-document.gif

    3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
    4. Save the spreadsheet.
    Recover Excel 2007 password with Excel Password Unlocker Excel Password Unlocker is a popular Excel password recovery tool that can recover Excel password from Excel 97 to Excel 2007
    Related Office 2007 document password tips:
    How to set, modify, remove and recover Word 2007 password?
    How to set, modify, remove and recover PowerPoint 2007 password?

    on May 21, 2010 | Computers & Internet

    2 Answers

    Size of the excel file increased from 721 KB to 50MB


    Many businesses use Excel to track their data and expenses.
    However, you can run into problems when files grow too big.
    Try reducing the size of your Excel files in different ways to eliminate your storage problems.
    Remove unnecessary graphics and fonts from the Excel file.
    Simple report data doesn't need a lot of excess formatting to make it attractive.
    If you need to keep different fonts in your file, reduce some of the font sizes you originally used.
    Reduce the number of pivot tables you allow in your data analysis.
    Run your pivot table wizard when dealing with involved calculations.
    When given options to format the file, choose those that allow the data to refresh instead of adding a new table.
    Input your data, close the file and save as an Excel (XLS format) file and as an HTML (XML format) file.
    To do this, choose "XML Data" in the "Save as type" drop down box.
    Change the name of your document as well, so you can tell the difference between the two files.
    Open the XML file and save it back into the regular XLS file to create a smaller file than the original.
    Again, rename this file, as well as changing its type. This act removes odd programming left from past calculations since the last "save."
    Check into file compression software such as OzGrid.
    These products exist because you cannot open a file once it gets too big.
    Compress the XLS data by compelling the program to recalculate the cells used for your file.

    Excel File Size Reduce Software 7.0
    http://www.newfreedownloads.com/Business/Spreadsheets/Excel-File-Size-Reduce-Software.html

    http://www.ozgrid.com/

    or

    Microsoft Excel files can contain thousands of cells filled with data.
    When you combine this information with graphics, such as charts and graphs, as well as ever-expanding links to other worksheets, you can end up with an enormous file that takes up precious system space and slows Excel down.
    While there are many software programs available that promise to shrink Excel files, there are many ways to reduce the bulk without downloading a new application.

    1. Click on any cell in the Excel file you want to reduce.
    Open the "Go To" dialog box in Excel 2007 by clicking the "Find" drop-down arrow on the Home tab of the ribbon and selecting "Go To."
    In Excel 2003 or earlier, go to the "Edit" menu and select "Go To."
    You can also use the keyboard shortcut "Ctrl+G" in any version of Excel.
    2. Click the "Special" button on the "Go To" dialog box.
    Select "Blanks" and click "OK." Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
    In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All." This will clear any blank cells to help reduce the file size.


    3. Go to the very last cell containing data in the Excel file.
    Select the entire row beneath this cell by clicking the number to the left of it.
    Hold "Ctrl+Shift" and then press the down arrow key to select all of the cells beneath this point.

    4. Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
    In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All."
    Select the column to the right of the last cell. Hold "Ctrl+Shift" and then press the right arrow key. Again, select "Clear All."
    5. Repeat Steps 1 through 5 for any other Excel files that are linked to the workbook you are trying to reduce.
    Save the files and then check the new file size by clicking the "Office Button" in Excel 2007.
    Point to "Prepare" and then click on "Properties." In Excel 2003 or earlier, go to the "File" menu and select "Properties."
    The file size will be listed on the "General" tab.



    http://www.ozgrid.com/Excel/ExcelProblems.htm

    Apr 22, 2013 | Microsoft Office Professional 2010

    1 Answer

    Reduce the size of excel file


    Many businesses use Excel to track their data and expenses.
    However, you can run into problems when files grow too big.
    Try reducing the size of your Excel files in different ways to eliminate your storage problems.
    Remove unnecessary graphics and fonts from the Excel file.
    Simple report data doesn't need a lot of excess formatting to make it attractive.
    If you need to keep different fonts in your file, reduce some of the font sizes you originally used.
    Reduce the number of pivot tables you allow in your data analysis.
    Run your pivot table wizard when dealing with involved calculations.
    When given options to format the file, choose those that allow the data to refresh instead of adding a new table.


    Input your data, close the file and save as an Excel (XLS format) file and as an HTML (XML format) file.
    To do this, choose "XML Data" in the "Save as type" drop down box.
    Change the name of your document as well, so you can tell the difference between the two files.

    Open the XML file and save it back into the regular XLS file to create a smaller file than the original.
    Again, rename this file, as well as changing its type. This act removes odd programming left from past calculations since the last "save."
    Check into file compression software such as OzGrid.
    These products exist because you cannot open a file once it gets too big.
    Compress the XLS data by compelling the program to recalculate the cells used for your file.


    Excel File Size Reduce Software 7.0
    http://www.newfreedownloads.com/Business/Spreadsheets/Excel-File-Size-Reduce-Software.html

    http://www.ozgrid.com/
    or
    Microsoft Excel files can contain thousands of cells filled with data.
    When you combine this information with graphics, such as charts and graphs, as well as ever-expanding links to other worksheets, you can end up with an enormous file that takes up precious system space and slows Excel down.
    While there are many software programs available that promise to shrink Excel files, there are many ways to reduce the bulk without downloading a new application.

    1. Click on any cell in the Excel file you want to reduce.
    Open the "Go To" dialog box in Excel 2007 by clicking the "Find" drop-down arrow on the Home tab of the ribbon and selecting "Go To."
    In Excel 2003 or earlier, go to the "Edit" menu and select "Go To."
    You can also use the keyboard shortcut "Ctrl+G" in any version of Excel.
    2. Click the "Special" button on the "Go To" dialog box.
    Select "Blanks" and click "OK." Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
    In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All." This will clear any blank cells to help reduce the file size.


    3. Go to the very last cell containing data in the Excel file.
    Select the entire row beneath this cell by clicking the number to the left of it.
    Hold "Ctrl+Shift" and then press the down arrow key to select all of the cells beneath this point.

    4. Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
    In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All."
    Select the column to the right of the last cell. Hold "Ctrl+Shift" and then press the right arrow key. Again, select "Clear All."
    5. Repeat Steps 1 through 5 for any other Excel files that are linked to the workbook you are trying to reduce.
    Save the files and then check the new file size by clicking the "Office Button" in Excel 2007.
    Point to "Prepare" and then click on "Properties." In Excel 2003 or earlier, go to the "File" menu and select "Properties."
    The file size will be listed on the "General" tab.



    http://www.ozgrid.com/Excel/ExcelProblems.htm

    Apr 22, 2013 | Microsoft Office Computers & Internet

    1 Answer

    Does the Graph/Chart option exist for Mac Excel?


    Yes, it does.

    Choose the data in which you want to graph by highlighting said data, including and row/column headings. Then click the icon, which looks like a graph, in the top toolbar which will open up the Chart and Graph Wizard. Then follow the steps and guidelines to create your chart or graph.

    Hope this helps. Have a great evening!

    Feb 17, 2009 | Microsoft EXCEL 2004 for Mac

    1 Answer

    Graph plotting


    Dear rachana, In MS word 2007 you can go to Insert then there are multiple graph patterns given in it, like column, pie and scatter chart. Just put your values in it and it click ok, you will get the chart on worksheet. Its that simple.

    Please press fixya if that was helpful.

    Nov 29, 2007 | Computers & Internet

    1 Answer

    Excel


    i have 2 columns in an excel. One column has data like a,b,c,d,e,f,g,h,i,j,k,l and the other column has values like 0,1,2,3,0,0,0,0,0,5,8,0 respectively. Now i have to generate a graph(pie chart and column chart). But the graphs should not have data and values that have 0 values. i.e, the graph should contain these data and values respectively. data: b,c,d,j,k values: 1,2,3,5,8.

    Sep 23, 2007 | Microsoft Office Standard for PC

    1 Answer

    Excel 2007


    Darcy,select the data and then open the graph option then put the values

    Sep 20, 2007 | Microsoft Office Standard for PC

    Not finding what you are looking for?
    Microsoft Office Professional 2007 Full Version for PC Logo

    365 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Microsoft Computers & Internet Experts

    micky dee

    Level 3 Expert

    2642 Answers

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18346 Answers

    Brian Sullivan
    Brian Sullivan

    Level 3 Expert

    27725 Answers

    Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

    Answer questions

    Manuals & User Guides

    Loading...