Tag Info

New answers tagged

0

import both into access into separate tables. We will name them 10k and 1k for obvious reasons. then you can directly execute this command and your done: select * from 10k,1k where 10k.accountnumber=1k.accountnumber; Otherwise you might try a pivot table in excel.


0

I would use the Power Query Add-In. A Query can import data from an Excel table. The Merge command can join two Queries together, with an option to only include matching rows. http://office.microsoft.com/en-au/excel-help/merge-queries-HA104149757.aspx?CTT=5&origin=HA103993872 So for your scenario I would first build a Query for the 1000 row table. ...


0

The only fix I found was to reinstall Office.


-1

One way to fix problem is go to Desktop, right click, select Personalize and just choose another theme. Magically the tabs and margins will now appear in Word doc. Can't believe that Microsoft hasn't fixed this obvious glitch.


0

I wiped and installed 8.1 and the Office 365 installer worked without a hitch. Something was corrupted in the Windows 7 install that prevented this from working right. (I was able to get 8.1 for free from my school in addition to specific recovery disks for the old windows 7 install that would likely have let me reformat).


0

I had this same issue. I fixed this by entering the footer on the offending page(doublle click on footer), right clicking on the page number, select toggle field codes, ensure that all you see is "{PAGE * MERGEFORMAT}, if you see something like "* ROMAN" delete it. right click, select update field. your page number may now be in arabic. change the page ...


0

If you are trying to label the markers with the words "Blocked" etc the easiest way is to use the free add in xychartlabeler found here. If you want all the to use a certain marker shape for the different labels you would need to build them as seperate series for each label. Use line graphs without markers for the first table and split the second table ...


0

Ms Office 365 and Ms Office 2013 are two different things so you can keep 2013 and install 365 on top of it. It makes no difference but I would recommend uninstalling as the default programs would be confusing


0

You can install both as the same time and both will work. If you want your users to only use Office 365 I'd suggest uninstalling Office 2013 beforehand instead of after installing Office 365.


0

I might be mistaken about this, but Word 2013 "My Name OneDrive" doesnt actually check your local OneDrive, but shows a virtual folder to "https://d.docs.live.net/[user-id]/". So if you are unable to connect to this url, Word 2013 might crash, i would imagine. Another possible source of error could be if you have moved one of your system folders to point to ...


2

Use the tilde (~) just before the asterisk to tell Excel that it is a literal. Ref: http://support.microsoft.com/kb/214138


0

You can use a folder protector which support pendrive to protect your files or folders in pendrive; you also can use a pendrive security to encrypt your whole pendrive to protect all files in it. Even if you lost your pendrive, the data can't be stealed This article can help for you.


0

OEM Licenses are indeed multi-region. Once you have purchased a license for the software, you can install it on any region/language version you like. Tne only exception to this are home and student versions of some ms software can be region locked (see comment above) for the reason stated by Ramhound (discounted licenses are not available in every region ...


1

If you don't remember your account information, it should be written in the downloaded software. If your software is already removed, try to get it back with system restore. If all fails, you still have your payment information to Microsoft. Contact MS and have them tell you what your access information is for Office 365. If you're having troubles ...


0

You can also just break the SmartArt Graphic, and then resize the layout as you see fit. CTRL + SHIFT + G twice to break the SmartArt Graphic. See tip #2 in the Four Things You Didn't Know You Could Do In PowerPoint YouTube Tutorial: http://www.youtube.com/watch?v=05OW0Ce8rT8


0

Yes, if you are using SharePoint. The following article states (emphasis added); There are two versions of Power View: Power View in Excel 2013 and Power View in SharePoint 2013. You can only export to PowerPoint from Power View in SharePoint 2013. (source - Export a report from Power View in SharePoint to PowerPoint) Note: the article you linked in ...


0

What i did to fix this problem was to delete all the keys in the registry linked to excel applications (found in the link in the question). i then repaired office and restarted the computer which fixed the problem and allowed me to create a workbook through visual basic.


1

If you could drive to exclude the hard drive issue by booting your machine from Live CD. Apart of possible hardware issues of hard drive it could be very slow also because of fragmentation or old registry. Do you have another copy of your Excel file. You can copy it as well (good reason to make backup if it's precious) So, I would run to separate tests: ...


1

Simply put: If your pointer is slow, it's most certainly the RAM. Perform a test using memtest86+ Or If boot time, running applications and overall file-related operations are slow, it's most certainly the hard drive. Have you checked your SMART data? Your disk may be dying.


1

For a MAC I used EraseUS a recovery product that recovered versions of the PPT file I had overwritten. Phew. Many hours work recovered.


-1

Press the ‘Windows + R’ key to open run box Type ’MSCONFIG’ and click ‘Ok’. Click the ‘Boot’ tab and uncheck ‘Safe Boot’ option. On the ‘General’ tab, click to select the option ‘Selective startup’, and then click to clear the optionLoad startup items check box. On the ‘Services’ tab, click to select the ‘Hide all Microsoft services’ check box, and then ...


0

This certainly sounds like a hardware error, specifically the hard disk (HDD) and processor. My recommendation would be to either run some tests yourself using on both peripherals to test their durability and ability to perform or if you are unable to do that, then take it to a repair shop and have them check it over for you. Word of warning - they (repair ...


0

You can also take a look at our XLTools Popup Calendar Add-In for Excel. It is free and can be downloaded from here. Here is how date editing may look like if you install XLTools Add-In:


1

I would like to recommend our XLTools Version Control Add-In for Excel. It allows you to enable Version History for particular workbook, so all future revisions would be automatically keeped for you. You can also add comments for each revision of the workbook, so you and your collegues can get more sense about the changes later when you review the history. ...


0

You are probably running several versions of Office on the same computer and need to set a registry key. The steps are explained in this Microsoft article. The core steps are in the section about "Multiple Versions of Word": Start the registry editor Locate and then click to select the following registry subkey: ...


0

powerpnt.exe (or powerpnt) for launching MS Powerpoint winword.exe (or winword) for launching MS Word excel.exe (or excel) for launching MS Excel


1

Try This, 1 Open up RegEdit Open up RegEdit by going to Start>Run and typing "regedit" and pressing Enter or OK. You can also enter the "regedit" command into a Command Prompt to open up the editor. 2 Locate the Office Registry Key Microsoft stores all of the installation information for Office Products in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office. ...


1

I have a 64GB SSD and LOADS of programs. I regularly move space gluttons to a HDD. Many programs now use 500MB-1.3GB for garbage like page borders and all sorts of small image files. Don't screw with the registry. Sooner or later it'll bite you in the butt bigtime. Create a junction, as mentioned in SoLaR's answer. HOWEVER -- SOME CAVEATS. Don't delete ...


1

This solution has been well tested for Word and Excel. Outlook seems to work just fine, though I don't use it as a mail client. I don't use Access, so I wouldn't be able to tell how well it works. So, here goes: Install Linux Install wine + PlayOnLinux Install all the versions of MS Office you like, using the dedicated scripts (currently existing scripts ...


0

Note that although OpenOffice can open some docx files, you may lose a considerable amount of the docx formatting. I have yet to find a satisfactory solution to this. The closest thing to a solution I have found when the formatting is "difficult" is to edit the document on Microsoft Office online through a webbrowser. It's not comfortable, but it does ...


3

Open one of the Office programs (like Word). Click the File tab. Choose Account. The info you seek will be listed on that page under "Product Information":


0

You should try right_click -> paste special and check if any of those options works for you. I tried your example and had no problems with a normal paste...


0

solution is very simple copy your desired cells paste at distination, you will find a small tag at the right bottom of pasted cells. by clicking the tag you will several option for your pasted cells. now click on "Match Distination Formitting". I think your problem solved. (Office 2007)


0

It is likely a plugin/addin. I would strongly recommend uninstalling Office 64-bit entirely and only use the 32-bit version of Office because this is a common problem. Whenever I need to install Office, I only go for the 64-bit version when its on a server environment, never for clients. It brings more harm than good, as in your case.



Top 50 recent answers are included