Over 1 million tech questions and answers.

Excel 2013 file issue

Q: Excel 2013 file issue

Some of my .xlsx files denied to open. One of them showed an error message: File format not valid. Another file not so important how first one. Has somebody know Excel repair ways for my file? Many thanks for everyone?

Preferred Solution: Excel 2013 file issue

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Excel 2013 file issue

I have also had Excel issues in Windows 8 and 10 with Office 365 and know others have, too. An online repair has helped me. Go into the control panel click programs/uninstall and select Office 365...change...online repair. If you have another version of Office let us know.

Read other 2 answers

Excel 2013 can't be opened on my Windows 8.1 laptop, can any Microsoft specialist help me?

Read other answers

Hello there,

I have some users here in the company who work in the same Excel file. It is used for Logistics planning for different countries.
The file is shared and some columns/cells are protected against editing, to prevent the removal of formula's etc.

Now every morning the colleague that manages the file has to restore almost half the sheets because the cell properties are scrambled. Cells that have a value general are changed into currency cells.

This colleague then unshares and unprotects the excel sheets and then restores the cell properties. Next the protection and share is added to the file again.

I do not believe these cells magically change by themselves, But how can we resolve this issue?
I am thinking of a bug in Excel 2013 (maybe the combination of protection/share). And am weirded out by this...

Read other answers

How to open the damaged. XLSX file 2013? The Microsoft Excel "Open and Restore" function doesn't help.

A:Excel xlsx file 2013

Hi, and welcome to TSF.

Try the solutions on this page; https://support.office.com/en-gb/art...a-801ddcd4ea53

Read other 4 answers

How to open the damaged. XLSX file 2013? The Microsoft Excel "Open and Restore" function doesn't help.

Read other answers

Hello All,
I have an issue regarding with one user accessing a Microsoft Excel 2013 Worksheet.  This user was emailed the worksheet and the macro button inside the worksheet will not work.  When she hovers of it, it is unable to be pressed.
The user than sent the worksheet to me to see if I could duplicate the issue the user had.  It opened correctly the way the originally sender intended it to.  I checked the settings within her Excel program to see if they differed from mine and they do not.
Can someone maybe assist me?  If not thanks for taking your time and ready my post.
Thanks ahead of time,
Justin W.

A:Microsoft Excel 2013 Macro Button Issue

is it possibly disabled? im sure you checked but had to ask

Read other 2 answers

I had deleted one of my excel files accidentally. I recovered it using Tuneup utilitites 15. But it showing a error popup. am using win 8.1 and office 2013. I've tried recovery tools but it is not useful and also tried office - open and repair method.. pls any one help me to recover my corrupt excel file or atleast i need all the datas in it.
Whenever I try to open the recovered excel file, it shows popup as in the attachments with this post

A:how to recover data from the excel 2013 file?

Hello there,Can you try another data recovery tool, i.e. Recuva from Piriform?Alex

Read other 4 answers


I converted a large addin from excel 2003 using DAO to access several workbooks.

Now using excel 2013.

The addin works in both Update and read-only modes. A 2nd user logging on will open the workbooks in read only mode automatically.

The conversion to 2013 went well but DAO will not work when the workbooks are opened in read-only mode. I get the error "external table is not in the expected format".

The exact same code works fine when the workbooks are opened in update mode.

Very puzzling - can anybody help?

I am really frustrated as I have a lot of users depending on the outcome. They have to continue using 2003 for the moment.

The line in the code that fails is ...

Set db = OpenDatabase(myfile, False, False, "Excel 8.0")

myfile is an .xlsx file

help very much appreciated

A:Excel 2013 vba - problem with DAO read-only file

Welcome to TSG!
Just started using 2013 my self and was experiencing similar problem. While research mine I found this on StackOverflow concerning switching from ace.oledb to jet.oledb. You may need Jet runtime on your box.

My issue is different in that I wasn't swapping from Jet to ACE. I'm doing 2010 vs 2013. Still researching\testing mine as it seemed to work then quit working. Please post your findings.

Read other 1 answers

I have 2 corrupted Excel files that I store on Microsoft SharePoint.  I store hundreds of other Excel 2013 files there, but 2 recently became corrupted.  Actually, the only 2 that became corrupted were password protected.  When I try to open each file, it says that they can't be opened because they are corrupted.
I've tried every available recover option and advice; recover formula, data, excel recovery software, open and repair, etc.  I believe that because the files are password protected, standard Excel recovery programs won't work.  I've tried 6 of the more common ones that come up in a google search and they all can't repair the file.  I can't remove the password because it won't open due to the corruption.  In other words, I don't have the option to enter a password because it says that it is corrupted before I have a chance to enter a password.
I've heard that it might be ransom ware or a virus, but nothing has popped up on my computer and all of my non-password protected Excel files are corrupted.
I've tried opening and repairing the file with Excel 2007, too...no luck.
I'm running Windows 8.1, Excel 2013.  Both corrupted Excel files are small...less than 300 kb.
I have the password, so has anyone else had this problem?  If not, does anyone know of someone I could hire to extract the data that I had in the spreadsheet?
*I have back-ups of these files, bu... Read more

A:Corrupted password protected 2013 Excel File

Hello, and Welcome
It is probably a long shot but it's possible your Sharepoint is set up to view previous versions. Check this link.

Read other 3 answers

We created an Excel shared file where multiple users can access it on the server, make any edits, then they manually save their changes so that others (after they also manually save the same file) can see those changes.
Since one of the computers is hooked up to an office large screen, we want that file which is being shown on the large screen to automatically save (thus seeing any changes made by others) without having to go to that computer and manually saving (thus updating the file) every 5 minutes or so.
I tried various settings on that PC linked to the large monitor in the options section under Save, but nothing seems to work, forcing me to actually do a manual save every 5 minutes or so.
Can this be done automatically on that PC hooked to the large monitor without having someone do this manually at that PC every 5 minutes or so (or whatever interval time period somebody decides to do this)?
Please assist if at all possible; thank you very much.

Read other answers

Hi Members,

when I open any XLS or XLSX file after few seconds or after doing any activity in any xls/xlsx file, Excel 2013 crashes (Office 2013 is updated to latest). There are no third party plugins enabled in Office 2013.

Note: I don't have any issues with Word 2013 or PowerPoint 2013.

My operating system is Windows 7 Ultimate with SP1 (64 bit)

Below mentioned software's are installed and with real-time enabled...
ESET NOD32 Antivirus 6.0.308.0 (64 bit)
Malwarebytes Anti-Malware 1.70
Zemana AntiLogger
System Explorer 4.0
Stick Password 6.0
Hard Disk Sentinel 4.30
Application Error from Event Log
Faulting application name: EXCEL.EXE, version: 15.0.4454.1503, time stamp: 0x50b592fe
Faulting module name: EXCEL.EXE, version: 15.0.4454.1503, time stamp: 0x50b592fe
Exception code: 0xc0000005
Fault offset: 0x0127b52e
Faulting process id: 0x3e0
Faulting application start time: 0x01ce11ca85e9d41f
Faulting application path: C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE
Faulting module path: C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE
Report Id: d1ff267b-7dbd-11e2-95be-50465db76fa6

Application Log Error message

I don't know what is causing Excel 2013 to crash. Requesting members to help me fix this issue.

Thanks and Regards

A:Excel 2013 crashes after opening and using any xls/xlsx file

Hi Rafales,

Please try start 'Excel' in 'Safe Mode' and check if it works. To start it in 'Safe mode automatically', click this link: http://go.microsoft.com/?linkid=9668693
- Click 'Run' in the 'File Download dialog box', and follow the steps in the 'Microsoft Fix it wizard'

If 'Excel' still does not work as expected, a conflict with another program is likely. Try to restart 'Windows' in 'Safe mode', and perform the previous steps again to run 'Excel in Safe mode'; and check results.

Do reply with the findings; will take it forward from there.

Read other 9 answers

Inside .acc file is a simple text, but the mighty Excel tries to open it like some kind of database. It is asking for accounts, sources, passwords etc. and finally it cannot open it at all. It can open this file if I change extension to something else like .txt or .xls. How can I turn off this useless function of Excel 2013? The Excel of 2003 just opens it without any question.

A:Excel 2013 cannot open simple text file with .acc extension

Hi gacuxz, welcome to Windows Seven Forums.

MS changed Office file extensions from version 2007. This website might it explain it for you.

Microsoft Office file extensions list

When you have opened the file in question, by the method you mention, have you tried saving it, using the Save As option, with a file extension listed in the Save As options list.

Read other 8 answers

Hi community
I try to save an excel sheet with comma, but I always receive semicolon. I know that I have to change Format in Region to English USA, but it still remains semicolon. Can somebody tell me what I could do ?
I am using windows 10 and office 2013 on a HP Pavillon g7 and a few weeks ago this has worked.

A:Excel 2013 saving of csv file comma instead of semicolon doesn't work

Have you seen this Microsoft page?

Read other 2 answers

Hello, I have installed 2013 preview and all has gone well. However, there is a file association issue because none of my office files are recognised.

From within any of the 2013 applications I can open my files, no problem, but opening from outside word for example clicking on a word file on my desktop brings up the which program window. Attempting to create the association through the default programs dialogue does not offer the possibility to associate with 2013 applications as they are not listed.

Your help and guidance is very much appreciated.


A:2013 preview file association issue, none of my office files are recog

Guide download here - might be useful:
Download: Downloadable eBook: Deployment guide for Office 2013 Preview - Microsoft Download Center - Download Details

Read other 1 answers

I cannot search for data in excel 2013. This is new issue. I do notice that in the find window there is an entry for Preview* in the box next to format in the options window that I have never seen before. I get the message cannot find what you are looking for but I know it is there because I am looking at it.

This is new issue. Worked until last night when I was doing a sort and had to make all merged cells uniform in size. Now I can sort but cannot find.

Have closed and reopened excel, but it did not correct problem.

A:Solved: Excel search does not work Excel 2013

Read other 7 answers


I am trying to pull a dashboard view from a "Tracker". Given below is the formula that I used:

=COUNTIFS('KT Tracker'!$T$2:$T$138,$C$2,'Tracker'!$U$2:$U$138,"<="&TODAY()+7,'Tracker'!$L$2:$L$138,'Monthly Dashboard'!$B17,'Tracker'!$AF$2:$AF$138,'Monthly Dashboard'!$A$13,'Tracker'!$AD$2:$AD$138,"<>Cancelled")

This perfectly works fine in my laptop that has excel 2013 but when I email this to my team who have Excel 2010, they only see zeros. We have checked all options like enabling Automatic Calulcation of Formula, removing all named ranges in the sheet etc., but it is just not working.

Can you please help ? This is a bit urgent and I need to present this for a meeting tomorrow.
Appreciate your help and thanks in advance !!!

A:COUNTIFS working in Excel 2013 but not in Excel 2010

It might be something to do with "<>cancelled"

Read other 1 answers


I m currently having an issue with an Excel file on Windows XP Laptop. A user was working on this file yesterday evening with no issues.File was being saved to a network drive and no file save errors were received.When the user came in this morning the file was coming up with a eror message"excel cannot open the file because the file format or file extension is not valid" And also the file is showing up as having 0kb. Tried an excel repair on the file and also opening up in another program like .doc or .txt. Is there any way of finding out what happened this file or fixing the issue. Another user has also reported that the exact same issue happened them last week!!File server is running windows 2003 server. Shadow copies are available and I can restore the file to previous version, however the user did alot of work after that time.


A:Hi,i`m currently having an issue with an excel file

I found this googling it, don't no if it works or even is possible or save to do in Excel.

I've found some success on this. Using Excel 2010, trying to open a file on a network drive, i was getting the "The file is corrupt and cannot be opened" error message. When I added the network drive as a trusted location, I was able to open the file with no problem.

To add a trusted location in 2010, go to FILE>OPTIONS>TRUST CENTER
hit "Trust Center Settings..." button
click on "Trusted Locations" Tab
ensure that you have a check next to "allow trusted locations on my network (not recommended)"
Click "Add new location..." button
In the field labeled "Path" type out the full path name to the network location (ie. \\Drive\directory($)\folder), dont use mapped drive letters
Optional: check "subfolder of this location are also trusted" box.
Now hit OK until you get back to the spreadsheet, and try to open the file again.

source Excel file gets corrupted

Read other 0 answers

Hi I have an ADATA C802 USB pen stick which I keep Word and Excel files on. I am unable to open one of my Excel files which is 80kb in size and just had text and numbers in it (ie no macros or formulas). There are 2 worksheets in the file. I have opened and worked on the file numerous times before with no problem opening it. I last worked on it a week ago, edited some data, added a second worksheet, saved the file, and then changed the file name. When I now try to open it, it comes up with the message as below: "file cannot be accessed. the file may be read-only or you may be trying to access a read only location, or the server the document is stored on may not be responding". My PC is Windows XP, and the Excel file was originally created in Ofice2003. I have tried to open the file using Google Docs, Open Office, ExcelViewer but no luck.... it comes up with the message "file invalid" I have tried recovery tools including "Pandora Recovery" and managed to recover a tmp file from my USB stick which may be an old copy of the file, and opened it using WORDPAD, but it opened up as gibberish. 3) I have tried the tool "Repair my Excel" which scanned the file and then came up with the following messages File Open - OK OLE Header - OK OLE Header Structure Corrupt - X Reading BIFF - OK Another tool I tried "... Read more

A:Excel file issue in XP

HiHere's a couple of ideas.Have you tried renaming the tmp file to tmp.xls?Have you tried viewing hidden files on the USB stick?If so, do you see anything like ~$NameOfFile.xlswhere NameOfFile is the name of your original file?Can you see the file on the USB stick and copy/paste it to your desktop?If you don't know how to do any of the above, let us know and we'll tell you what to do.James

Read other 6 answers

Hi guys,

I'm trying to save an xlsx spreadsheet as a csv. Before doing so, I always format all cells in the xlsx to represent "Text" feature. Then, upon trying to save as csv, I get some warning message about feature incompatabilities with CSV. Even when I save as CSV, the "Text" format cell option has been changed to General. I understand this may be an inconsistency with CSV hence why it was reverted back to general. However, the problem is that a specific column in the CSV doesn't work as it only displays digits when imported into a VB program I'm working with (int32). This causes that column to automatically set non-digit cell values to null. I'm not sure if this is the correct forum to post this in but I'd be grateful for your help.

A:Solved: Excel CSV file saving issue

Read other 11 answers


I have a Windows 7 machine, with explorer 9. This is a work computer. I have to download a file monthly for reports at that time I fill all the information out and then send it back. it is has macros.

Up until 2 months ago, this worked without issue. Now every time I do it, it comes up with an internet connection issue (which there is not). I have reset all the explorer options to default - I have updated java - I have performed all windows updates - I have tried to use explorer 8, still nothing. I then downloaded firefox, and it works effortlessly, unfortunately I cannot send it back (upload it back to the server) with firefox due to something they have in place.

I can go to another computer running windows xp pro and it works no problem. downloads and uploads. This is fine but the information that has to be imported is on my computer from multiple documents.

So any ideas? Where should I be looking next? I have contacted the company that supplies us with the reports and they have no ideas.


A:Issue d/ling excel file with explorer

What is the error message that IE9 gave you?

Can you use IE9 to surf else where?

When you say you have reset IE9, did you go to Internet Options > Advanced > Reset Internet Explorer's Settings ?

Read other 1 answers

Using Phraseexpress, when I open a password protected Excel file, Excel opens with the password box and the blinking cursor. But I am unable to enter any character in the window. I don't understand where the focus of the cursor is shifted. Did any one have a similar problem? Any solution?

Read other answers


I have a spreadsheet that I have linked values to another excel file which is then saved in a .csv format for upload into a price engine. Most all values are correct, except some that have trailing commas. The data contains all the same formatting and I cannot figure out why this is happening. Here's a snapshot of the .csv file. As you can see some have the commas and some don't. Any ideas?



A:Solved: excel file to .csv, trailing comma issue

Read other 6 answers

I have a situation where when I open Excel by double-clicking on a file, a new instance of Excel is opened. I am currently running Excel 2007. When I do this, my PMW does not open with that file.

My work-around is to open Excel from the start menu (where the PMW does open) and then drag/drop file onto the program. It also works to open file using the open file menu in Excel, but this takes a bit longer when accessing files on the network. Any thoughts?


A:Excel 2007 PMW issue when executing file directly

Read other 7 answers

I understand in excel 2007 -- when you build a macro and save it to a personal workbook it saves the file in the xlstart menu and automatically opens behind the scenes when you open an Excel workbook---- My problem is when I build a macro and it asks if I want to save changes to the personal,xlsb file if I click on yes -- from than on, when I open Microsoft excel the standard blank sheet one does not open but the personal.xlsb which is supposed to open but behind the scene. Any suggestions... J.T.

A:Solved: issue with excel 2007 personal.xlsb file

I don't know 2007. But in previous versions you have to hide personal.xls, then close Excel (it'll probably prompt you to save), then re-run Excel & it should stay hidden.


Read other 2 answers

So, I have an interesting issue that I cannot solve.

I have a Microsoft Excel 2010 file created by User A. User A has full permissions to the file. User A has created the document and saved it onto a network share folder. User B also has Microsoft Excel 2010 and can access the network share and can access the Excel file. User B also has full permissions to this file. User B should be able to Read, Write, Execute, etc., with the file. However, when User B attempts to make changes to the Excel file and save the changes to the network share, the user receives an error message reading, "Access Denied. Contact your Administrator."

Initially, we suspected that this was a simple permissions issue. Not the case. Looking further into the problem, I have since copied the entire Excel file into a completely new Excel file, saved the file to the Desktop and then moved the file into the network share location. User B still cannot modify the file and save it. I have renamed the computer to a completely different name and re-added the PC to our domain. Problem still persists.

At this point I'm thinking perhaps the issue lies somewhere within the registry. Rather than try and hunt down the problem, I simply reimage a new hard drive for the user, copy user files, etc., and add the computer to our domain. The problem still persists.

Recently, I have discovered that the problem occurs on other computers as well but only on computers with Microsoft Office 2010. Computers that ... Read more

A:Issue Saving Microsoft Excel file on Network Share

No one?

Read other 1 answers

My group works in a shared excel worksheet (2007)--about 20 people. We're noticing that sometimes changes will be made to cells by a user that isn't even working in that sheet. It will show that he altered or deleted information and the time of the change even though he wasn't working in there. He does however have other excel files opened when this occurs. We did a cleanup/maintenance on the worksheet but it seems to keep happening. This has happened before to other users but recently seems to be happening the most to this guy who happens to be the person assigned to admin the shared spreadsheets. Any ideas?

Read other answers


Need assistance on the below Excel issue.

When we open excel file, other minimised excel files get maximised, help me with the resolution.

Read other answers

Is anyone good at using excel? I need help with making an input box that will allow me to enter numbers, And these numbers will automatically register with my other work sheets in my work book.

A:Excel 2013

Read other 8 answers

I'm trying to open an add in in excel 2013 and I keep getting this message
Compile error
The code in this project must be updated for use on 64 bit systems
Please review and update Declare statements and then mark them with the PtrSafe attribute
I have no clue what to do

A:Excel 2013 error

Most likely you have Office 2013 64 bits installed and the add-in only works on Office 2013 32 bits!

Read other 7 answers

Hi Guys,

Let me start off by stating that I'm still trying to learn all the juicy functions you can do with Excel, and I've just gotten myself a little project where I think I can learn but I need some kind of help from you guys.

Basically what I'm trying to do is somehow automate a creation of a report via excel, first method I thought of was to use macros, but since the data that'll be included in the report will be on a different cell each time, macro might not work as I imagined it to be, then I thought of the IF function, I have not yet tried doing that, but would that work? Can you please share your thoughts? Ask me any additional info and i'll try to explain it as simple as I can.


A:[HELP] Programming in Excel 2013

Your description is entirely too vague in order for anyone to offer any kind of help. Can you be more specific as to what kind of a report you want to generate and what data you will be using?

Perhaps you could post a sample of the worksheet with the data and a sample of what you want the report to look like.

Read other 2 answers

Hi, I have a desktop win7 32 bit OS and installed MS Office 2013. I can print from ms word and other word application accept for excel. Every time I press print a message pops up saying "no printer found". I also cannot set the brother mfc 8910 printer to default printer, it displays a message "operation terminated"

How can I get excel to print and have the printer set as default?
Also I want to know where I can go to see the details / specs of ms office suit that indicates 64 / 32 bit?

A:ms excel 2013 not printing.

Read other 8 answers

I just installed Windows 10 on everyone's laptop here and now I have a bunch of users that their Excel will ocassionally not save or will have graphics issues.  I have tried several suggestions, such as checking their .com add-ins, updating their DisplayLink, and trying to use it in safe mode.  Nothing has been able to fully fix it.  Has anyone else experienced this?  I have heard that Microsoft knows about the issue but has no fixes for it, but I have heard/read that so much that I just don't want to fully believe it.  If anyone has seen this and found a fix can you please help?  Thanks in advance!

Read other answers

That?s new to me and can?t find any answers on the web. The attached snip is from a workbook I made a few months back and all was ok but now as you can see the first row looks like its missing because there are labels on that row which I can?t see.

In addition, the heavy vertical black lines are not mine (when I click on them it says ?Oval Object #...? and there are 2 vertical rectangles which are not mine either.

The only explanation I can give is perhaps an update from MS change all that

If I copy this workbook as an Excel.xls and view it on my other laptop which has Excel 2000 all is normal and copying this normal workbook and open it with my Excel 2013 the same strange things happen again

Any idea how I can recover my original

Read other answers

Running Windows 8.1 and Office 2013. Have a Canon 4370dw Laser Printer connected to my desktop via USB. Have a Brother MFC-J475dw inkjet connected wirelessly to the network. Default printer is the Canon. Here's the problem:

Word - In print dialogue, I can choose to print from either the Brother or Canon with no issues
Notepad - Same. Can choose whichever printer I like
Excel - Can see the Brother printer and it's online. When I click the Brother printer to select it, the Canon stays selected. It simply won't switch to the Brother although the printer dialogue box appears exactly the same in Excel as it does in Word.

Have run printer troubleshooting. Have re-installed Brother drivers and software. Have searched the web for a solution or someone that has had same problem. No luck. Any suggestions on what I can try next or what the problem might be? I'm surprised since I'm assuming that Word and Excel use the same printing module / dll.


Read other answers

Hi, the problem is like this, worked in the Excel spreadsheet before closing saved, turned off the computer. Resuming work in the program it turned out that was gone, all the formulas again, before exiting the program kept((( prompt please, whether probably to recover the data?

A:Failed to start MS Excel 2013

Hi , try to restore using the backup. if this does not help try .xls files repair, you will find him here

Read other 1 answers

how to email a excel sheet or excel workbook direct from excel ?tell me the steps.. all of excel 2007,2010,2013.

A:help about excel 2007,2010,2013 all.

Send as an Attachment>

will send the work book , which will use your default email client on the PC

Read other 2 answers

Windows 7 & Excel 2013 2GB RAM
When I begin typing into a cell, even just the = sign, it stays blank for 2-3 seconds. Seriously !
Any idea what could be causing this? It's like watching grass grow.

A:Excel 2013 freezes and hesitates

Read other 6 answers

I have a g700 laptop and wants to know why F4 & F2 doesn't work as usually with Excel 2013
Is there any possibility to find the same functionnality as I had with Excel 2010 before ?
Thanks for your quick answer 
Moderator Note; subject edited.

A:G700 f4 problem with Excel 2013

Hi alainbrizault,
Welcome to Lenovo Community Forums!
I?m glad to inform you that the F4 & F2 will perform the same functions in Excel 2010 as well as 2013, below are links to check the Keyboard shortcuts in Excel 2010 & 2013:

Keyboard shortcuts in Excel 2010
Keyboard shortcuts in Excel 2013

Do post us back for further queries.
Best Regards

Shiva Kumar

Did someone help you today? Press the star on the left to thank them with a Kudo!If you find a post helpful and it answers your question, please mark it as an "Accepted Solution"! This will help the rest of the Community with similar issues identify the verified solution and benefit from it.Follow @LenovoForums on Twitter!

Read other 9 answers


Please see the attached pic.

In the workbook I am working on in the pic there are 3 pages

page 1. is what looks like the main document that is worked in and it has a drop down menu that I would like to add vendors to a preexisting list (but I can not figure out how)

page 2. is a list of venders mot NOT all of which are in the drop down menu already (if I edit the list the changes do not effect the corresponding vendor that are already listed in the dropdown menu on page1)

page 3. named "sheet 1" seems to be blank and have no function

** in the picture you can see that I highlighted the "VENDOR:" drop-down and right bellow that I am showing the data validation for that drop-down.

I would really like to be able to edit this drop-down list.

Can someone please point me in the right direct?

Let me know if you need any further information!

Thanks a million!

Read other answers

I use quite often the Excel drawing tools for basic wiring diagrams and I find very annoying the format menu.
So a draw a simple line, then I click on format menu to select the color and again to select the line thickness.
Is there any initiation file or similar I can set the default color / line thickness?

A:Excel 2013 Drawing Tools

Why are you using Excel, there are so many other programs out there most are even free!

Read other 1 answers

I was wondering if anyone knows a cure all or a way to fix Office 2013 excel from freezing up.  MS is useless LOL, I have re installed and repaired several times.  I can do a simple cut and paste sometimes or even just want to add a coulmn and it locks up and reboots

A:Office 2013 Excel freezes up way too often

How much RAM do you have? I didn't see your system specs.

Read other 30 answers

Does anyone know why when I try to save some Spreadsheets in Excel 2013 I get a message saying there is a sharing violation and I have to save the file under a different name.

I am the only person using the computer and the Excel program.

Thanks in advance


Read other answers


I am trying to tie one cell into a formula that is being pasted into multiple rows.
I know you can use $ to keep the cell consistent but it doesn't seem to be working.

So if the value is in c9 and then first row gets c9 then the new row gets c10 etc... I need it to be c9 throughout the column.

A:Excel 2013 - how to keep a formula consisten

You use $C9 to keep the column consistent, C$9 to keep the row consistent and $C$9 to keep the cell consistent. Are you doing that and it's not working?

Read other 2 answers

In Windows 8.1, I?m puzzled with the number format in Excel 2013. I write 24000 and the cell shows 240, or I write 10 and the cell shows 0.1

The format cells / number does not have anything to change the format to see the number I type

How can I change the numbers format to see what I write?

Read other answers

Good times of the day ,
I have excel 2013 installed on win8 and i have several excel files on the internet that i try to open simultaneously and here is the problem: sometimes when one file is open and i try to open another it doesn't open until I close the first one. Does anyone have a clue or is this not a proper forum for office 2013?

A:excel 2013 problem on win8

You storing the files on Skydrive? That may be how it works, copy all of the files you need to work with locally, then you'll be able to open them all at once. I think Ofice 2013 gives you one file from a cloud service at a time, thats how most of them work.

Read other 2 answers

Hi All,

So recently I've been having trouble with numerous Excel Spreadsheets on Excel 2013/2010

Issues have included excel freezing, taking a long time to open multiple (large) spreadsheets, copying and pasting taking 3 minutes or more.

Just to give some background; let me start by stating that the excel sheets in question are large in size with lots of links to external sources. I would also add that these spreadsheets where originally created on 2010 rather than 2013. My computer is also running on a corporate network for which i'am an admin.

However, the spec of the machine i'am using, in my opinion, should be more than capable of running these large sheets:

HP Z240
Xeon CPU 3.30GHz
Win 7 Pro

To remedy these problems i have tried numerous troubleshooting including:
Increasing the RAM to 32GB
Turning off protected view via GP
Installing Excel 2010 alongside 2013
Installing 2010 x32
Ensuring all macro's are enabled via GP
Rebuilding the box entirely (software)

None of these have resolved the issues.

I've now found that i have exhausted my knowledge on this issue and so, I'am reaching out to see if any one has any suggestions with how to fix this.

Any help anyone can provide is greatly appreciated!

Read other answers