Excel

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

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

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

problems with hyperlinks in excel spreadsheets

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

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 ?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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.

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

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.

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

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

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

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.

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

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

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

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

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

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

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

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

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

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!

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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!

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