Page 2 - Forum discussion tagged with Excel.
  1. O

    Office files on Phablet

    How can I open Office files (Word and Excel) that I copied from my desktop to my Lenovo PHAB model PB1-750M
  2. V

    Recovered word,excel, and pdf files are split into several fragments. Can I repair them? Thanks!

    Windows 10 updated a few days ago, and my files remained intact except the most important folder on my computer. It got deleted, and I could not find it in windows.old. After that I proceeded to use a recovery software, which successfully found the folder, and all of the files. However, they...
  3. Z

    Help needed with excel function

    Question about excel function, which one to use and how. If I have four columns ( family_id; father_name; mother_name; child_id) in sheet1, and sheet2 I have two columns(child_name; child_id). For example: sheet1: family_id/father_name/mother_name/child_id 111 father1 mother1 01 222 father2...
  4. S

    How to do distribution curve in excel 2013.

    Hi guys, As the title says I am trying to figure out how to do a distribution curve for some data from my calculations. This here the finalised data: http://imgur.com/j3nQMtv And what I am wanting to do is a curve of dt (in micrometers and rounded) vs fm (wt%) distribution curve similar to...
  5. L

    IOS devices, Safari: Excel format fileis mostly blank except for a few columns of correct data

    When i open Excel file which generated from my java based web application in IOS devices some columns are blank. Can you please help me with this? Is there any existing issue with IOS devices with Excel files ?
  6. A

    Microsoft Excel 2010 Copy, Save & Paste Issue

    I have been exporting a report to Excel and then copying it into an email. Today I used the same process, the first thing I noticed that was different was that I had to save the report which I do not need,then when I pasted it into the email, the font was larger and the grid lines appeared...
  7. C

    How to Protect MS Excel File with Password

    Microsoft provides an inbuilt security feature in MS Excel so as to prevent unauthorized access to Excel documents. With this remarkable feature, you can set passwords on Workbook which in turn protect your Excel file by asking for password every time MS Excel file is open. In this tutorial, I...
  8. C

    Excel to copy matching cell row from tabs to a summary tab

    Hello guys, I have a workbook and I need to find the NO values on ROW G (Row 7) and then copy the line that NO belongs to a new sheet (TAB) called summary, in my case it is listed as sheet 18. I need to search on all sheets though from Sheet 1 to Sheet 17 in their G Rows for NO's. I have a...
  9. N

    Can't print from Excel 2010 - all else prints

    Yesterday I could printed a variety of spreadsheets. Today, I can't. I have no idea why. I've tried: - uninstalling and reinstalling the printer - tried to save & resave the document - after driver reinstallation, copied to a new document - looked at the registry entry for the printer, but...
  10. secretumpiratica

    OFFICE 2016 Installer Freezes at 90%!?

    I am running a x64 Windows 7 Home laptop, and I am trying to install Office 2016 Pro on it. The installer freezes around 85% every time I try to install it. I have tried literally everything I can think of with nothing changing it... stopped printer spooler service, sfc scannow, AV scans...
  11. P

    Excel Random Number Generator Code.

    Hie all, Basically i am creating a excel sheet where i would be required to have random numbers in a particular range and in multiples for 5 and all the numbers generated should have the total which is entered. Let me elaborate Input Number- 136400 Random Numbers Range- 12000 to 15000 (Range...
  12. B

    What is the better laptop

    Ok i know there is a whole range of different to consider when saying what the best is but my needs are simple looking to play wow on something besides low on everything, will also be used for some word processing and excel. I have a 1 tb external hd so storage isn't a massive concern 3...
  13. M

    A question about a large Excel file that shouldn't be large

    One of my users in our Sales department showed me an Excel file today that when saved is excessively large. All the rows (approx 30) and columns (approx 15) are all using simple formulas (add left to right, top to bottom, summarize at the end kind of stuff). There are 5 tabs in the spreadsheet...
  14. V

    How can I convert every email hyperlink icon in a '.docx' file to simple text?

    Currently, each email address in the document is behind a hyperlink that's represented by a small white envelope icon (I've attached a picture). I need a contact information sheet that I can print; I need to keep the same text and formatting, and replace the icon with the email address in plain...
  15. A

    Choice of laptop for Business use

    Hi all, I am looking to replace my old Dell Latitude E6430 (i5 3320M with 4 GB Ram) and i need your opinions. I usually have opened several programs like Outlook, Skype and Skype for Business, OneDrive, 4-5 Chrome tabs, one virutal machine, and several excel files that goes from simple ones...
  16. C

    Does anyone have experience with the programs Excel and Access?

    I am drowning in school work tonight and have two simple projects due tomorrow, one for Access and one for Excel. This is an intro to computers class, so the projects are very easy. I will pay someone who can finish these two projects for me, for someone who has experience with these programs...
  17. B

    Suggestion for Work Laptop (Heavy Excel Use)

    Hello, We have MS Surface Pro 3s for work, but we are finding that these machines are not very good at running large (500k rows of data) Excel calculations (v-lookups, sorting, pivots, etc). We are looking into getting a laptop to assist with the number crunching, do you have any suggestions...
  18. W

    Excel Help MINIFS

    Hello you wonderful people, I am a bit stuck on an excel formula if someone could help me out it would be much appreciated. I need a way to calculate the min and max for each product, as I do with the average formula (=AVERAGEIFS(E:E,B:B,B3,C:C,C3,D:D,D3) (=AVERAGEIFS("Value...
  19. M

    Copy Data, Insert Row, Paste Data into inserted row via Macro or other possible means in Excel sheet

    For simplicity's sake, I will be using basic titles and information for an excel workbook, i.e. Sheet1, Sheet2. Background information for the sheets: Columns A will contain parts numbers on both sheets. Sheet2 contains all parts numbers possible for the given assembly. Sheet1 displays the part...
  20. S

    How to restore Microsoft Office from a backup?

    Not sure if this is the right section but oh well. Basically I upgraded to windows 10, but I did a fresh install, so all my apps are gone which is fine, until I forgot I vitally needed Microsoft Office. I have a backup, but I don't want to literally do a backup, my computer was already slow...
  21. S

    Software for importing Pdf data into Excel

    I'm trying to improve our inspection checklist at work to remove a lot of menial tasks. The files we need to have are a digital form that acts as a record of inspection, and a compiled list of those violations. I've tried using the adobe tools but the software is new to me and not as powerful at...
  22. jayendrajpatel

    Automatically extract data from website to Excel sheet

    Actually I don't know that whatever I am going to ask is possible or not. Actually I want to do result analysis of a class which includes Result of all student as wells as subject wise grades, topper of class etc etc..... Now there are so many students ( average 60 students per class & total...
  23. My Life Is Tech

    Please Help: Microsoft Office 95 Professional 7.0b Update

    Does anyone here know where I can find the 7.0b update/ISO for Office 95 Professional? And if you have the update/ISO yourself, would it be possible to upload it temporarily so I can download it? Any help will be appreciated, please reply soon, thank you.
  24. My Life Is Tech

    [SOLVED] Microsoft Office 95/97 Year 2000 Fix/Update

    Does anyone have the year 2000 update files for Microsoft Office 95/97? Their names are as follows: 1. o95y2k.exe 2. o97dtfix.exe If anyone here has these files could you please point me somewhere where I can download them, or could you possibly upload your files somewhere so I can download...
  25. R

    Cheap everyday laptop

    ive been asked to pick my dad a laptop, he uses his current one for general work stuff so (excel word etc) uses the internet a lot, something fast and with a quick start up would be brilliant. Something with slightly above basic graphic capabilites would be nice, just incase i want to do...
  26. J

    Link Excel Sheet to Completed Database

    I have completed a database that has an excel sheet linked to it. The excel sheet is updated regularly on a shared drive. Recently it has been deleted and the database has lost connection with the excel sheet. A new excel sheet has been created, but the database queries and reports will not...
  27. MysteryManX93

    Need help calculating something in Excel

    Wasn't sure if this is the correct section, so please do move if required. Basically, I would like to calculate a cell that takes a value from a sub-total cell, into a cell that would add 20% VAT to it, to make a total.
  28. P

    How can I rescue data from a corrupt Excel 2007 .xlsx file?

    We lost a folder full of excel files last week. We were able to recover all of the files that were in the Excel 2003 .xls format but have been unable to even extract data from the lates two files from May and June that were save in the new 2007 .xlsx format. We've tried the Excel 2007 recovery...
  29. P

    How to repair Corrupt MS Excel file

    How to repair Corrupt MS Excel file? I am using MS Excel 2007 but my Excel file got corrupt due to virus infected. I have crucial important data file corrupt, but how to get back data from corrupt Excel file. Please help me.
  30. sharmi108k

    Access excel file via mobile app

    Is there any app available to access and perform mathematical formulas in excel sheet. If there is any app, then that might help our data entry processes. Suggestion please..
  31. P

    Hyperlink to my web site

    http://[mysite] (My web site) Hyperlink in excel http://[mysite]/ (Not working) Any ideas why anyone.
  32. D

    excel split screen

    How do I split the monitor so I can have 2 excel forms up at he same time
  33. J

    make changes in my ms access table and have them linked to an excel spreadsheet?

    I am working with Access 2013 and would like to be able to make changes in my tables and have them automatically reflected in an excel spreadsheet.
  34. D

    transposing data excell 2008

    I have a long list of husbands and wives where for example: HUSBAND 1's last name is in cell H2 HUSBAND 1's first name is in cell I2 HUSBAND 1's age is in cell K2 On the next row is that husband's wife: WIFE 1's last name is in cell H3 WIFE 1's first name is in cell I3 WIFE 1's age is in cell...
  35. V

    excel 2010 unable to copy paste large data

    Hello I am having issue copy paste large date from one excel to another after copy paste is done excel will stop responding and after few minutes will crash. This is the error LOG: Faulting application name: EXCEL.EXE, version: 14.0.7145.5001, time stamp: 0x54e3daa4 Faulting module name...
  36. C

    Best laptop for business/excel/travel madness?

    I'm a management consultant that does some moderate lifting in excel from time to time. Typically includes power pivot with data in the millions of rows and some VBA. I'm switching jobs and most of my coworkers have some flavor of the Lenovo T series, which seems like a good choice. I'm weighing...
  37. A

    Which software to use for listing things alphabetically ?

    Hi, I have some games that I wanna write down and I wanna do it alphabetically. Now , I tried MS Excel but I am unable to use alphabetic method. For example, I have 4 games starting with "A" and 3 games starting with "M" and 2 games starting with "S" . Now I wrote all those into excel ...
  38. A

    Office 2007 excel problems

    Having trouble with glitches in excel. How best to deal with it, or should opt for Office 2013? Is it more stable?
  39. C

    Problems getting Excel 2013 to run hyperlinks...

    Hi, I have an issue with Excel 2013. I am trying to add Navigation buttons to move around my workbook and I can't. I link the hyperlink to the place I want and try clicking the newly placed button/hyperlink and it throws up this Error Box message: ''Your organisation's policies are preventing...
  40. A

    Which laptop should I get?

    I use my laptop for the following: Office Programs (word, excel, publisher) Smartboard presentations Transported back and forth to work daily web surfing I have had suggestions that I get a business class notebook, but I don't want to buy something without seeing it first. ( I know I can return...
  41. E

    CTB LOCKER VIRUS -XIMSRCI File (.ximsrci)

    My laptop got crashed by CTB locker virus . All my MS excel ,word,PDF files have been changed XIMSRCI File (.ximsrci) I cannot able to open any existing document .Eventhough if i open all datas are in encrypted format . I have lost some most important data(financial datas) . can anyone please...
  42. B

    how can i retrive my previous data in excel.. it was been replace in same sheet??

    My previous data was been replaced by the new data in same sheet in excel...
  43. A

    I am looking for excel fix tool?

    Hi! I’ve recently had a backdoor.trojan infect on Windows Server 2008 R2. It has since been removed. However, it corrupted my very important excel files. Is there a recommended software or tool that can repair these corrupted files? Please advise… Thanks!
  44. T

    Hyperlink in Excel won't open

    Hello, I'm trying to use a hyperlink in my document to a cell in a separate sheet in the same Worksheet. I have finally figured out the formula but when I click on the link it says it can't open it. Any ideas why? Here's my Hyperlink text: =HYPERLINK("['toxicology...
  45. D

    Hyperlink connected to email address

    Hi I have issues with hyperlink in excel which eventually connects to outook email address which c&p@yahoo.com.au. i have tries using %26 istead of & and it still wont work as permanent solution. Ideas???
  46. V

    Excel has stopped working

    I have a problem which driving me crazy and I hope anyone can be able to help me. I use Office 2007 prof. I have some necessary excel files created in old Office 2003. And whenever I am trying to load it in my Office 2007, Excel would be stop with the error :"Excel has stopped working". I tried...
  47. R

    excel2007 problems with i3 4010

    I run two excel files on my i3 4010 based laptop(hyperthreading encbled)in a single instance for my trading where I have to copy data from trader platform to excel file and from there to another excel file with macros which eventually copy data to amibroker. I have to close excel through task...
  48. internetlad

    Merge inventory from one excel spreadsheet to existing sheet?

    Okay, I'm going to try to explain this as thoroughly as I can so there are no mix-ups about what i'm trying to do. I have two existing excel spreadsheets with company inventory on them. The first has the part number and the cost of all items ever put into inventory, the second is for inventory...
  49. E

    I try to open a password protected excel file and I get" not enough memory" " the password is incorrect" any suggestions?

    I use a Mac laptop, Have enough HD storage, but 2 Gb of memory. I emptied trash, runs well, use " clean my Mac" program. I have an excel file password protected that gives me the " not enough storage" error message. Suggestions? Thanks.
  50. D

    Excel connot open file (filename) xlsx

    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 screen: "Excel connot open file (filename) xlsx because the file format or file extension is...
  51. R

    Which version of Microsoft Office should I get?

    Hey, I'm going to buy Microsoft Office for my new computer at Christmas, but I'm not sure which version to buy. It's for one pc, and word, powerpoint and excel are all necessities. There's quite a difference in price (around £25) between Office 365 which is for 1 year, and 2013 Home and Student...
  52. Z

    Compare columns Excel

    Is there an easy way to compare two columns in Excel? I got two construction job offers. The offers are in Excel. The first column contains activity id and the second the price for the activity. The offers are for the same job, but one of the offers has more activity id’s and therefore contains...
  53. P

    64 bit and 32 bit excel together on one machine

    Hello, I'm trying to set up my computer so that it can run both 64 bit and 32 bit Office (mainly Excel). I need 64 bit because I work with fairly large spreadsheets, so being able to utilize more than 2gb of RAM makes a huge difference. However, I also have a few addons I use occasionally...
  54. D

    Upgrade RAM to get Faster Excel Computing?

    Hello everyone, I currently have an ASUS K56CA that i bought almost 2 years ago. It's running the following config: Core i7-3517U with 6GB of Ram I know the computer is only upgradable to a max of 8GB of ram (Two 4GB slots), but really what I'm wondering is this: - I need this computer to...
  55. L

    Date copy/paste problem

    I am using Excel 13 on Windows 7. Usually copying a worksheet is not a problem. However, on one worksheet I receive from a client (which contains dates, formatted with the custom format d,mmm), when I try to copy/paste it, all dates are changed on the new copy to one date earlier than they...
  56. A

    Please Help! Microsoft Excel 2013, Counting individual names from two columns (First Name/Last Name columns)

    Hey guys, I feel like I am at my wit's end here. I am using MS Office Excel 2013 and I am trying to count a list of names. I have tried a few options that did not work. I am also not super proficient with Excel either. I will do my best to explain the situation here. We collect data about the...
  57. C

    Help With Excel 2013

    i am creating a basic combo chart in excel that shows populations of wolfs and deer over time. my x axis is suppose to be from 1991-2000 however i am unable to change the x axis data. i have tried everything. i tried selecting the data and when i do that the "select data source" box says my...
  58. Y

    Programming, Excel and LOL/DOTA/CSGO.

    GREETINGS! AS YOU KNOW BY THE TITLE ALREADY, I WILL BE DOING ALL OF THE ABOVE. IS THIS LAPTOP GOOD ENOUGH? MY BUDGET IS <£400 http://www.currys.co.uk/gbuk/computing/laptops/laptops/hp-15-g092sa-15-6-laptop-black-10011511-pdt.html THANKS!
  59. S

    Will computer run OK without any version of Office installed?

    Do I have to have any version of office running on my windows 7, professional, 64 bit computer? I have excel 2013 stand alone and word 2000 stand alone. Will these two programs run without any form of MS Office on the computer since they are supposedly stand alone? I don't want office on my...