Ok 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.
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?
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.
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.
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?
When Windows 10 downloads a new build from Windows Update, how can I save the esd file to create an installation DVD running on each computer?
View 6 RepliesOutlook & Excel 2013 (not 365) cannot open emailed excel file after windows 10 upgrade. states file is corrupt cannot open. worked fine before. Had another open same file on their windows 7 it worked fine. I can open excel files that are already in my computer
View 8 RepliesUsing Windows 10 ADK v1511, how do I capture an image directly by saving it in an esd file?
Also, how do I add an image volume, to an esd file?
Have just upgraded to windows 10 and when I try to export a csv file using excel, the file is missing columns and not formatting properly. Have tested same csv file on different laptop (not upgraded to 10) and it's working fine. What I need to do to correct this problem.
View 1 RepliesWhen I download a pdf file (A billing statement in this case), I would like to select "Save As" and be able to select the folder directly from one of the folders shown in Quick Access that is shown in File Explorer without having to rummage through all the folders on my three drives. Right now, "Save As" causes the folder selection to start with My PC. Is there an easy way for the list of folders in Quick Access to be displayed when I select "Save As" to save the file? Starting in My PC makes me go through the mess of finding the folder in which I want to save the file.
View 2 RepliesI'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 RepliesHow 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 RepliesI 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.
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??
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.
I'm looking for a program to make speakers not consume power when no audio is playing. Is it possible?
View 5 Repliesafter 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?
Every time I reboot, the file associations for images (jpg/png), media (mp3/wav/mp4/mkv) revert back to the default Microsoft apps. I prefer to use VLC for videos, Winamp for audio and Irfanview for images, and it's getting really annoying having to set all my file associations every time I boot up. This never happened on Win7 or 8.
View 9 RepliesI have been facing the File System error (-2143326205) ever since I upgraded from Windows 8.1 to Windows 10.
Error description: All Windows Store Apps (Metro/modern/whatever they are called now) crash when I am not online. The Photos app is by far the only app that has given me an error dialog box. I can assume that all apps are crashing for the same reason because all of them start working again when I get back online.
I am not a great fan of these modern apps and the user interface clutter caused by them and hardly use them. But there are some games like Minesweeper that I want to play when I am on the go. I dunno why Microsoft even made calc a modern app (can't even multiply big numbers when not connected).
So far, I have not been able to find a proper solution to this problem. I guess it is a problem in Windows 10 itself and it will take a while for Microsoft to set it right. But I have an idea. Is there any software that creates a fake internet adapter that is always connected to the internet so that the apps think that I am online and don't crash? Is there an actual working solution?
Looks like another annoyance (don't get me wrong, i'm not a 10 hater ) : when i do "open with" and select a portable app, nothing happens :/ Also if in the portable app i tick options such as "show context menu", this won't take effect. All that worked fine on 7.
I dunno for 8.1 but i guess it's same as 10? Anyways, is there a workaround? Can't live without that! Another thing : the great"types.exe" app that we all use(d) on 7 doesn't work here, is there an alternative or not yet? Perhaps it's just not possible at all to have such....
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 Replies