How to setup a spreadsheet in Excel. This is my first attempt at making a spreadsheet. In this example how do I setup this spreadsheet so that I can keep a running total of columns C,D and E in column F if I keep adding new lines.
View 4 Replies
I'm having an issue, ever since I installed Windows 10(upgraded, then did a clean install), I've been having issues with Excel. I have Office 2013 and everytime I open an excel document, then close it when I'm done, it freezes. Only happens on excel though, Outlook and Word work fine(only other 2 programs I use). I've done the quick repair and the Online slower repair, along with uninstalling and reinstalling Office. None of these have worked. Is this some kind of bug with Windows 10 or is it just me?
View 1 RepliesOk I am a bit stuck here as I need to save a very large csv file to a txt file that has a certain format for it to be used in another application as an import file, I will attach the sample csv files here
My sheet will look like this
And the saved txt file needs to look like this in this format with the first line reflecting the same headings as below.
I have both Excel 2000 and Excel 2013 on my Windows 10 machine for reasons that don't need enumeration here. I am working with a program now that will export/import to Excel, but it looks like it might work only with Excel 2013.
However, when I do the export from the program it always exports to 2000. There is not an options or preferences within the program to choose which version of Excel to direct the export.
Is there some way in Windows 10 short of uninstalling Excel 2000 to make 2013 the default choice?
Since I upgraded to Win 10 I get a UAC query every time I open Excel. How can I make it stop that behavior?
View 1 RepliesI have installed windows 10 pro a couple of days ago and I now experience a strange behavior from excel (office 2013). I suspect this worked when booting new OS for the first time.
When I open any excel file from any location on any hard drive (ssd or hdd) it takes around 10 or more seconds for the file to open. When first opening excel itself and opening any file from inside of excel, everything is instant. This issue is not uncommon, however none of the solutions I found online worked for me.
I also tried to run windows without any non-microsoft services, disabled all start up programs, issue remained. Reinstalled office too. All the other office programs work correctly.
Since I upgraded I cannot open my excel. It was working fine in Win 7. It tells me that I need to download Msvcr90.dll. I did and it seemed to work for Word, but it does not want to open Excel.
View 2 RepliesI can't seem to catch a break since buying a new computer with Windows 10 and UltraHD. I've noticed that every time I open an Excel file, it not only opens that file, but it also opens a blank workbook as well. This has never happened to me on any previous computer or previous version of Excel and googling the issue has been futile thus far.
To be clear, I'm totally fine with Excel opening a blank workbook if I just click on the Excel shortcut on my taskbar, but I do NOT want Excel to open up a blank workbook when let's say I'm opening up a separate spreadsheet for a financial model.
Running W10 pro...with office 365 Outlook/Excel etc...
Opening an excel file within an email gives me 'corrupt' file. If I save the file I will be able to open it up *sometimes*. I have tricked the OS into opening the file by printing from the email attachment and then clicking 'save'. Sometimes that will actually open the excel file but not always.
I even installed excel previewer for mobile and confirmed that excel (desktop) was the app to open excel files but that did not work.
This is happening with Word as well.
In previous windows versions I could resize two spreadsheet windows and drag them side-by-side. With Win 10 if I click on a second spreadsheet it replaces the first.
How do I get two Excel 2000 spreadsheets side-by-side to compare two versions??
I've been running Windows 10 since last August, after upgrading from Win 8.1 on my Asus laptop.
I use the taskbar (launchbar?) to start my favourite programs, such as Excel, and some 8-10 files are stacked on the icon so I can right-click the icon and select/open my desired file.
That was until approximately 10 days ago, when clicking on a file name only opened Excel, and I have to do a file/open within Excel to get the file I want open. Other programs that are also on the bar e.g. my PDF program, still opens the file name I click on.
So jump lists via my taskbar and windows 10, I'm not having much joy. I've just got a new desktop (Jan 2016) with windows 10 pre-loaded and I installed office 2010 - jump lists didn't work - so I thought I'll uninstall and install office 2016 64bit - jump lists still don't work....
But they work for IE and notepad and file explorer but not for firefox or photoshop elements. I've tried deleting the files from:
%APPDATA%MicrosoftWindowsRecentAutomaticDestinations
%APPDATA%MicrosoftWindowsRecentCustomDestinations
And rebooting but to no avail. I really need jump lists working for Excel & Word.
With Win7 I used to be able to copy a recent or pinned file from any MS Office jump list by right clicking and selecting Copy from the context menu.
For Win 10 the menu is still there but when you r/c the file it doesn't appear to be in focus and consequently nothing is saved to the clipboard.This is certainly the case for Excel and Word , I expect it's the same for all Office apps.Can't find anything applicable in the usual places?
So I have Calendar app installed, yet I cannot set it as the default application here:
It says that there is no app or protocol installed for it, yet I do have the Calendar app installed.
When I try to look online at the Windows Store for it, it gives me this message:
Your search for "windows.appointmentsprovider.addappointment" had no results.
"Outlook Setup for iCloud could not be started because of an unexpected error."
How to solve this without knowing what error is causing this?
I have tried reinstalling Office and iCloud (run as administrator) but no luck. Is Windows 10 compatible for iCloud? Apple says no and Microsoft says yes.......
It did worked before, but it slowed down my computer so much that i decided to reinstall the Office package. Everything worked ok after the reinstall and Office programs are running ok. Only I can't get iCloud to sync with Outlook anymore.
Loaded a free copy of Windows 10 a few days ago onto my old Dell insprion 1720 running Win7. All ok apart from setting up Cortana. Will not allow her to select my location. I am UK running English(UK) and UK Keyboard. When clicking on Cortana button only shows Search, Home, Settings and Feedback on Start side bar..
View 9 RepliesI've just followed Brinks amazing Clean Install W10 without having to upgrade guide and it went flawlessly. I'm now in 10 and have been installing drivers, updates and AV/Malware scans and setup. All done - ready to make a post install image using Macrium (which I have also used before on 7) [URL]...
I have followed all the steps (I believe successfully) and now have a separate SSD (not my OS SSD) with an Active Primary partition of 512mb. Ive copied the ISO which macrium created for the Rescue disc to it etc.
I then tried to get into the boot menu he shows in the guide and that's where Ive come unstuck. How to boot from this rescue disc on my other SSD. I'm not even sure copying the ISO to it makes it a rescue environment I can boot from.
I'm trying to setup Cortana and have been doing for some time now.
I've fixed the issues regarding "Not Available in your Country / Region" by setting all my settings to UK and made sure they're all the same.
NOW MY ISSUE is that when I go through the setup of Cortana, it says "Finally I need you to sign in to a Microsoft account", the Window pops up very briefly and the disappears, therefor I CANNOT ADD a Microsoft account.
I have also tried going to Settings -> Accounts -> Other accounts I use
I have gone to "Add extra accounts" and I can successfully add my Microsoft account there, upon logging in I can setup Cortana perfectly fine. However I need it to work with my Domain (Work) account and not signing in with a Microsoft Account (hope that makes sense). Everyone else in my team has managed to link their Domain account with a Microsoft account using the Cortana setup, however I can't as the box just disappears!!!
after upgrading from Win7 Ultimate with Office 2007 to Won10 pro, every time I star Excel or Word or PowerPoint the Windows Installer screen appears and then asks for Microsoft Visual Studio Team System 2008 Development Edition.ENU disk.
How can this be solved?
I have recently installed Windows 10 on my desktop. I now find that most of my files are "read only" I have tried to deactivate this in properties for the various folders but it does not work. Other than trying to copy every file that is currently in use?
View 1 RepliesJust upgraded to Windows 10.I load an Excel file named say "Statistics" from my C:UsersGoogleDrivePersonal folder, I edit the file. I want to save the file with the edits (same name, overwriting existing file).With Windows 7 I just hit the save button within Excel.Now with Windows 10 I can't save to the original location.A message appears " Your changes could not be saved to C:UsersGoogleDrivePersonal folderStatistics because of a sharing violation. Try saving to a different file."
View 4 RepliesI upgraded to windows 10 last night and today I have tried to open excel but it is not working, it simply flashes on the screen then disappears, there are no error messages and it happens if I try to open a file or just the program on its own. This is the main program I use.
View 3 RepliesJust purchased the following computer [URL] .... and have been experiencing quite a few errors already. In addition to many programs' icons being small and almost unreadable (seems to be due to the Ultra HD resolution), I've noticed that every time I open an Excel file, it not only opens that file, but it also opens a blank workbook as well. This has never happened to me on any previous computer or previous version of Excel and googling the issue has been futile thus far.
To be clear, I'm totally fine with Excel opening a blank workbook if I just click on the Excel shortcut on my taskbar, but I do NOT want Excel to open up a blank workbook when let's say I'm opening up a spreadsheet for a financial model.
In Windows 7 and 8, when I saved an Excel input.csv file to a master.csv file, it would just save.
Now in Windows 10, the Excel file opens up and has to be saved manually (file save as...).
Is there a way to get it to just save as it did in Windows 7 and 8, as opposed to having the file open up like that?
Just started to happen. I just upgraded to Win10 . Excel,the up down moves the entire page up and down. How can I get it working correctly?
View 1 RepliesI did the install yesterday - no problem. When I tried to open Word and Excel today, they were empty. All of my files were gone! Can I get them back?
View 1 Replies
