Posts

Showing posts from June, 2015

How to make imported Chrome bookmark bar replace the previous - Microsoft Community

Image
first of all, apologies question classification there did not appear option choosing microsoft edge or windows 10. in microsoft edge know how import favourites chrome. favourites end in folder called imported chrome subfolders of bookmarks bar , favourites. not change items appear on favorites bar @ top of screen these remain whatever before. how items on imported bookmarks bar appear @ top of screen on favorites bar , replace there previously * moved internet explorer the items appear in horizontal favorites bar @ top of window controlled folder called "favorites bar" vertical favorites pane. so, open vertical favorites pane normal way (via "hub" icon... 3 little lines), expand folder called "favorites bar", , delete existing items , move few favorites there via "drag-n-drop" operation.  special folder mirrors horizontal favorites bar.  so, put there show both in v

Teams - Microsoft Community

Image
my ms teams application not working? i checked school subscription , appears should have it.  when try launch states admin needs check , department lost. can fix myself? thanks marlee hi marlee, need involve office 365 admin setting microsoft teams: detailed information, please refer article: administrator settings microsoft teams reference: how access microsoft teams best regards, shyamal Microsoft Education / Microsoft Teams for Education / Teams

Blogs on Microsoft's products and services - Microsoft Community

hello, sir software engineer. have started career in blogger. question can write blogs on microsoft's products , services. because usual other people products , services of microsoft. thank you.  my blog link: <link removed> * moved windows essentials/movie maker   yes, may write microsoft product , services. here guidelines: use of microsoft copyrighted content https://www.microsoft.com/en-us/legal/intellectualproperty/permissions don   Community Participation Center / Discuss the Microsoft Community site / Other feedback

Why doesn't EDGE automatically go to a new tab when you right - Microsoft Community

Image
we want go see want leave what's open open. internet explorer has had setting @ tools > internet options on general tab after clicking tabs button , down in tabbed browsing section has said switch new tabs when created. on nokia lumia 950-xl, see swirling tab icon down in lower left creates new tab , starts downloading page need manually stuff go see it. why make user that? did edge windows 10 desktop & mobile design staff & management not memo or read of user polls? i'll add in internet explorer category forum since there isn't edge forum listed yet reason. that's weird. i mean apply forums of both normal computers , windows phones nokia lumia 950-xl 2nd. first lumia 635.  i don't see choice of edge category discussion, totally weird, i'll stick in internet explorer. Internet Explorer / Internet Explorer 11 /

Home page doesn't come up. "Can't reach page" message. - Microsoft Community

my home page doesn't come when click internet explorer message "cant reach page comes up * original title: homepage , internet explorer 1. what's page? 2. can reach other webpages? 3. have restarted computer (at lest once) since problem appeared? don Internet Explorer / Internet Explorer 8 / Windows XP

HTTP,HTTPS, issue - Microsoft Community

     while trying repair dell desktop installed fresh copy of windows xp. after running diagnostic internet connection came fine except, http, https, issue. can log on msn home page cannot open other web sites. have installed drivers there seems missing, know? Internet Explorer / Internet Explorer 8 / Windows XP

I can't find "suggestion search box" on "cortana & - Microsoft Community

hi there, (i post screenshot have trouble alt+ prt scn or ctrl+ prt scrn) wouldl ike find suggestions box on web searches can rid of cortana searching on bing me when not want to, (alternatively question how have friendly chat cortana without searching things up) the box on taskbar search box.  type in it. , type things should change above it. Windows Insider Program / Windows Insider Preview / Cortana and search

Windows 10 0xc000000f - Microsoft Community

hello, i accidentally use program shouldn't use because trying fix wifi because of windows insider program update , giving me the  blue screen came , saying pc needs repair because required device isn't connected or can't accessed , i'm  afraid of losing please me. ***post moved moderator appropriate forum category.*** review: https://www.groovypost.com/howto/fix-windows-10-wont-boot-startup-repair-bootrec/   if not able boot, can try reset choose option keep files: power on , off computer 3 times on third time, computer boot advanced recovery environment click advanced options click troubleshoot click reset pc follow on screen instructions. Windows Insider Program / Windows Insider Preview / Performance and maintenance / PC

how to get only redstone 4 updates - Microsoft Community

have insider preview account in receiving redstone 3 updates , want use restone 4 updates have install redstone 4 updates manually how can avoid redstone 3 updates on devices. after next public release, windows insider builds shift rs_prerelease lab branch, rs4 builds. some insider devices setup rs_prerelease builds, no longer accepting new devices @ time. need install windows image of current rs_prerelease build, such build 16273 rs_prerelease. rs3 builds rs3_release branch, end in september, public release of fall creator's update (rs3). Windows Insider Program / Windows Insider Preview / Windows Update / PC

Gmail Account - Microsoft Community

upgraded phone windows 8.1, after gmail account stopped working. deleted account. unable add accoun happens when try add account ? specific error message ? Mobile Devices / Microsoft Lumia and Nokia Lumia / Microsoft account / Other/Unknown

6digit security code received from a mobile number - Microsoft Community

i had switch mobile phone android microsoft phone died. needed sign microsoft account , forgot password. in order change password had option of code being sent text, accepted method. 6  digit code arrived, suspicious of fact mobile number...., normal practice? thanks yes, normal practice. Mobile Devices / Microsoft Lumia and Nokia Lumia / Microsoft account / 600-series

how to see windows phone sms in online - Microsoft Community

hi i have lumia 720 running windows 8.1 , have backed text messages recently have reinstalled software , after restoring text messages , from message threads many messages missing , not restoring. help me how restore them or tell me how access message online in case, suggest contact our b2x support further assistance. please click link and enter imei number. feel free post if have other concerns. Mobile Devices / Microsoft Lumia and Nokia Lumia / Tips, tricks, and customization / 700-series

LUMIA 550 WINDOWS 10 PHONE - Microsoft Community

so frustrating can not delete contact people app. some contacts have multiple microsoft entries can not deleted. gone through outlook mail account, worse because 1 can not multiple entries of contact want delete. please advise how i can store contacts directly on phone without microsoft moved from: windows / windows 10 / windows settings hello, multiple entries of contacts on people app can caused outdated os build. phone date? check, go settings > update & security > phone update > check updates . if have latest update, please soft reset . let know if need else. Mobile Devices / Microsoft Lumia and Nokia Lumia / Using Windows 10 on phone

Windows Mobile Text messages are not in sync - Microsoft Community

most of contacts not showing of messages.  if go contact timeline,  of them show up.  few seconds.  timeline goes blank.  keep asking no 1 has responded. can help? hi steve, we checked previous thread , realized phone has been reset. bug on software since issue persists on clean environment. noticed have submitted feedback issue. hope issue sorted on next update rollout. all best. Mobile Devices / Microsoft Lumia and Nokia Lumia / Using Windows 10 on phone

I cannot resolve #Name? error in Access - Microsoft Community

using ms access office 365 version 1707 (build 8326.2096) i have simple form has field called dob based on column in database i want put calculated field next dob show persons age on specific date (31st aug 2017) i put text box on form , on "control source" field of "data" tab added following: =int((datediff("d",[dob],dateserial(2017,8,31))/365.25)) this gives me #name? error in text box i experimented following: =int((datediff("d",now(),dateserial(2017,8,31))/365.25)) - ie removed reference dob field - worked =int(datediff("d",dateserial(2008,6,12),dateserial(2017,8,31))/365.25) - checked access can date maths - worked [dob] - checked see if access see field - worked wtf - access can see field cant use in formula - or missing something??? thanks tim name of control?  try renaming control other dob O

Access 2013 not opening Protected Excel workbook. - Microsoft Community

since changing office 2013, 2003, piece of vba in access recursively opens protected workbook, enters data it, , saves workbook, protected, under new name, no longer works.   i have tried hours solve , have tried lot of remedies.  my search-fu seems have escaped me.         set oexcel = createobject("excel.application")         oexcel.displayalerts = false         oexcel.automationsecurity = msoautomationsecurityforcedisable         set obook = oexcel.workbooks.open("f:\1surveyblank.xlsx", ) the 'set obook = ' seems problem, haven't been able resolve it. since change, snippet generates interactive input requested password, telling me reserved me.  this code hundreds of these workbooks @ time, (well, used to) the userinterfaceonly keyword comes not exist, the password:="password' option not remove interruption, the readonly:=false option nothing. anyone?

Excel 2016 Items Displayed in Filter Drop-Down List - Microsoft Community

i'm using excel 2016 (version 1706, build 8229.2073 click-to-run) , i'm having issue displaying more 10,000 items using auto filter. column contains 12,332 dates using format mm/dd/yyyy. of these, there 454 unique date values. can tell me if 10,000 item limit based on unique items or count of items? oddly enough, not seeing same issue/limitation excel 2013 though has same limitation specs. excel 2016-2013 limits - https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3?ui=en-us&rs=en-us&ad=us hi, having exact same issue. issue version of excel version 2013 did not exhibit behavior. have analysed options , settings , not find switch fix guess wait microsoft pick up.  Office / Excel / Other/unknown /

Excising text from string in Cell from find(substring) to end - Microsoft Community

the actual situation isn't quite grandiose.  have dataset of names , among other things, addresses.  address field single string of form: <street number><sp><sn1><sp><sn2><sp>...<snn><sp><"ste"><sp><identifier><","><sp><city><","><st>; where "sn1" through "snn" "street name" comprised of variable number of words/characters; i "normalized" data substitute "ste" "#", "bldg," etc. alternates exist; and suite "identifier" can variable number/format of (text) letters, numerals and/or symbols. [aside] it's easy enough, using trim() drop end of string starting "," separator between suite identifier , "city", and easy enough drop " ste " string, but because remaining "identifier" can have arbitrary length

EXCEL APPSCRASH FM20.DLL - Microsoft Community

split thread. hi neha we have tried above same problem still occurs.  what strange problem happens on 1 computer.  it doesn't happen on mine.  i have checked , specs on machine should more sufficient (i5 2.2ghz 8gb ram).  the file 7mb not huge. else problem be? thanks reenen hi reenen,   as similar issues may have different root causes, clarify issue, i’d confirm , provide following. 1. first, should clarify symptom of issue experiencing in environment. list detailed reproducing steps of it? 2. if excel application crashes, issue happen in 1 specific type of files or 1 specific file? 3. upload full screenshot of page showing version information of excel application using. can access page via file>account. 4. troubleshooting steps have tried? list them here?   for crash issue, suggest follow steps in article run excel client in safe mode see outcome.   thanks, cliff

Excel - Microsoft Community

how use temple?  using excel temple contracts , not let me change in safe. did mean template? or temples? haven't heard temple in excel.. making sure.. Office / Excel / Windows 10 / Office 2010

Formula or macro for copying list of cells to worksheets - Microsoft Community

hello, i haven't been able find solution i'm looking in searching.   here's best description of i'm trying do: on sheet1, have list of names in column a. bob mary suzanne greg  etc... up 50 total names. i copy each name same reference cell on it's own worksheet. sheet1 a1 fill sheet2 c9 sheet1 a2 fill sheet3 c9 sheet1 a3 fill sheet4 c9 and on , forth.  can show me formula or macro automate task? thank you. a possible formula solution - workbook must saved first. select sheet2. hold down shift , select sheetn (e.g. sheet50). group sheets formula type next reproduced on sheets. in sheet2 cell c9 enter formula: =indirect("sheet1!a"&sheet(mid(cell("filename",a1),find("]",cell("filename",a1))+1,255))-1) right click sheet2 tab , select 'ungroup sheets' Office

Excel 2013 - Microsoft Community

have created spread sheet contains 36 rows.  grid lines show on print preview, when printed, gridlines between rows 23 , 24 not there. hi, one of possible reasons why gridlines aren't being printed out default printer driver with a universal printer driver connected printer capable , set high resolution setting (e.g. 1200 dpi). can check link for possible resolution. let know result of possible resolution given. Office / Excel / Windows 10 / Office 365 Home

Recover Excel File - Microsoft Community

hi!  i lost excel document , need recover it. i have done everything, not know else do. need help rosalia how going control panel>recovery>restore files>backup , restore? from there can search through backups find , restore last version of file. i assuming have been making regular weekly or better incremental backups. gord Office / Excel / Windows 8 / Office 2013

cannot sign in to activate my product - Microsoft Community

the account associated office product has been rejected many time.what i'm suppose do? hi, usually, issue you're encountering depends on error code or message receive upon signing in microsoft account. able isolate cause of error, please provide answers following questions: how did try install office application on device? are getting error code or messages? have tried signing in microsoft account through link? if so, encountering same issue? Office / Install, upgrade and activate / Windows phone & tablet / Office 365 Home

Installing Office 2016 over Office 2007 - Microsoft Community

office 2007 (word, outlook, excel , publisher) not seem functioning since recent ms update.  can no longer backup outlook pst files , hoping save them somehow.  can install office 2016 without losing current folders , files in outlook 2007? paul your folders , files stored on hard drive installing office 2016 not harm files etc.  actually  suggest first make sure have product key office 2007. if cannot find download free version of belarc advisor   find product key.  matter of course backup folders , files. should have done in case.  can safely uninstall office 2007 , have product install again should need to.  can go ahead , install office 2016.  folders , files still on hard drive. Office / Install, upgrade and activate / Windows 10 / Office 2007

Activating office 365 - Microsoft Community

hello can't activate office 365 account. keeps on telling me microsoft account not associated office 365 product.  can please me? personal office 365 account. thanks. jonathan hi jonathan, regarding concern reactivating office 365, need confirm information. please answer following questions: when did first encounter issue? are using same microsoft account used in purchasing office 365? meanwhile, suggest try login my account page on http://office.microsoft.com/myaccount using microsoft account used register or purchase. kindly check if able activate office. please reply necessary information , result further. thank you. Office / Install, upgrade and activate / Windows 10 / Office 365 Home

MS Office Home & Student 2010 - Microsoft Community

program installed trial on computer when bought several years ago.  never activated , seems unable product key version of software.  can me product key can activate fully? hi johanne, we can see want buy office 2010 license. however, office 2010 no longer available. in case, suggest purchase latest version of office office 2016 (one-time purchase) or office 365 subscription. purchase , know more it, kindly click link . if need further assistance in purchasing office, can contact answerdesk through link . feel free post should have further concern. Office / Install, upgrade and activate / Windows 8 / Office 2010

Migration mailbox in Microsoft online platform - Microsoft Community

dear sir i o365 administrator, faced below issues. please solve it. the error screen pop-up when running mailbox migration in microsoft online platform. (more information: confirmed username , password of mrs proxy valid) hi alpha k. h. ng,   to better understand situation, i’d confirm following information: 1. what’s on-premise exchange version, exchange 2010 or exchange 2013? 2. method use migration exchange online? there’s article reference: https://support.office.com/en-us/article/ways-to-migrate-multiple-email-accounts-to-office-365-0a4913fe-60fb-498f-9155-a86516418842   3. have ever tried migrate of mailboxes exchange online test? if so, what’s result? 4. if use admin account create new migration batch, succeed?   thanks, brook Office / Office 365 for admins / Deploy Office 3

Teams and Planner working together? - Microsoft Community

hi, we're rolling out o365 our users , want take advantage of teams , planner.  however, i'm not sure how integrate i'm having trouble setting things up. if go planner , create plan 1 of our teams, can add people , seems work fine. if go teams , create team , create channel correspond team made plan for, can add planner tab when tell link existing plan, don't see plan created directly in planner. also, if start in teams , create team, , channel, , planner tab , create new plan there, when go planner, don't see plan created. am missing or doing wrong?  seems these 2 product supposed integrate doesn't seem working properly. thanks. hi kelemvor33, thanks sharing experience us. office 365 teams , microsoft planner based on office 365 groups. however, planner tab in teams not equal planner. can refer thread for detailed information. meanwhile, agree it's idea 2 prod

spf record not accepted by protection.outlook.com - Microsoft Community

dear tim support office 365 we have issue t he messages below have stared coming in rejection emails today. please me resolve this. autentication_results: spf=fail ( sender ip 43.231.128.105) smtp.mailfrom=primagama.co.id; outlook.com; dkim=fail (signature did not verify) header.d=primagama.co.id; outlook.com; dmarc=none action=none header.from=primagama.co.id; received-spf: fail (protection.outlook.com: domain of primagama.co.id not designate 43.231.128.105 permitted sender) thanks setiadi hi setiadi_863, situation, please clarify whether email service hosted in office 365 (exchange online). if so, spf record should v=spf1 ip4:43.231.128.105 include:spf.protection.outlook.com –all. more information, can refer https://technet.microsoft.com/en-us/library/dn789058(v=exchg.150).aspx .  and, error message, seems sender has configured dkim domain dkim has been failed. so, recommended troubleshoo

Auto resizing note containers (Onenote 2010) - Microsoft Community

Image
when scaling application window note container resizes accordingly. untli manually resize note container. not resize windows , - unfortuantely - can not undo this. or @ least don't know how. does know how undo this? see attached examples a) original note container b) automatically resizing container c) manually "fixed" container: a) b) c) hi, better assist you, need identify first why note containers not resize along application window. have installed latest office updates on computer? if not, recommend install update check if works. may refer link steps. forward reply. Office / OneNote / Windows 10 / Office 2010

OneNote - Microsoft Community

1. my yoga 2 pro failed under warranty , returned me factory reset. 2. i copied across backups , re-installed office 2013 using serial number. 3. when try open onenote files (saved before pc failed) following message: 4. "we couldn't open location.  might not exist or might not have permission to  open it. please contact owner of https://d.docs.live.net/. . . . . . . . more information." 5. it seems reset pc not recognised.  have checked community answers without success, can tell me how fix please? hi joe, upon reviewing case, can see here having issues opening onenote files. need confirm details isolate issue. please answer following: where original location of saved onenote files? saved onedrive or specific pc location? are trying open files onenote app or onenote online? Office / OneNote

One note notebook problem - Microsoft Community

hello i can't open old notebook in 1 note. there no further instructions. says "i'm sorry couldn't open notebook". a few weeks ago had problems synchronise same notebook. grateful answer/idea solve problem!!!!! hello lillian, factors contributing onenote issues may include server errors , corruption. workarounds, advise refer troubleshooting steps provided on link below: fix issues when can't sync onenote let know if require further assistance. Office / OneNote / Windows 8 / Office 365 Home

Errors after the latest Windows 10 updates - Microsoft Community

i'm unable access microsoft edge after latest update, looks going display , closes.   i'm  getting error message can not find  onedrive.exe  the latest update 10/24/2017 no worries. don't need cd perform repair upgrade. once have downloaded media creation tool our software download site, save on desktop , can run there. no cd or flash drive needed. download the tool, click here , , click on download tool now . save mediacreationtool.exe file desktop. from desktop, run media creation tool , go through process of repair upgrade. let know if need further assistance. Microsoft Edge / All other issues / Windows 10

Malware Attack on Microsoft Edge 40.15063.0.0 - Microsoft Community

Image
i have got attack today after updated to microsoft edge 40.15063.0.0 , asked me call number 1-888-241-3676 , person on other side asked me run program apparently fix .. refused , i'm contacting microsoft forum... i'm not going use insecure browser again. did 1 experience before? microsoft message can validate ... doesn't seem , guy on phone number didn't said microsoft...please careful everyone. @ screen grab below. microsoft has this.. hope didn't steal info.....????   if didn't allow them remote access, fine. and, happens using browser including apple's safari. it's common scam. click ok button @ bottom of popup. should see box not allow site create new messages. check , close window. if doesn't work, edge, follow instructions scott_ki here: https://answers.microsoft.com/en-us/protect/forum/protect_other-protect_scanning/edge-frozen-with-virus-warning-popup/7212a393

Update error - Microsoft Community

feature update windows 10, version 1709 download complete 3 times not install if restart pc. shall do? hello fantu, noting details have provided. this can caused several different reasons. software incompatibility or device driver issue. to this, let make sure following below met can avoid installation error in windows 10: make sure device has enough space. device requires @ least 16 gb of free space upgrade 32-bit os, or 20 gb 64-bit os. more info, see free drive space in windows 10 .  run windows update few times. download , install available updates in windows update, including software updates, hardware updates, , third-party drivers. use troubleshooter windows 10 fix windows update errors. check third-party drivers , download updates. can find third-party drivers , installation instructions hardware you’ve added device on manufacturer’s website.  unplug hardware. remove external storage devices ,

Internet Explorer 6 download - Microsoft Community

i'm needing download "explorer 6" view , work in things work. able download couple months ago on hp laptop i'm not having luck @ on new dell (inspiron 3000). microsoft download page says 6 no longer available customer support. please help!!! need explorer 6 (unfortunately) thank you! ie6 has not been supported, or able download in years. wouldn't run on windows version past xp, has built in anyway. Internet Explorer / Internet Explorer Unknown/Other / Other/Unknown

Search bar highlighting - Microsoft Community

when click address bar selects default , able start typing in search request. when click search bar, address not highlighted , instead typing adds in search bar. far aware has been happening last few days after updated windows. how can change settings clicking on search bar highlights contents every time? double clicking on address bar contents not highlight contents double clicking else. Internet Explorer / Internet Explorer 10 / Windows 8

apps - Microsoft Community

how install internet explorer , facebook app pc desktop? how install internet explorer , facebook app pc desktop? which version of windows? don Internet Explorer / Internet Explorer 10 / Other/Unknown

How do I leave the Insider's Program? - Microsoft Community

how leave insider's program? cannot find link on site or in email unsubscribe. two cases: 1. system has insider build 17040. in case, need clean install of latest stable build 16299 using installation media. means lost: https://answers.microsoft.com/en-us/windows/forum/windows_10-windows_install-winpc/clean-install-windows-10/1c426bdf-79b1-4d42-be93-17378d93e587 2. if on latest build 16299, go settings>update , security>wip settings https://www.tenforums.com/tutorials/63585-enable-disable-insider-build-settings-windows-10-a.html and leave insider program Windows Insider Program / Windows Insider Preview / Install, upgrade, and activate

Xbox One S Controller wont turn on - Microsoft Community

bought xbox 1 s controller amazon, 2. 1 controller connects bluetooth windows 10 pc. when try turn on other one, stays on half second , turns off after. updated controller on xbox one, , before, turned on, when press connect button, turns off instantly. please help. hello, since concern xbox, best in touch our xbox support provide better assistance. can visit link more information. regards. Mobile Devices / Accessories / Other

Lumia 950 Double Microsoft-Outlook Account - Microsoft Community

hi, bought lumia 950, configured , works fine. currently, under "settings" --> "accounts" --> "email , app accounts", can see 2 accounts: - 1 under "email, calendar and contacts", displayed "outlook"; - other 1 under "accounts used other apps", displayed "microsoft account". actually, these accounts related same account (same mail address). such "double account" creates, in calendar app, 2 calendar lists, 1 outlook account , 1 microsoft account, same calendars. can delete 1 of these accounts without having problems as contacts, mail, calendar synchronization , on? thank you! mario thank responded our query. what seeing in accounts settings normal. should not cause issues on end. regarding concern calendar entries being duplicated, there setting in outlook calendar app allow choose calendar want appear. remove chec

OneDrive new Section - Can it be removed? - Microsoft Community

Image
hi, since last week, there new section in onedrive displays owner of folder (i believe), "go site" link.  this annoying on small screen (macbook pro 13). there way remove useless section?  see image:  moved from: onedrive / options , settings / web settings / onedrive web (onedrive.live.com) Office / OneDrive with Office / Mac / Unknown/other

Excel for iPad - Microsoft Community

keyboard doesn't default format of cell excel ipad thank information provided, colin. we understand it's hard use excel on mobile device due limitation of keyboard size. however, hear more on how can improve our products convenience providing feedback through link . our engineers , developers looking further concern once posted feedback. should need further other concerns in future, you're welcome post back. Office / Excel / iPhone & iPad / Office 365 Home

Checkbox clicks often don't register in Excel 2016 - Microsoft Community

split thread. hi all, have reported issue related team. summarizing symptom here: description excel 2016 mac checkbox clicks don't register. environment mac os sierra 10.12.2, excel 2016 mac, version 15.29.1, 15.30, 15.31. more information have sent related team investigation. post updates here once receive more information. can subscribe thread receive latest updates. workaround click multiple times tick checkbox. best regards, jim hello jim, bad behavior exists lastest version on office365 mac. using form on 25 checkboxes business makes impossible use. pressing #1 not best solution, cause must catch first box. believe interpretation of bitmap select objects causes issues. can reply issue on dev objects option field. guess more fundamental. temp bad solution: 1. press left ctrl + left mouse select 2. press #1 format box  why bad? in using ctrl catch object, potential move destroys layout.

Excel for Mac - ribbon does not appear randomly - Microsoft Community

Image
hello, i've been having problem open excel document, ribbon won't appear.  when happens, excel not respond file/close command - have quick excel not ideal.  use downloaded desktop version (not excel online). can tell me why happening , how fix it? hi ms_2015, thanks sharing experience us. does issue happen specific excel workbook? if yes, please create new workbook, copy content original workbook , paste in new one. open new workbook , check result. in addition, can try start mac in safe mode, check if issue persists. for reference: use safe mode isolate issues mac disclaimer: microsoft provides no assurances and/or warranties, implied or otherwise, , not responsible information receive third-party linked sites or support related technology. if issue persists, please provide following information troubleshooting: 1.does issue happen specific workbook or workbooks? 2.detailed off

I have two XL files . want to create a new file by starting with file - Microsoft Community

Image
i have 2 excel files. 1 called “a1 good” file has 5 columns  and 986 rows.  the second call “b1 total” has 5 columns 1650 rows.  both files have names phone numbers , email addresses .  i want create third file ,,, call c .. takes b1  file , excludes a1  people .  do know how that?  do know how that?  ok. think understand. open both files in b1 file insert column (or use existing blank column) in the blank column insert following formula on same row data commences. have assumed have column headers used row 2. =vlookup(a2,'[file a1.xlsm]sheet1'!$a$2:$a$63,1,false) where:- a2 first value in file b1 '[a1.xlsm]sheet1'!$a$2:$a$63  workbook name (in square brackets), sheet name , range of data in b1. can select these ranges during creating formula , excel handle syntax) 1 next parameter assuming 1 column of data used table array (in 2 above)) false indicate exact matches. copy fo

Excel help - Microsoft Community

copied google + account. there excel 2016 experts out there? trying complete assignment requires histogram 4 distinct "bins" 1,2,3,4. unfortunately, program wants auto sort data using scott's normal reference rule.  i can change number of bins or describe bin width, not both. changing 1 affects other. of data sets not have entries specific bin seems add problem having.  i haven's had luck searching section online, or calling. struck out on youtube tutorials well.  maybe here can me out? are using histogram in analysis tookpak? (shipped excel)  allows set own bins. -- regards, tom ogilvy Office / Excel / Windows 10 / Office 2016

Windows 10 Excel 2016 - Importing/Auto-update multiple Stock - Microsoft Community

since "finance.yahoo" no longer provides option pull data, has come 'free' way of importing stock prices?  (i.e. current price w/ auto-updates @ defined period; or prior day's close @ minimum). smart-tags don't seem exist longer , thought have been written directly software cannot seem find on current excel versions.   i had read once excel had simple way pull msn-money ? any thoughts/direction appreciated. hi, based on concern, suggest try contact yahoo support further assist on how import multiple stock quotes ms excel. you can post feedback on excel uservoice . gather additional details , information issue determine what’s causing , address it. feedback items regularly receive microsoft responses on submissions in feedback app can see doing feedback. if have other concerns, feel free post back. Office /

autosave - Microsoft Community

i had update microsoft office , doesn't show autosave. how either turn feature on or fix issue. thanks hi daniel,   autosave appears in upper-left corner if office 365 subscriber, , have latest versions of excel , powerpoint 2016 installed. it enabled when file stored on onedrive, onedrive business, or sharepoint online. please open excel workbook stored in onedrive business , check if can find autosave.   besides, please refer i don't see autosave. how make sure files getting saved? part , i'm subscriber latest version of office. why autosave disabled? part in article below, other parts in article detailed information. what autosave?     if above information doesn't help, please provide following information troubleshooting:   1.office version. please go excel>file>account> capture full screenshot of product information described in article . (please mask email ad

excel - Microsoft Community

Image
ive bought excel monthly fee...when click on icon , open wont allow me sign account when resolve account hi james, you firstly check article below activation. activate office 365, office 2016, or office 2013 if doesn't work you, better understand situation,i'd confirm following things: 1.do start trial page ? if yes, select home or business? if not, please share page trial. want know edition of it. 2.by "won't allow me sign account", error message? please capture screenshot it. 3.open excel, check if it's possible click file>account. if yes, capture similar screenshot below. if cannot click options, navigate control panel>uninstall program>capture screenshot of office suite info. best regards, tim Office / Excel / Windows 10 /

I need to have a cell in the main sheet of my workbook invoke a new - Microsoft Community

it simple but........ i have time sheet workbook.  columns days, rows time. 1 of rows mileage. want able type in mileage , have book create new sheet template have designed explain mileage text box notes. want have front sheet create hyperlink new template automatically , name sheet according date associated mileage entry dates on time sheet automated. i aware information not  enough answer hope generate string me. nino d. hello, this require vba , bit more question covers. if want write code yourself, may want @ many free vba resources , tutorials on web. chip pearson's site excellent.  http://www.cpearson.com if stuck specific aspect of code, come , ask question in context.  Office / Excel / Windows 8 / Older versions

SUMIFS - Microsoft Community

Image
i'm trying write formula subtracts sum of column k column t if column n or column o match column r the formula in table expands based on number of calendar entries each day. column t , k numbers (hours job/crew) column n, o , r text fields (names of crew) if use =t14-sumif($n$9:$n$90, r14, $k$9:$k$90) works column n (of course - that's way it's written) but if use =t14-sumif($n$9:$o$90, r14, $k$9:$k$90) still works column n not column o if use =t14-sumifs($k$9:$k$90,$n$9:$o$90, r14) "#value!" error if use =t14-sumifs($k$9:$k$90,{$n$9:$n$90,$o$9:$o$90}, r14) tells me have formula error i have googled / watched countless examples/tutorials , still can't make work suggest abandon sumif in favour of sumproduct in snip below, yellow stuff data , find sum of numbers in when wither b or c has value x. the green stuff confirms our result best wishes

Excel find data - Microsoft Community

Image
support, i looking formula aid in finding data per row of text. the scenario, i have string data in table, table 316789 rows long , contains columns > y. on every other row example rows 2,4,6,7,9,10....etc 1 of cells contain string “(hitcnt=12321)”.              please note number on each row after “hitcnt” maybe different. what need formula first check row 1, , if finds cell between a1 > y1 contains string “hitcnt”, copies entire cell z1. the formula move onto next row , same thing. the main problem in 316789 rows of data, th string “hitcnt” in cell. if worked on every cell individually work using formula =if(isnumber(search(“hitcnt”,n1)),n1,””) but formula dependant on me knowing in every row string hitcnt in column n, might not case. is possible that? the trick use match function index so snip readable used m best wishes Office

Unable to configure Office 365 mail on Mac Mail - Microsoft Community

hi,  my office 365 subscription setup using default mac email client until last friday. on weekend authentication happening in house within company logging on office 365 migrated microsoft handled cloud. ever since email stopped working. deleted account can't setup on mac. can use outlook mac 2016 want use default client while setting errors out saying unable verify account name or password. i faced similar issue on iphone deleting , recreating solved on iphone doesn't works on mac. skype business , other office apps working seamlessly. any appreciated. hi gaganm, since office 365 account working on other devices , clients, means account good. issue should related default mac mail app. i add test office 365 account default mail app in our test mac machine without issue, need collect more details scenario meet. 1. screenshot of error. 2. please clear mail cache in path:  ~/library/conta

how to install visio 2010 on windows 10 with office 365 - Microsoft Community

how install visio 2010  on windows 10 office 365 [moved from: office / visio / windows 10 / office 365 home ] Office / Install, upgrade and activate / Windows 10 / Office 2010

Downloading home and student 2016 - Microsoft Community

hi. computer crashed , needed new hard drive. how reinstall home , student 2016 computer? ***post moved moderator appropriate forum category.*** see: download , install or reinstall office 365 or office 2016 on pc or ... Office / Install, upgrade and activate / Windows 10 / Office 2016

Product key - Microsoft Community

we purchased laptop, , threw away packaging laptop week after purchased it.  there anywhere else have key code on laptop? thanks, linda ** moved thread an appropriate category proper assistance (office > install, upgrade , activate> windows 10 > office 365 home) moderator hello linda, if product key has been associated microsoft account, no longer need it. can reinstall office 365 time going office.com/myaccount, , signing in microsoft account. more information, may refer answers of aravinda balakrishna , rohn007 on thread link . let know if require further assistance. Office / Install, upgrade and activate / Windows 10 / Office 365 Home

Verification of account - Microsoft Community

i'm not receiving code phone number verify account. email on record no longer valid nor accessible me. why not receiving either call nor text code? hi elmarie, you need make sure have stable signal on phone receive verification code no delays. in meantime, may change contact information visiting microsoft account site. allow provide option wherein able verification code. let know if need further assistance. Office / Install, upgrade and activate / Windows 10 / Office 365 Home

Dynamic 365 email notification - Microsoft Community

hi, am new crm environment, trying out email notification workflow when case submitted via dynamic 365 portal.  when case submitted no owner assigned , default system becomes owner of case created, now, want send email notification user of portal , others (via shared email group) notifying about new case.  how do this? basically use outlook out internal mail communication. hence tried setup pop3/smtp server in dynamic 365. getting error saying server location not supported. tried setting pop/smtp with personal gmail and worked charm. can please let me know how configure outlook email purpose.  thanks, greatly appreciate your response  sakthivel hi sakthivel, regarding dynamic 365 have dedicated support team therefore, i’d involve our dynamic community support team in finding solution you. please post question in appropriate forum , our experts’ focus on issue resolved more efficiently.  tim

hey i have lost my product key now what to do - Microsoft Community

sir have losted microsoft product key showing deactivated of ms office moved from: windows / windows 10 / windows settings / pc try article... https://support.office.com/en-us/article/using-product-keys-with-office-365-office-2016-or-office-2013-12a5763a-d45c-4685-8c95-a44500213759?ui=en-us&rs=en-us&ad=us#bkmk_promptforpkey office asking me product key Office / Install, upgrade and activate / Windows 10 / Unknown/other

windows 10 - Microsoft Community

hello. have bought new laptop has windows10 - assumed microsoft office installed.... need buy it, if how buy it? [moved from: windows insider program / office on insider preview / word / pc] hi, to buy microsoft office product, may refer link .  steps on how can download , install office on pc, can check out microsoft article . for more information office apps in windows 10, can learn more here . let know if need further assistance. Office / Install, upgrade and activate / Windows 10 / Unknown/other

Office 365 Apps Stuck on "Setting Up. - Microsoft Community

split thread. sorry couldn't reply other way - experiencing issue across large sized tenant. seems random users. appreciated hi rohin, thanks sharing. it should provision issue , turn off turn on related licenses, triggers provision affected accounts , helps fix issue. best regards, tina Office / Office 365 for admins / Deploy Office 365 / Office 365 for business

How do I add a personal iCloud account/calendar to O365? - Microsoft Community

split thread. that appears how add public or shared icloud calendar. i asking how can add/view personal icloud calendar (say account   *** email address removed privacy ***) o365 owa calendar view. thanks. richey hi richey, "public calendar" means need share/publish calendar others , .ics url ( likes: webcals://sharing.xxxx.com/calendar.ics).  so, way add icloud calendar office 365 owa publish icloud calendar .ics url , add .ics url office 365 owa. more detailed information "open internet calendar in outlook on web business", please visit following url: https://support.office.com/en-us/article/open-an-internet-calendar-in-outlook-on-the-web-for-business-5de44446-aa16-4e8f-9ddd-84f170446226?ui=en-us&rs=en-us&ad=us&fromar=1 thanks, edward Office / Office 365 for admins /

OneDrive for MAC not deleting files when Sync and upload files again - Microsoft Community

dear all, i have recurrent issue onedrive mac, using latest version 17.3.6919 i have 2 macs, 1 mac mini external hd placed onedrive folder, , macbook pro retina using default folder location onedrive. issue when create files mac mini, or delete them, rename, etc  all changes correctly following sync process , changes reflected macbook pro. when other way, means deleting files example macbook pro, files mac mini not deleted , worst start upload files again!! (the ones supposed deleted during sync). i tried uninstall/install onedrive app macmini problem persist, had removed onedrive folder , allow onedrive installer create again...... if change permissions of onedrive folder 777 macmini sync happens ok, not expected done time right?  can has fact using external attached disk store 1 drive folder in macmini??? volume standard fs mac, permissions set (compared macbook pro).. appears onedrive app running different user in macmini avoid update or d