Question about Microsoft Office 2007 Basic for PC

1 Answer

EXCEL 2007 sheet is slow in enter data

Sir, I have filled about 200000 cell with data. The problems is slow in entering data like filter, sort etc. How can I get faster fill data

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 189 Answers

This is lot a excel can hold, i dont know how much is the memory of your PC but this is too loarge to hold in memory. Thats why its getting slower.

Posted on Mar 13, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

I want the data when typed into cell A1 in sheet 1 to automatically show in cell A22 in sheet 3


If you're using MS Excel it's easy, go to cell A1 and hit "Ctrl" and "C" to copy the cell, then go to cell A22 in sheet three, type in the "=" sign and paste ("Ctrl" and "v" at the same time) the info into the cell. It should look like: =Sheet1!A1

This is a PC answer, not an Apple answer, but in theory it should work for Apple too.

Nov 22, 2015 | Microsoft Excel for PC

1 Answer

I can not use Dragging actions of mouse in m.s.2007 excel. I unable to drag mouse, auto numbering, auto dates , cut paste etc in m.m. 2007 excel sheet


In Excel 2007 click on Office button where File used to be, then click on Options at the bottom, then on Advanced at the left, then under Editing Options choose the option Enable fill handle and cell drag-and-drop.

I think this should take care of the situation

Jul 10, 2010 | Microsoft Office Professional 2007 Full...

2 Answers

Excel formulas


type in "=" and then go to the cell in the 2nd sheet and click on the cell that contains the value you want carried to sheet 1. Then drag copy the forumula in sheet 1 to all the cells you want it to relate to. Now, if you place a value in e.g. A1 of sheet 2, then that same value will appear in A1 of sheet 1.
Good luck.

Sep 13, 2008 | Microsoft Business & Productivity Software

1 Answer

EXCEL2000 PROBLEM


I think I have a way for you to get this done. Open a.xls and then open b.xls. In b.xls, create a formula in any cell that you want to be updated based on the data in a.xls. For example, if you want cell A1 in b.xls to stay updated with the data from cell A1 in a.xls, your formula in A1 of b.xls would look as follows:
[a.xls]Sheet1!$A$1

You can also create such formulas by following these steps:
1) Open a.xls and then open b.xls.
2) Place your cursor in the cell that you want to update dynamically in b.xls.
3) Enter the equals sign ("=").
4) Click on the "Window" menu in the top menu bar.
5) Select a.xls from the bottom of the menu items in the Window menu.
6) Click on the cell that contains the data that you want.
7) Hit Enter.
If you do all of these steps, you should find yourself back in b.xls with Excel having created the right formula for you. As a test, you can switch to a.xls and make a change in the source cell, and then you should be able to switch back to b.xls and see that same update.

Good Luck, hope this meets your need!
Regards,
RichMTech

Aug 08, 2008 | Microsoft Excel for PC

1 Answer

Validation using Excel VBA code


Thats a lot of form work to be expecting out of Excel. You might be better off using Access, creating a table. If you need to export it back to a spreadsheet you can. The validation controls are better in Access and don't have a lot of limitations to them.

Good luck on that

Jul 21, 2008 | Microsoft Office Professional 2007 Full...

5 Answers

Forgot password to open Excel sheet


If you mean that you can open the Workbook and read the Worksheet - then all you have to do is select all and paste it to another Worksheet. This will allow for changes of formulas etc.

If you mean the whole Workbook - then I dunno.

In future, either use the same password for everything (easy to remember) or Protect the work with nothing entered into the password field (leave this blank). This last will protect the work from people who try to guess your password, but will be easy for you to remember - eg every password is left blank.

If you must use unique passwords, then keep a record of them somewhere other than on your computer.

Sorry I can't help with the "Workbook" solution - but somebody else out ther may be able to do so.

Apr 25, 2008 | Microsoft Office Professional 2007 Full...

2 Answers

Duplicacy in excel sheet


Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.
Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data
Select the entire data and do an auto filter
In column F filter the data by Duplicate and delete all these rows
What remains should be unique data

Dec 19, 2007 | Business & Productivity Software

5 Answers

Formula required


at first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

Dec 04, 2007 | Microsoft Excel for PC

1 Answer

Excel Sort Across Sheets


Hi Raymond, I have a solution for you. Asuming your 'main' sheet is Sheet1. On Sheet2, in the same line as your data on sheet1 (i.e. A5 on sheet1 is JIM), then on A5 on sheet2, enter a link ( the = ) and enter. copy this formula down. Do the same with Sheet3 linking to Sheet1. When you sort Sheet1, Sheet 2 and 3 will follow. Hope this helps. Regards DeltaC

Sep 11, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office 2007 Basic for PC Logo

Related Topics:

244 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

18298 Answers

Tony

Level 3 Expert

2598 Answers

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

Answer questions

Manuals & User Guides

Loading...