Over 1 million tech questions and answers.

Excel 2007 & 2013 crashing when saving

Q: Excel 2007 & 2013 crashing when saving

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, and do not have anything crazy going on....simple things like recorded keystrokes and a few simple loops to sort and remove duplicates in tables of data. There are many formulas with lookups to external spreadsheets (stored locally on each computer, and the lookup tables are connected to the cloud so updates automatically populate to all computers/laptops). These lookups simply return statistical data for my business needs.

I will even pay for the solution that works. I'm really that desperate. Thanks again!

RELEVANCY SCORE 200
Preferred Solution: Excel 2007 & 2013 crashing when saving

I recommend trying the free service from Zip Cloud. It's currently our users' favorite backup and storage solution and will save you headaches down the line.

You can get it direct from this link http://goo.gl/rFYDxc. (This link will open the Zip Cloud homepage.)

A: Excel 2007 & 2013 crashing when saving

Read other 10 answers
RELEVANCY SCORE 84.4

We have an upgrade on our computer units here in the company, my problem is when users save their 2007 excel files an error pops up, Errors were detected while saving "File Name". Microsoft maybe able to save the file by removing or repairing some features. To make the repairs in new file, click Continue. To cancel saving the file, click Cancel.

By the way, the files were save on the file server and users access them through single roaming profile that we created with full access on their folders.
i am hoping i could find an answer.

thank you

A:Error on saving MS Office Excel 2007 files to MS Office 2013

i have many views, but no reply... i am starting to think this forum is not helping me !...

Read other 2 answers
RELEVANCY SCORE 75.2

The ?problem? I?m concerned about is that I noticed existingExcel 2007 xlsx files are now saving with fewer Kb.
I have a Lenovo W700ds and a W541. Both computers are running Windows 7 Pro 64bit.The W700 has Office 2007 and theW541 has Office 2013.Both versions ofExcel are 32 bit as far as I can tell.
Until recently I was primarily using the W700ds but have nowswitched to the W541.


after I saw a larger file losing KB when saved, I did a test with a file that had not been altered or openedfor over two years. I copied it twiceand added a -1 and a -2 to change the names.The file was a small 832 Kb file.When I opened and saved on the W541 running Windows 7 with Excel 2013,the file saves with 771 Kb.When Iopened the file using the W700 running Windows 7 with Excel 2007, the computeron which it had originally been created, the file saved as 830 Kb.Both saved smaller but the newer computerrunning Excel 2013 was much smaller.Iam seeing these same types of ratios of reduction in size for much larger Excelfiles as well.

I have not documented any actual problems or loss of data withany of the files to date and I have used an Ultra-Compare text file comparison which found no differences.
Is there any reason to be concerned about this? And, if so, what to do?

As with many people, some of my files are the result of manyyears of work and I don't want to do anything to compromise any of the data butI don?t know whether or not what I?m seeing is normal due to both Excel 2007and Exce... Read more

Read other answers
RELEVANCY SCORE 73.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 71.2

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

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

Have you seen this Microsoft page?

Read other 2 answers
RELEVANCY SCORE 69.6

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 69.6

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 69.2

Join Date: Jan 2010

Vista
3 posts
Local Time: 16:38





Excel 2013 has been crashing for over a year, HELP!!! Tried everything
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 sp... Read more

Read other answers
RELEVANCY SCORE 68.8

Hi,
We are using Word 2007 in Vista. We have never had any problems with it since installing in 2007. Last week, I was saving a document and it opened the target folder as usual and just froze. There was no error message. The busy icon was on screen but nothing was happening. I couldn't access anything else. I had to restart using Ctrl-Alt-Del. This has happened a number of times. By default it is saving docs as .docx. I hope this is enough info. As we are typical in size of a small business, it needs to be sorted asap. Thanks for any suggestions.
 

A:Word 2007 Crashing when saving document

Read other 6 answers
RELEVANCY SCORE 68

I'm using the above software.
At present, the files I saved are not in the order that I prefer.
They are saved this way:
APR05
APR06
APR07
AUG05
AUG06
DEC05
DEC06 etc
I would prefer them to be saved in the following order:
APR05
AUG05
DEC05
APR06
AUG06
DEC06 etc
Please let me know how this can be done.
Thank you.
Regards,
 

A:Saving Files In Excel 2007

Wouldn't you need to save your files something like this to get it in the order you require

200504 or 200504 Apr
200508 or 200508 Aug
200512 or 200512 Dec
200601 or 200601 Jan

etc etc

I'll go sort myself out
 

Read other 2 answers
RELEVANCY SCORE 66.4

I am running Excel 2007 and have been working on files and ONLY saving them to my USB memory stick.
On connecting the device to my PC (using an extension USB cord) I noticed a very brief minute blue like spark, and didn'y release until I tried to access my files that the entire content was wiped.
Excel cannot open the file 'LostFile_XLSX_608879.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.
Well I think it looks fine to me, and I endeavoureed to use the Open & Repair when openng the file too, with no luck.
 

A:I am running Excel 2007 and have been working on files and ONLY saving them to my USB

As you have just learned the hard way, any data that is important to you should be backed up on at least one other, separate device.
 

Read other 2 answers
RELEVANCY SCORE 66

I have a problem in a clients office where three people are sharing a workbook file. One person is on 2003, and the other 2 are on 2007. For one of the 2007 users and the 2003 users the file works fine. They are able to modify save and reopen. One of the users can open a the file but if she modifies and saves the file .. next time she opens the file Excel claims there is a problem with the format, preforms a recover action on the file, and then closes. The next time any excel file is opened Excel shows the recovered xls document minus the formatting. This issue just started happening, the file has been shared between the users for about a year now. The new file has stripped all date and currency formatting. As well as filters and coloring.

Additional information: Currently no other shared files are effected.
Any help would be greatly appreciated
SK
 

A:Solved: Excel 2007 corrupts shared file after saving.

anybody having the same or simular issue?
 

Read other 2 answers
RELEVANCY SCORE 64

New to the forum - Hi!

I am running Excel 2007 with Windows 7. Frequently when I update a formula (using find and replace) which refers to an external workbook on disk, a dialog box appears "Excel has stopped Working". This seems to be when there are many references to update.

If there is only one cell with the external reference, it updates correctly. I can then copy and paste the updated data to other cells, and using relative addresses, get the proper external data brought in.

But if I attempt to update the entire sheet, the crash occurs. I have disabled the add-ins (except for Analysis Toolpak and Analysis Toolpak VBA - which were recently added, but the problem described was happening before they were enabled), but still no solution.

Others here using Excel 2007 with XP do not seem to have the same issue. HELP!
 

Read other answers
RELEVANCY SCORE 64

Hi All

I have an vista Machine runing office 2007 oem from dell Every time i try to do something in excel it just stops, then it say restarting excel I have gone into program featues office 2007, change then take out excel then re install it but it still keeps happening I CAN~T DO ANY Work........

Jwc
 

Read other answers
RELEVANCY SCORE 64

I have Windows 7 Home Premium and have installed MS Office 2007.
This Excel sheet crashes time and again itself and is causing lot of problems for me as I loose my data.
Rest all applications of MS Office are working fine.
Kindly help.
 

Read other answers
RELEVANCY SCORE 63.2

Hey guys i really need help before i throw my laptop out the window!
I have a IBM lenovo thinkpad with vista and office 2007 installed. My excel program keeps crashing on opening and ive run all the updates, system diagnosis...every thing i found or could think of and nothing works!

Please help!

thanks
 

A:Excel 2007 keeps crashing on opening!!

Read other 15 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 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 53.6

I have attached 2 screenshots of the types of things I am getting.. The first one is when trying to open a document and the second one is trying to save an attachment in outlook.. As I am typing this it seems to be working fine now. However, this is how it acts sometimes it works great and other times its extremely slow..  I have tried a repair in office but that didn't seem to help. Thanks for any help/suggestions!

A:Issues when opening and saving in office 2013

It looks like the files path is not on your computer but rather on someone's else and when you try to open it, it tries to connect to that computer.

Read other 0 answers
RELEVANCY SCORE 53.6

I've recently had quite a few problems with my system and backing data up, and on reviewing various areas of my computer I have the following question:

When .pst files/data are saved (drive:\Users\<username>\Documents\Outlook Files) is the date in the 'date modified' column current - i.e. would it show today's date as I am currently using Outlook?

I ask this because the latest date I can locate in the above file is some 4 weeks ago, and If I review this .pst file in a .pst viewer, it obviously doesn't hold a current reflection of my outlook files, which I would have presumed - or am I totally wrong and missing something, and if so, where then are my current .pst files being stored?

A:PST saving/backup question Outlook 2013

My Outlook 2013 pst.data file does show the last Outlook was used. As far as I know the location you mention is the only place Outlook data files are stored.
If your Outlook is part of Office you could try repairing it. Open Control Panel, select Programs & Features, scroll down to MS Office, Right Click on it & select Change, this will open a couple of Repair options for you to try.

Read other 4 answers
RELEVANCY SCORE 53.2

Hey guys one of my CIT classes has forced me to upgrade to Microsoft Office 2013 after I had 2010 for a short while which both are free from the university and ever since I have had Office 2013 on my Toshiba laptop I have had a problem with Word 2013 wanting to hang by saying not responding when saving and printing, is there a fix for this it doesn't happen in powerpoint or excel this gets annoying after a while especially if you are doing assignments and needing to get them printed thanks

A:Word 2013 stops responding when saving and printing

You could try repairing Office. Open Control Panel, select Programs & Features, scroll down to Microsoft Office, Right Click on it & this will open a couple of Repair options.

This MS website might have some things you can try & it lists some other programs that can cause problems with Word 2013.

Office 2013 Word Keeps Freezing (Not responding) - Microsoft Community

Read other 1 answers
RELEVANCY SCORE 53.2

Hello,

I am on a network at work. When I take my laptop off of the network, I have noticed a bluescreen error followed by a shutdown. This happens when I open Word 2013, create a new file, and attempt to save it to my desktop.

I have attached the .dmp files in the zip file with this post. Can someone take a look at these dmp files and analyze them? I am happy to give any more info if needed, just let me know what is needed! Thanks!

A:BSOD when saving Word 2013 document to desktop

It would appear the problem relates to Kaspersky Security software. Your dump files are indicating klvfs.sys as the problematic driver which is part of their software.
A quick google and it would seem you are not alone, someone mentioned not having the encryption element of their software installed seemed to help but I would start by removing Kaspersky if only for testing to see if it works ok

Read other 1 answers
RELEVANCY SCORE 52.4

Hello,

I've been working on a certain workbook and everytime a try to save it an error occurs:

Microsoft Excel for Windows has encountered a problem and needs to close. We are sorry for the inconvenience.

AppName: excel.exe AppVer: 9.0.0.2719 ModName: excel.exe
ModVer: 9.0.0.2719 Offset: 002aa2b3

HELP !!!

Thanks

Mark R

A:Excel 2000 .. When saving a certain workbook excel crashes

Hi, try running a repair from control panel>click on MS office and run change or repair if I remmber correctly.

Read other 1 answers
RELEVANCY SCORE 52

Hi Everyone,
We are getting an error with Adobe Reader DC when trying to open or save files to Sharepoint 2013.
An Error has occurred in the script on this page
Line: 42
Char: 5
Error: Unable to get property 'empty' of undefined or null reference
Code: 0
URL: domain.com/_vti_bin/owssvr.dll?diagview=FileOpen&FIledialogFilterValue=*-pdf&location=filepath
Do you want to continue running scripts on this page?  Yes/No
Whatever option we press (yes/no) the error will not go away.

This happens in the open or save window that opens within Adobe Reader DC version 2015.010.20056
At this stage more than 1 Windows 8.1 Pro 64 systems are affected, and some of the same version systems are not affected.
I can confirm that the open/save window on Office products (2013 word, Outlook and Excel) work fine and are not affected, it just seems to be Adobe Reader DC. 
Please let us know how we might fix this.
Thanks in advance.

Read other answers
RELEVANCY SCORE 50.4

Over the last day or so Outlook 2013 has been crashing repeatedly. It's asked me to run the repair tool, which I've done. What else can I do to fix Outlook so that it runs normally?
 
Thanks.

A:Outlook 2013 keeps crashing

if you're using windows 7, 8, 10, go to control panel-->Mail-->Show Profile-->Remove-->close to exit.  Launch Outlook-->when prompt type: outlook (or any name) and just follow the prompts to reconfigure your outlook.

Read other 1 answers
RELEVANCY SCORE 50.4

Over the last day or so Outlook 2013 has been crashing repeatedly. It's asked me to run the repair tool, which I've done. What else can I do to fix Outlook so that it runs normally?
 
Thanks.

A:Outlook 2013 keeps crashing

if you're using windows 7, 8, 10, go to control panel-->Mail-->Show Profile-->Remove-->close to exit.  Launch Outlook-->when prompt type: outlook (or any name) and just follow the prompts to reconfigure your outlook.

Read other 0 answers
RELEVANCY SCORE 50

I have an Excel workbook in which I keep racing records. The data goes back about 5 years and as i have accumulated several hundred thousand records, I have moved much of the historical data onto separate sheets in the workbook so that values for calcs that rely on the historical data can be auto updated.

For current data I use a separare sheet as i was finding that it was takin g a long time to perform calcs when all the data (up to 200,000 rows) was all on the 1 sheet.

I wanted to know if it was possible to convert what i have to Access as it has been suggested that a database would do a better job of handling so much data, rather than Excel. I have moderate knowledge of Excel and have been able to build up the series of formulas for calculations in Excel over the years and have it pretty well doing all the things i want now but I have very little knowledge of Access design so not sure if I can convert and how to do it.

The Excel workbook contains a lot of formula that do calcs on past results and then use those calcs to do predeictive calcs for upcoming races. Because it was very "maths"based to start with, I started off using Excel and it has all grown from there. Is it possible to convert what I have to Access? Is is reasonably able to be done (by a moderate user like me with some expert help)?.
The files i have are too big to attach here, but would be happy to prepare some sheets without much data to show what i am doing and get advice.
 

A:Help required to sucessfully convert Large Excel 2007 Workbook to Access 2007

Read other 13 answers
RELEVANCY SCORE 50

Have been trying to follow suggestions from similar posts, but nothing working. Have tried to save as .xls and .csv, as well as trying to 'define names' of the various columns, but nothing allows me to import complete contact into Outlook. Please help, very important to get these contacts into Outlook asap. Thank you
 

A:Issues importing large contact list in Excel 2007 to Outlook 2007

Hi hbsurfer

Try going about it backwards.
Create one Contact in Outlook 2007, then Export that one Contact to a .csv file.
Then you will be able to see the format Outlook 2007 is using and reconfigure your headers in the Excel spreadsheet.
When all headers match, you should be able to Import it. Or copy the excel information to the one contact .csv file and Import that.

Let us know if that works for you or not.
 

Read other 1 answers
RELEVANCY SCORE 50

My employer just upgraded to Microsoft Office 2007. According to the help files, I should be able to paste Excel charts into Word that update automatically when changes are made to either version.

I am clicking "Link to Excel data" and "Keep source formatting" when using the little popup clipboard to paste a chart into Word. But after closing both files, opening Excel and updating data on the chart, saving and closing Excel and re-opening Word, the chart is not updating with the new information. I can't get it to update by clicking on "refresh data" either.

Does anyone know how this is supposed to work? I was looking forward to being able to update just the Excel file and having it update in all the Word documents where it is pasted.

Our OS is Windows XP Professional, Version 2002, Service Pack 2. My work computer has a Pentium 4, 3 GHz processor and 2 GB of RAM.
 

Read other answers
RELEVANCY SCORE 50

I'm trying to run an Excel 2007 macro from Access 2007, when I get to the point where I want the macro stored in the active workbook I'm getting the following run-time error: run-time error '91' object variable or with block variable not set . It won't run the macro at all. I would greatly appreciate it if someone could help me fix my code so the macro will run. The code is listed below; step 10 is where I get the error.
Code:
Option Compare Database
Sub GetJournal_Entry_Data_transfer_to_Excel()
'Step 1: Declare your Variables
Dim MyConnect As String
Dim MyRecordset As ADODB.Recordset
Dim MyQueryDef As DAO.QueryDef
Dim MyDatabase As DAO.Database
Dim MySQL As String
Dim MyRange As String
Dim s As String


Dim Db As Database
Dim xl As Excel.Application
Set xl = CreateObject("Excel.Application")
Dim xlwkbk As Excel.Workbook
'Dim xlworkbk As Excel.Workbook
Dim xlsheet As Excel.Worksheet
Dim i As Integer


'Step 2:Declare your connection string
MyConnect = "Provider=Microsoft.ACE.OLEDB.12.0; Persist Security Info = False;Data Source= P:\FINANCE\Balance Sheet\Inventory\Project TAN\Project TAN.accdb; User ID = Admin;"

'Step 3: Build Your SQL Statement
MySQL = "Select* From [mtb-TantasticJE's]Where [mtb-TantasticJE's].[Dscrptn_Text]='Culls_Stat34'and [mtb-TantasticJE's].[Co_Code]='1381'"

'Step 4: Instantiate and specify your recordset
... Read more

A:Access 2007 VB code to run Excel 2007 macro in active sheet

Read other 7 answers
RELEVANCY SCORE 49.6

Hello,

I have upgraded to Office 2007 from Office 2003. When I open an Excel attachment from email in Outlook 2007, the Excel application opens but the document itself does not. The document has a .xlsx extension. I need help resolving this issue please. If anyone knows why this is happening or the fix, I'd appreciate your insight.

JayT908
 

Read other answers
RELEVANCY SCORE 49.6

I'm trying to get the results of Access queries to be linked to an Excel workbook. I've been using the Data tab in Excel, clicking the "From Access" button in the upper left, and choosing the Access database. Then it asks what query I want to link.

The problem arises when I try to link a specific query, which we'll call qry_x. This query is based on several other queries, one of which is qry_z. Frustratingly, when I try to link qry_x to the Excel workbook, I get an error message that says that Access can't find qry_z, and suggests maybe I spelled the name incorrectly.

However, qry_z definitely exists as part of the database, and when I run qry_x (which is based on qry_z) in Access, the correct results are displayed with no error.

Note: qry_x is the only query this is happening to. I can link any other query with no problem at all, including qry_z!!!

What could be going wrong?

Thanks in advance.
 

A:Solved: Access 2007 / Excel 2007 - Linking to a database

Read other 16 answers
RELEVANCY SCORE 49.6

I have Office 2007 on Windows 7.

When I am working on a sheet (or document) the ribbon can become inaccessible, nothing works when I click it (like a 'Not Responding' screen).

If, I switch to another open sheet/doc and then switch back the ribbon is accessible again!

I have uninstalled/reinstalled Office plus SP's twice but the problem persists, and, as is usually the case, this does not happen all the time but enough times for it to be really annoying!

Any ideas?

Thanks for your time on this

Neil

A:Cannot access the Ribbon functions in Excel 2007 or Word 2007

Could you please post a screenshot or two?
And what are file sizes (MB)?

Read other 1 answers
RELEVANCY SCORE 49.6

Hello,

I am having difficulty linking Excel data from a simple worksheet table to a table in Word 2007. I would like to retain all the formatting currently used in the Word table, but can't get the Paste Options working at all despite following all the advice on the Microsoft Knowledge Base.

If I copy the Excel data and then place my cursor at the first cell location within the Word table where I want the information to be pasted I get different paste options compared to placing my cursor outside of the table.

I am using the "Medium Grid 3 - Accent 3" Table Style in Word.

I have attached a couple of simple files to demonstrate the formatting and content in both apps.
'
Step by step help would be appreciated.

Thanks!
 

A:Paste link from Excel 2007 to Word 2007 table

Thought I would try one more time to get this one resolved. Is what I am asking not possible to do?

Cheers!

wmorotn01
 

Read other 2 answers
RELEVANCY SCORE 49.6

I thought I'd followed the directions I'd read here from several months back re: transferring Outlook 2007 data to Outlook 2013 (i.e., don't use the export/import tool, make a copy and paste it into the documents folder on the new PC, etc.). I copied the Outlook 2007 .pst file to a USB drive and pasted it into the documents folder on the new PC and it looks as if it worked halfway -- that is, all my folders transferred, which was critical to me. Problem is that I'm not receiving any new mail, although I appear to have set up the new account successfully (or so said the automatic test message sent by Outlook after I'd entered the pop and smtp information). There are now two folders in the left menu box in 2013:  one shows my email address and is empty when I click on it, the other says "personal folders" and has all of the folders I transferred from the 2007 account.  The mail that was in my 2007 inbox at the time I copied the .pst file is showing up in the 2013 inbox, but there have been no messages received since then despite the fact that several new messages have been received in the 2007 inbox.
 
I think the folder that has my email address as the title is the one I set up before I transferred folders -- but when I go to that folder, select the inbox and click on "send and receive," I get a message that "we didn't find anything to show here."  I'm feeling as if I need to delete everything and start over. Of course, I'm also feeling as if I'm doing... Read more

A:Transferring Outlook 2007 > 2013

Can you send email from 2013? If not, then you'll need to go back and make sure the settings are correct. Most probably an error with the username, password and/or the server settings.
 
The fact that the folders are all there is a good sign -- are you missing any emails? if not, then the file transfer was a success. You just need to get your account configured so it can send and receive email.

Read other 1 answers
RELEVANCY SCORE 49.6

Is there a way to connect Lync 2013 (Windows Store App) to my companies Office Communicator server?

It doesn't appear to be configurable by the end user... So maybe it's trying to go through Office 365, which we do not use. Or is it failing to auto discover?

Or, because they're no where near supporting this device, do I just wait?...
 

A:Lync 2013 / OCS 2007 R2 on Surface RT

MS sold very few RTs and I suspect it will die as a product someday. Too bad, as I was waiting for them to improve it. That said, I did find this conserning connecting:

Lync Windows Store app may not be able to access the Lync server or services through some network adapters

Lync Windows Store app may not be able to access the Lync server or services through network adapters, such as 4G LTE USB modems, that don&#8217;t register with Windows 8 as physical devices. Lync Windows Store app may have this issue even when the desktop apps and browsers are able to access other servers and websites.

Also found a mention that RT had some issue with Enterprise certificates and...
The Mobile Client requires Lync Server 2013 to connect to, if your org is still using 2010, the mobile client won't work.
 

Read other 2 answers
RELEVANCY SCORE 49.6

Starting with Office 2007 Enterprise x86, going to Office 2013 Standard x64, no matter which way I try to go about it always ends in every Office application crashing (Ex: MS Word has stopped working..) as soon as it is opened.

I cannot use the "upgrade" feature during 2013 installation as it will not install Office products of different architectures side by side, so my only option is to uninstall 2007 and install 2013, which produces the crash. I have searched for a MS documented 'best practice' or recommended method of achieving this to no avail.. also looked for a MS removal tool for 2007 but came up empty.

Has anyone else encountered this problem?

If you have information on a MS best procedure or a MS removal tool, please let me know! Any other suggestions such as a manual technique would be very much appreciated as well.

A:Office 2013 from 2007 = Crash

Found a KB article:

How to uninstall or remove Microsoft Office 2007 suites

Had uninstalled 2007 and used the Fixit tool with no luck once, then reinstalled Windows 7 and repeated the process of:


Code:
Install Office 2007 Enterprise x86
Reboot
Uninstall Office 2007 Enterprise x86
Reboot
Run Fixit Tool
Reboot
Installed Office 2013 Standard x64
Reboot
And all seems to be working well now. Tested once with a Windows 7 x64 SP1 install with no driver or OS updates. I am going to repeat the entire process once to be sure it's reliable, as I did essentially the same exact thing before reinstalling the OS, but just wanted to post what I'd found so far for the community. Will mark as solved if all goes well on try #2.

Read other 5 answers
RELEVANCY SCORE 49.2

When I try to open an Excel document attached to a email Excel opens but the document doesn't appear until I click on the minimize button. Has anyone seen this before?

I'm Using Excel 2007 and Outlook 2007.
 

A:Opening 2007 Excel documents in Outlook 2007

Read other 12 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 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

I have Microsoft Office 2013 64-bit on my system.

While editing an equation in Powerpoint using the equation tool, the program crashes. I specifically am trying to move an equation I made by pressing Enter or Space key, and then the program crashes.

I have attached screenshots of the problem signature output.

Read other answers
RELEVANCY SCORE 49.2

Hello. Outlook 2013 has been having problems for a while. Now, however, whenever I open it it crashes. I run the repair tool and then it asks me to make repairs but that will erase my backup. Is it okay to erase the backup?
 
Thanks.

A:Outlook 2013 Crashing / Erase Backup

Hello. This stopped for a while but now is happening again. Any ideas on what to do?
 
Thanks.

Read other 1 answers
RELEVANCY SCORE 49.2

Hello. Outlook 2013 has been having problems for a while. Now, however, whenever I open it it crashes. I run the repair tool and then it asks me to make repairs but that will erase my backup. Is it okay to erase the backup?
 
Thanks.

A:Outlook 2013 Crashing / Erase Backup

Hello. This stopped for a while but now is happening again. Any ideas on what to do?
 
Thanks.

Read other 1 answers
RELEVANCY SCORE 49.2

Can you help. I have copied all emails and contacts from Outlook 2007 on a computer running Windows 7 to Outlook 13 on a computer running on Windows 8.
I have found the NK2 file in the old computer but it is showing as a word doc. I have download NKSEDIT.exe but it tells me it is not compatible with the version of windows I am running.

Help!!
 

A:Importing outlook addresses from 2007 to 2013

The address are NOT really in the nk2 file, that is just a temp list of the ones that you have typed into an email address pane.
As far as I know they can NOT be import into another version.

You need to make sure that you them in your "Contacts", and then as you use them they should appear in your drop down list as you type in a address in the email address pane.
 

Read other 1 answers
RELEVANCY SCORE 49.2

I have recently re-installed Wind 7 64-bit SP1 and all updates (well, except the two I removed because of the windows ads). All seems fine, but whenever I've worked for a short time in Word (no matter which of the two I've used) my cursor goes into circle mode and won't cease. The only way to get it to stop is shut down Word. I've updated all the drivers for network, keyboard, marble mouse, both versions of Word and nothing seemed to help.

Anyone have any ideas?

Thx, LafnSu

A:Odd cursor behavior in Word 2013 and 2007

Is the problem only in one document or in all documents? The "circle mode" suggests something is running in the background or that Word is having a problem with the document or the auto-save feature.

Read other 9 answers
RELEVANCY SCORE 49.2

Hard to believe but I accidently down loaded office 2013 on to my pc. I already had office 2007 on it.
I have uninstalled 2013.

when I try to send a new or receive email via outlook I get a Not Implemented error message.
How do I resolve this?
Excel and Word seem to be working.

Thank you in advance

2lexec

A:outlook 2007 not implemented after uninstalling 2013

It's possible to have multiple versions of MS Office installed, but there can only be one version of Outlook.
Installing Office 2013 probably removed Outlook 2007, or corrupted it.
I think you will need to re-install or repair Outlook 2007.
Go to Control Panel > Programs and Features
Select Office in the list and click Change
Then select Add or Remove Features
See if Outlook is listed as installed
If it isn't, install it
If you can't re-install this way you can try the Repair option instead of Add or Remove Features.
If it is installed and Repair doesn't fix it, Remove Outlook and then Add it back.

I have Office 2010, but I expect Office 2007 works the same way.

Read other 3 answers