Over 1 million tech questions and answers.

Excel 2013 freezes and hesitates

Q: Excel 2013 freezes and hesitates

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.

RELEVANCY SCORE 200
Preferred Solution: Excel 2013 freezes and hesitates

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 freezes and hesitates

Read other 6 answers
RELEVANCY SCORE 68

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
 
Thanks

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
RELEVANCY SCORE 68

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
 
Thanks

A:Office 2013 Excel freezes up way too often

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

Read other 8 answers
RELEVANCY SCORE 63.6

My computer has been hesitating and freezing. It is also very slow to start up. I ran HiJack this. Here is the log. Please advise. Thanks.Logfile of Trend Micro HijackThis v2.0.2Scan saved at 12:27:53 PM, on 7/24/2009Platform: Windows XP SP3 (WinNT 5.01.2600)MSIE: Internet Explorer v8.00 (8.00.6001.18702)Boot mode: NormalRunning processes:C:\WINDOWS\System32\smss.exeC:\WINDOWS\system32\winlogon.exeC:\WINDOWS\system32\services.exeC:\WINDOWS\system32\lsass.exeC:\WINDOWS\system32\svchost.exeC:\WINDOWS\System32\svchost.exeC:\Program Files\Lavasoft\Ad-Aware\AAWService.exeC:\WINDOWS\system32\spoolsv.exeC:\Program Files\Common Files\Apple\Mobile Device Support\bin\AppleMobileDeviceService.exeC:\Program Files\Bonjour\mDNSResponder.exeC:\PROGRA~1\CACHEM~1\CachemanXP.exeC:\WINDOWS\system32\CSHelper.exeC:\Program Files\NavNT\defwatch.exeC:\WINDOWS\system32\svchost.exeC:\Program Files\Common Files\Intuit\Update Service\IntuitUpdateService.exeC:\WINDOWS\Explorer.EXEC:\Program Files\Java\jre6\bin\jqs.exeC:\WINDOWS\System32\svchost.exeC:\Program Files\NavNT\rtvscan.exeC:\WINDOWS\System32\svchost.exeC:\Program Files\Common Files\supportsoft�... Read more

A:computer hesitates and freezes, running slow.

Hello and welcome to Bleeping ComputerWe apologize for the delay in responding to your request for help. Here at Bleeping Computer we get overwhelmed at times, and we are trying our best to keep up. Please note that your topic was not intentionally overlooked. Our mission is to help everyone in need, but sometimes it takes just a little longer to get to every request for help. No one is ignored here.If you have since resolved the original problem you were having, we would appreciate you letting us know. If not please perform the following steps below so we can have a look at the current condition of your machine. If you have not done so, include a clear description of the problems you're having, along with any steps you may have performed so far.Upon completing the steps below another staff member will review and take the steps necessary with you to get your machine back in working order clean and free of malware.If you have already posted a DDS log, please do so again, as your situation may have changed.Use the 'Add Reply' and add the new log to this thread.Thanks and again sorry for the delay.We need to see some information about what is happening in your machine. Please perform the following scan:Download DDS by sUBs from one of the following links. Save it to your desktop.DDS.scrDDS.pifDouble click on the DDS icon, allow it to run.A small box will open, with an explaination about the tool. No input is needed, the scan is running.Notepad will open with the results.Foll... Read more

Read other 2 answers
RELEVANCY SCORE 56.4

Hi, I have a very frustrating problem that just reared its ugly head last night. My computer started hesitating every few seconds, freezes, then starts the cycle all over again. It's difficult to do anything: browse the internet, use applications, or even type this post. I have not added any new hardware or programs recently except I upgraded Firefox last week but it has been running fine up until last night. Plus I uninstalled Firefox and it is still doing the same thing. I have Windows XP home version. So far I have deleted several programs and many other things from my computer that I could do without, I've checked my page file to see if it was correct and it was at the suggested amount, I scanned it with Norton's and it found no viruses, I scanned with Malbytes Anti-Malware and it found nothing infected, I opened up my hard drive case and cleaned/blew out the dust however it wasn't that dirty since I do this on occasion, I made sure my memory was not slipping out, I tried to defragment but my computer said that I do not need to at this time, I restored my computer back to a previous date. None of these things have made a difference. I was sure at least restoring it back would do the trick but it did not.
I'm confused to what the problem is and through my research can't seem to figure this one out on my own.
Does anyone have any suggestions or has anyone had similar problems?

A:Computer hesitates every few seconds and freezes a few seconds then starts this cycle over again

Run hard drive diagnostics: http://www.tacktech.com/display.cfm?ttid=287 (or http://www.bleepingcomputer.com/forums/ind...ive+diagnostic)Make sure, you select tool, which is appropriate for the brand of your hard drive.Depending on the program, it'll create bootable floppy, or bootable CD.If downloaded file is of .iso type, use ImgBurn: http://www.imgburn.com/ to burn .iso file to a CD (select "Write image file to disc" option), and make the CD bootable.NOTE. If your hard drive is made by Toshiba, unfortunately, you're out of luck, because Toshiba doesn't provide any diagnostic tool.=======================================================================================A. If you have more than one RAM module installed, try starting computer with one RAM stick at a time.NOTE Keep in mind, the manual check listed above is always superior to the software check, listed below. DO NOT proceed with memtest, if you can go with option AB. If you have only one RAM stick installed......run memtest...1. Download - Pre-Compiled Bootable ISO (.zip)2. Unzip downloaded memtest86+-....iso.zip file.3. Inside, you'll find memtest86+-....iso file.4. Download, and install ImgBurn: http://www.imgburn.com/5. Insert blank CD into your CD drive. 6. Open ImgBurn, and click on Write image file to disc7. Click on Browse for a file... icon:8. Locate memtest86+-....iso file, and click Open button.9. Click on ImgBurn green arrow to start burning bootable memtest86 CD:10. Once the C... Read more

Read other 13 answers
RELEVANCY SCORE 54

Hi,

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
RELEVANCY SCORE 54

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
RELEVANCY SCORE 49.2

Hi,

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
RELEVANCY SCORE 49.2

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
RELEVANCY SCORE 48.8

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
RELEVANCY SCORE 48.8

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
RELEVANCY SCORE 48.8

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
RELEVANCY SCORE 48.8

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.

Cheers.

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
RELEVANCY SCORE 48.8

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

Read other answers
RELEVANCY SCORE 48.8

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

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

Read other 7 answers
RELEVANCY SCORE 48

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.

Thanks.

Read other answers
RELEVANCY SCORE 48

I hope I have the right forum. I created a drop down list in excel 2013 but I want to link specific data to each selection in the dropdown box to be displayed in other boxes on the spreadsheet. I have the dropdown list on a separate sheet from where I store the data to be displayed.
 
Ex.
select 1 and populate a,b,c,d
select 2 and populate e,f,g,h
select 3 and populate I,j,k,l
etc
 
something like
sales area/     employees
south/             Bob, Jane, Russ
North /            Jeff. Carl, Pat
West/             Richard, Matt, Josh
 
When I pick South I want the corresponding employees to be displayed..
 
I want to link 5 items to the drop down list selection. The data is arranged in a row (left to right) but I have the display boxes arranged in columns (top to bottom). I can change that if need be. only one dropdown box will be used.
 
I have used excel before but still a novice at most of the more intermediate functions.
 
I hope that makes sense 

A:excel 2013 drop down lists

I think you should be able to achieve this with the "vlookup" function.
 
VLOOKUP function

Read other 3 answers
RELEVANCY SCORE 48

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

Peter

Read other answers
RELEVANCY SCORE 48

Does anyone know how to do this?
 

A:How to Normalize data in Excel 2013

Define "normalize".
even better. Take a screen shot of what you see and explain what it is you want.
 

Read other 1 answers
RELEVANCY SCORE 48

Iím in the process to make an Excel (2013) contacts address workbook and have all my contacts in Excel now. I would also like to have some kind of a V-card to be able to input new contacts and view existing ones. A typical V-card could be like the one I downloaded from here

http://www.addressbooktemplate.org/form/

I can make my own V-card but the problem I have is how to integrate the V-card to interact with the contacts database I now have.

Anyone can give me some help or perhaps provide an existing template?
 

A:Solved: Excel 2013 Contacts DB

Read other 16 answers
RELEVANCY SCORE 48

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
RELEVANCY SCORE 48

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
RELEVANCY SCORE 48

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.

File>
Share>
Email>
Send as an Attachment>

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

Read other 2 answers
RELEVANCY SCORE 48

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 
 
Regards
 
Alain
 
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
RELEVANCY SCORE 48

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?

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
RELEVANCY SCORE 48

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
RELEVANCY SCORE 48

Hi

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
RELEVANCY SCORE 48

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

Read other answers
RELEVANCY SCORE 48

Hi,

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
RELEVANCY SCORE 48

Upon opening Excel Office 2013 instantly it configures my Aero setting to BASIC in Windows 7 Professional and then when you close the exit Excel it reverts back to AERO, what gives?  Can this be fixed?

Read other answers
RELEVANCY SCORE 48

I have a Toshiba P855 with 16GIGS of memory and Office 2013. I have been on the phone with Microsoft for 13 months complaining about how Excel 2013 Office Pro keeps crashing randomly. At first they told me my macro was corrupt. I knew it wasn't because it runs all day long on office 2010 on my desktop which has Windows 7 it was on and off with them for weeks and hours and they finally said that it has to be something wrong with my laptop. It will crash sometimes when I go to copy and paste simple task on a new spreadsheet without any Macros or no conditional formatting and it is real pain in the butt. When it does crash I can load that same file to my memory stick, open it on my desktop, close it, re open on my Toshiba Office 2013 and it runs for a while.

Is there ANYTHING that can be causing this from the laptop drivers or other programs. I'm at a lost and feel Microsoft once again is giving me the run around. It gives me different crash reports within excel too so they are not always for the same reason it crashes but when it crashes anything I have open within excel crashes too. It's ONLY excel that crashes. No other programs and my lap top is fine. It is NOT my anti virus. It will crash when I try and cut and paste ONE CELL

Things I have done, repair 3 times, removed and re installed twice, removed all add ons, changed printer spool, bring up in safe mode, reloaded graphics drivers, spoke to Toshiba, BTW Microsoft says its Toshibas fault and Toshiba says its Microsof... Read more

A:Excel 2013 has been crashing for over a year, HELP!!! Tried everything

Hi larbec7.

Read this MS website concerning your problem. Be sure to follow the link shown in the Answer section as it give a lot more info. See if there is anything there that helps you.

Excel 2013 is crashing sometimes with error 0xc0000005 - Microsoft Community

Read other 1 answers
RELEVANCY SCORE 48

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
RELEVANCY SCORE 48

Hello,

We work with an excel sheet with multiple colleagues, This workbook is protected on some columns/fields and the workbook is shared.

Now we have several columns that keep changing it's cell properties. For instance:
Column: License Plate, this should have the property general, but every morning a colleague has to manually change it from date to general again, next morning the same thing.

This colleague has first removed the protection and share, next changed the column property and next put the protection and share on again. In my opinion the right procedure.

Does anyone have an idea what could be causing this?

Thanks in advance,
Wouter
 

A:Excel 2013 cell properties

Read other 13 answers
RELEVANCY SCORE 48

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
16GB
250GB SSD
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
RELEVANCY SCORE 48

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
RELEVANCY SCORE 47.6

Hi all:

I've always had the best luck with previous versions of Excel. It was rare that it crashed on me. I got a new computer with 2013 loaded and it crashes 90% of the time on startup and 95% of the time during use. Sometimes it will work for 5 minutes, others for 10 minutes...but almost always guaranteed to crash. So now I save literally after every cell entry.

I thought it was related to simultaneous use with GoToMeeting, but that no longer seems to be the case. Seems to work OK in safe mode.

Windows and Microsoft are all up to date. Any suggestions on troubleshooting? I have a feeling it is realted to an add in, but can't put my finger on it.
 

A:Excel 2013 - Hangs 90% of time on startup

http://support.microsoft.com/kb/280504
I've had problems before associated with my customised toolbar (with macros). From memory I deleted the *.xlb file used by excel and it was OK.
Mine is located here:
[DRIVELETTER]:\Users\[USERNAME]\AppData\Roaming\Microsoft\Excel
 

Read other 2 answers
RELEVANCY SCORE 47.6

Hi:
Is there a way to freeze multiple rows in Excel 2013. I have tried but no joy.
 

A:Freezing Multiple Rows Excel 2013

you can freeze panes - but it only freezes rows 1 and below
or column A and to the right
put your cursor on the row below the one you want to freeze - say row 6
click in A6 - if you do not want any columns to be frozen
now goto View on the ribbon
Freeze Pane
1st option
a line appears just under row 5 and those rows are now frozen
If you click on any other column - say C6
the columns A and B are also frozen
 

Read other 2 answers
RELEVANCY SCORE 47.6

hello
I bought a new pc with Win7 pro, 64bit. It came with a intro version of Office which I added the full version mth ago.
All of sudden I can't run Excel or Word. I get a popup saying the file not compatible with the ver of Win I am running.

Anyone see this issue before ?? Could this be a virus ??
I was thinking of running system restore to back a few days ago. I started to have some redirect issues on Firefox as well after downloading a Media Player Codec Pak from CNET. I always say no to the add-ons - but I get them anyway. It's irritating.

Thanks
Lotus

A:[SOLVED] Excel 2013 doesn't open

Re-install Office; choose "repair" option.

Read other 3 answers
RELEVANCY SCORE 47.6

Good day everyone and thank you for reading my post.

I'm in trouble and need help. I am a statistician that LIVES by Excel. And my Excel is broken. I had 2007 since I started by business 6 years ago. About a month ago Excel started crashing intermittently when saving work on my employee's computer. Then it started on mine. Our data is stored in the cloud through www.cubby.com. I have full antivirus protection on all my computers with N360 (never even 1 time used a computer without antivirus protection since the early 1980's). Never had a virus get through N360.

There is no rhyme or reason why the crashing is happening. It only occurs on saving, and happens intermittently. I open a sheet, save it as a different name (to keep the original sheet unharmed) and it crashes. I open it immediately again, try saving again, and it works. I have tried saving on different physical drives and there is no difference. I mainly work with a single spreadsheet template and that is the one crashing. It may happen with other sheets, but I really never use other sheets to test it with.

I upgraded to Office 2013 early December 2014, hoping that would fix things, and it doesn't.

When we try to reopen those same spreadsheets that we saved during the crash, we get an error message stating the file is corrupted and cannot be recovered.

My spreadsheet templates (I designed from scratch myself) are about 1.5MB in size and do have macros. The macros are ones I programmed myself, ... Read more

A:Excel 2007 & 2013 crashing when saving

Read other 10 answers
RELEVANCY SCORE 47.6

Maybe this can't be done.

Column D is my bank balance and I don't want everyone seeing it. Especially my wife who tends to spend more at the store if she sees it while I figure how much she can spend.

What I'm trying to do is to keep only the last 4 digits visible. 549.67 would only show 549.67 until I drag the mouse over it with left button down.

My wife only has one allergy. Money

A:Excel 2013 Help needed with a Conditional Format

Is this anywhere close?

font color=Automatic
=If>4 digits(left digits=White)
or smaybe something like
font color=White(last 4 digits=Automatic) ?

Read other 6 answers
RELEVANCY SCORE 47.6

I have been using Excel 2011 (Mac), but when I try to save or copy worksheets over to Excel 2013 onto my PC the sheet layout changes. Not only do I need to adjust the row height and column widths afterwards, but the zoom level too. All this I find time consuming when I have a number of worksheets.

I understand you can save to an older Excel version, but how do I save from 2011 to the latest 2013.

Thanks
 

A:Solved: Saving from Excel 2011 to 2013

Hi, I'm not MAC man but besides the format and zoom issues maybe this link can help you along the way
http://office.microsoft.com/en-us/mac-excel-help/file-formats-for-saving-workbooks-HA102927677.aspx

Another link:

http://sysmod.wordpress.com/2011/10/28/mac-excel-vs-pc-excel/
 

Read other 2 answers
RELEVANCY SCORE 47.6

Addresses and a different dollar value (from a formula) for each addressee are in Excel 2010 and are then merged to a word template (letter) to be printed. Various column formats have been attempted, i.e., dollar value, currency, accounting etc.. The excel is showing the figure as the proper two decimal value, but the merge show the value as multiple figures after the decimal. This merge used to work correctly and it is not known why it does not work now. Can you assist please?

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 64 bit
Processor: Intel(R) Pentium(R) CPU G3220 @ 3.00GHz, Intel64 Family 6 Model 60 Stepping 3
Processor Count: 2
RAM: 8130 Mb
Graphics Card: NVIDIA GeForce GT 530, 1024 Mb
Hard Drives: C: Total - 953766 MB, Free - 858513 MB; E: Total - 305242 MB, Free - 198139 MB;
Motherboard: ASUSTeK COMPUTER INC., H81M-A
Antivirus: Microsoft Security Essentials, Updated and Enabled

Copy of example excel entry and word output are in attached .docx file

Note: data submitted is fictitious.
 

Read other answers
RELEVANCY SCORE 47.6

The company I work for is in the USA and is running a US version of 64 bit MS-Windows 8.1 Professional on desktop computers. We are running MS-Office 2013. Several people exchange MS-Excel files with the factory in Taiwan. A few people are finding it cumbersome to edit or enter Chinese text into cells using a standard American keyboard.

One person is asking if would be possible to attach some type of small drawing pad and stylus to the desktop so that they can hand write the text, rather than going through any kind of gyrations with an American keyboard. Is this possible? If so, are there any recommendations for an input device and any extra software that may be needed?
 

Read other answers
RELEVANCY SCORE 47.6

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
RELEVANCY SCORE 47.6

Hi guys,
almost a month ago I was working on a file on Excel 2010 (whose cells were 15 x 8,43), when all of a sudden Windows asked me to install the so-called "Windows 10 anniversary" update and, when I went on to open the file, I found out the cell width had gone from 8.43 to 8.38. As a result, only columns A through R would show on one page (before it was columns A through half of U), because each of them had gotten larger: I guess it was because 8.43 = 64 pixels and 8.38 = 72 pixels (so the number of pixels had increased)!

I thought it was an issue with an "old version" of Excel, so I uninstalled Office 2010 and had Office 2013 installed instead... and just the opposite happened: originally the cells were 15 x 8,38 (by default), but a second "Windows 10 anniversary" update last Friday brough the width back to 8.43. This is a problem, because I'm adding a bunch of pictures to my file in order to make them fit the cells containing them, and this constant width changes jeopardize that.

I've found out that "When using ClearType with the Windows Anniversary update, Excel column widths can be larger than in earlier versions of Windows. This happens in only some fonts, such as Calibri. It can affect all versions of Office 2016", so I have disabled ClearType and installed the fix (Windows update KB3197954). Now I'm stuck with blurry text all over my screen (no ClearType) and a grid whose cell width is 8,43 (which I assume was the "rig... Read more

A:Is default cell width for Excel 2013 8.43 or 8.38?

Anyone? Anyone at all?

Read other 9 answers
RELEVANCY SCORE 47.6

Hi

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