Excel Spreadsheet Look Up Function Showing N/A
May 22, 2012I have done a spreadsheet, I am using the Look Up Function, there are several cells that show th N/A as a result, how do I show these as blanks so I can add them up
View 4 Replies
ADVERTISEMENT
Excel Spreadsheet Sorting It Out?
Nov 19, 2012how I can convert the memberlist table from this particular website: [URL]into a excel spreadsheet with the following sorting headlines horizontally:
Company name Address Zipcode and City Phone E-mail Website
PDF File Data Into Excel Spreadsheet?
Jun 9, 2011I have WIN 7 with Excel 2003. Is it possible to transfer data contained in a .pdf file onto an Ecel spreadsheet ?
View 3 Replies View RelatedLarge Excel 2003 Spreadsheet Keeps Losing Rows Of Data
Mar 12, 2011I have a large 4000 x 25 Excel 2003 spreadsheet that keeps losing rows of data. I normally add 5-10 rows a day and over the last few weeks I have noticed that a couple of days data has disappeared every so often. The sheet is being closed cleanly and saved. Fortunately I have a daily backup so I have been able to go back. the data is there for two days after it was originally entered and then disappears. There has been no restore of the data and the rows have not been accidentally deleted.
View 3 Replies View RelatedExcel 2010 Emailed Spreadsheet Doesn't Save/overwrite The Original
Apr 24, 2012I was recently upgraded to Windows 7 and Office 2010. Under my old version of Windows XP & Office XP/07, when I received an emailed spreadsheet & made adjustments to it, I was able to save it directly over the old emailed file. Now when I make any changes I am asked to save a copy of the file & to save it elsewhere on my computer & cannot save it directly over the original emailed spreadsheet. how to get this old feature back? I'm sure it's just a matter of ticking some option off.
View 7 Replies View RelatedWord / Excel And Photoshop - Delay Before Function Completes
Jun 8, 2012I haven't been able to find out what's interfering with these programs; anything I cut, copy, or want to paste goes through a lengthy delay before the function completes. I did do a restore to a prior restore point. There is a program I don't remember installing; it is called B Updater Service, dated 4/5/12 384KB.
View 25 Replies View RelatedFinding An Edited Spreadsheet Saved From An Email?
Nov 25, 2011I have received a spreadsheet in an email, and have opened it, edited it, saved it (by pressing CTRL + S), but I don't know where it has saved. I know I should have copied it to a folder first before editing/saving.
View 2 Replies View RelatedToolbar On Taskbar Should Only Be Showing An Arrow But Is Showing Icon?
May 18, 2012I have a toolbar on my taskbar titled "Programs". It has about eight folders in it. I made another toolbar, and placed it directly adjacent to the Programs toolbar, to obscure the eight folders and force it to be a dropdown menu.Trouble is, as soon as I lock my taskbar, right next to the arrow that displays the eight items of my Programs toolbar in menu-form, one of the eight items is showing up as an icon, as if the other toolbar isn't close enough to the Programs toolbar in order to completely obscure the eight items.
View 2 Replies View RelatedPendrive Is 4gb Showing 3.75 Gb Data But Showing 576 Kb Only?
Jul 14, 2012i protected password for my pendrive it is kingston 4gb then it showing 3.75b, but in properties it has been showing 576 kb how to get my original size (3.75gb)
View 1 Replies View RelatedWhere The Excel Marco's Are Stored
Mar 16, 2009Before installing Windows 7 I exported the macro's I use in Excel (Office 2007) and made a copy of the Personal.xlsb file. In Vista, the Personal.xlsb is stored at C:Usersuser nameAppDataLocalMicrosoftExcelXLSTART. I have imported the macros into visual basic but I can only save them into that particular workbook and when I reopen Excel, the macros are not avaliable.
View 1 Replies View RelatedExcel Crashing On Start Up
Jan 7, 2013 I have a user at the moment who's excel is crashing at random points of the day. This does seem to happen when there are more than about 3 or 4 excel documents open at a time.
After checking event log, the below shows...
Faulting application name: EXCEL.EXE, version: 14.0.6126.5003, time stamp: 0x505b0834Faulting module name: EXCEL.EXE, version: 14.0.6126.5003, time stamp: 0x505b0834
Exception code: 0xc0000005
Fault offset: 0x003a4865
Faulting process id: 0x10c4
Faulting application start time: 0x01cdecd6e1a7b12b
Faulting application path: C:Program Files (x86)Microsoft OfficeOffice14EXCEL.EXE
Faulting module path: C:Program Files (x86)Microsoft OfficeOffice14EXCEL.EXE
Report Id: a34594be-58d8-11e2-bacd-e89d870c9f2d
I've tried opening in safe mode and that opens fine (although it is a random fault this may not of shown anything...). tried checking com-in add-ins and there are not any installed.
Getting Data From Excel To Firefox?
Oct 13, 2010i have an excel doc with about 300 records all in a cell each, i want to get them all in to a specific field on a website in their own tab in firefox. any one know if this can be done?
View 1 Replies View RelatedFind Two Or More Words In Excel?
Jan 4, 2012I have Office 10 and I go to "find" in my excel spreadsheet and I would like to find "shot", "hospital"". "doctor" without doing 3 searches. So can I imput those 3 words and do a search and it will show me each word as they come up?
View 1 Replies View RelatedCan't Add Values To Excel Graph
Feb 6, 2012I just can't get new data to display on this graph (see below):
[URL]
I enter the values in the table on the left, and they won't show up in the graph! This has just started happening, as you see, the first six sets of values are displaying fine.
Excel Files Can't Open?
Mar 22, 2012My excel files can't open it shows a message 'hot key 1 not working' what it means..?
View 1 Replies View RelatedEnabling Macros In Excel?
Sep 25, 2012to enable macros in Excel I have to go to Developer then enable macro. Err message ordering me to exit the file, then re-enter it and repeat the "enabling" procedure. This does not always remedy the problem. I have to restart the computer... then go back to my Excel worksheet.
However, now even this doesn't work! Result: I am unable to use my macros.
Excel Files Are Not Opening?
Mar 2, 2010I love the new taskbar and the "right click" on a pinned programme to access recent files & pinned files. However, while this feature works perfectly for Word, when I try to open an excel file from the taskbar, or even as an attachment to a received e-mail, I get the message " there was a problem sending the command to the program". The excel program itself opens if it is not already open, but the selected file doesn't. I can only open the file by going through "office button/open". If it is an e-mail attachment, I can only open it by saving it to one of my folders, and opening it via "office button/open". Additionally, once I attempt to open an excel file from the taskbar, the excel symbol on the taskbar displays a yellow/brown border instead of the normal border.
View 9 Replies View RelatedHow To Recover An Excel Workbook
Oct 10, 2011How do I recover an excell workbook that I replace with an empty workbook when I was queried about replacing the existing file with the same title?
View 2 Replies View RelatedExcel Crashes When Cut And Paste?
Feb 16, 2012I have a completely new Lenovo X120e computer - yes my company bought the best (sarcasm). whenever I try to copy from excel and paste into another program the excel crashes. It just shuts down completely and trys to restart.
View 12 Replies View RelatedHow To Use The Freezeframe Facility On Excel Spreadsheets
Aug 27, 2011I can not find how to use the freezeframe facility on Excel spreadsheets and when I click on 'Help' on the right of the sheet get the following message on a black background; 'Aw Snap' Something went wrong while displaying this page. To continue, reload or go to another page'.
View 5 Replies View RelatedExcel Tool Bar Missing Icons?
Oct 1, 2012I have Microsoft 2003 When I open Excel I HAVE the tool bars (File, View Insert etc) on top where it should be. However the icons I put there from Tools function ie Delete columns, font size, copy, cut etc have all disappeared I tried to reinstalling them by going to Tools � Custom-. When I try to select an icon for example Edit � copy or even delete column arrow and try to move it up to the tool bar on top of the page it will not work.
View 1 Replies View RelatedExcel Icon And Application Taking Over?
Feb 3, 2011I'm running Win 7 and have had no problems, but all of a sudden all my desktop applications show with an Excel 2007 icon; same in the task bar. All programs try to open with Excel. I right click and choose properties, change icon, but to no avail. I just downloaded a shareware program and noticed that it also inherited the Excel link.
View 3 Replies View RelatedExcel Jump List Not Updating?
Jul 2, 2012I am using 64-bit Windows 7 and 32-bit Microsoft Office. For a long time I had noticed that the jump list for Excel was not updating in the Start menu. After a lot of research I have made sure that the settings have been made for the lists to actually show, and set the number of documents to show. Jump lists update fine for Word. The internal recent documents in Excel update fine too. However, "Recent documents" in the Start menu doesn't update for Excel files. I have also gone to the various locations recommended and deleted the files to clear the jump lists. That did the job of clearing the lists, but whereas Word, for example, has built up its list again, Excel is still showing nothing. I am opening Excel from the Start menu usually, and it makes no difference whether I open a file from a shortcut, double-click in Explorer or from within Excel, the file never appears in the jump list.
View 9 Replies View RelatedExcel Cannot Complete Task With Available Resources?
Oct 20, 2011From time to time when opening up an Excel workbook, I get a message "Excel cannot complete this task with available reources. Choose less data or close other applications". I am using office 2010 and Windows 7
I have 2GB of RAM and use MSE as my Anti-Virus
BSOD When Exiting Ms Excel 2010
Nov 13, 2011Windows 7 Home Premium 64 bit (original OS)The laptop is about 2 years now. I've tried re-installing office and it worked but then it blue screened again yesterday during an event we were having. I just also had a blue screen a while ago when restarting the system
View 7 Replies View RelatedHow To Open Password Protected Excel
Aug 16, 2011I cannot open Excel document. It is password protected.
View 4 Replies View RelatedAuto-save In Microsoft Excel
Jan 17, 2012when i work microsoft excel save the file automatically . some time i leave my computer that time will be power cut some problem happen in my side so i think it's best way for auto save in Micosoft Excel.if it posiable please tel me friends.
View 3 Replies View RelatedHow To Create Gradereport With Microsoft Excel
Jun 30, 2012I'm trying to create a student's grade report for my teacher using MS Excel.Here's the draft of the report:
1. how can I set the Grade automatically once I insert the score?i.e, once I insert 90marks, the grade there will automatically appear grade A.
2. How can I set the GPA score automatically after the insertion of the Grade according to the grade table below?
3.Since there are about 20 students and the sheet need to print out, how can I save all the 20 students grade and print them out? creating a new sheet for a new student?
there's my problem I faced since I seldom use MS Excel. The format should be like this .
Open Two Excel Sheets In Their Own Windows?
Jul 20, 2012I know before we upgraded, I could open two separate excel files in their own windows, so I can compare, etc without switching back and forth.
I have the newest MSO and running Windows 7 Home Premium.
Shared Excel File Won't Save
Sep 19, 2012I setup a second User account for a friend so an office associate can sign in to access a spreadsheet on his PC. From the Admin's account I shared to the new account with Read/Write privileges. I didn't see any higher sharing permissions but really didn't poke around much.So I get a call from him today that associate is able to edit the spreadsheet but not save it to her account, gets an error. I'm waiting for the text of the error to Google.
View 1 Replies View RelatedOpen Excel File Directly From IE9
Oct 30, 2012I wanted to open an excel file directly from IE9, but when I double click the excel file in the browser, it opens right in IE instead of Excel program. How do I make the file use Excel program to open rather than open in IE itself? I am using Windows 7 and Office 2010. I tried the Microsoft registry fix but still it doesn't work. And the folder options in Windows 7 doesn't have the "Advanced" option.
View 1 Replies View Related