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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

Excel Error Message.What can I do to stop this error?


A corrupt excel spreadsheet can be repaired by using Open and Repair technique. It is a built-in repair function that opens a corrupt excel file forcefully.
*OpenMS Excel >pressCtrl+O >locate corrupt excel spreadsheet and select it.
*Click on the arrow shown besideOpenbutton>selectOpen and Repair.
It will take just a few seconds to be completed and selected file will be opened, if possible.

Or if this doesn't work, one may take help of a third-party

For example Excel Fix Toolbox
https://www.fixtoolbox.com/excelfix.html

Apr 24, 2015 | Microsoft Office Excel 2007

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...

    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 Business & Productivity...

    1 Answer

    What is the application of Microsoft excel 2007?


    Excel is mainly used for Accounting.
    In offices it is also used to draw up tables, graphs etc.
    I think you can find plenty of sites to learn MS Excel in the Internet.

    Sep 14, 2011 | Microsoft Office Professional 2007 Full...

    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 | Business & Productivity Software

    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 Business & Productivity Software Experts

    Brian Sullivan
    Brian Sullivan

    Level 3 Expert

    27725 Answers

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18297 Answers

    Sudeep Chatterjee
    Sudeep Chatterjee

    Level 3 Expert

    3267 Answers

    Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

    Answer questions

    Manuals & User Guides

    Loading...