Cororate

hello, i trying write formula "if" cell value 30(cell a2) divide 70 , if (cell a2) has value 100 divide 40. how place formula? managed place 1 formula i.e. =if(d2=30,f2*70) want add condition along formula =if(d2=100,f2*40) how write it. thanks  hi, there no divide function in excel. however, can divide numbers in cell. know more task, please visit support article . hope helps. let me know if have further concerns. regards. Microsoft Education / Office / Excel

 iwant to open microsoft streets , trips 2004 file in 2010 or 2011 or last version harry thank you [original title: microsoft streets , trips 2004] hi almohandisest,   based on description, issue related streets , trips 2004. given situation, suggest post question our streets , trips forum dedicated help. there’s category streets , trips.   thanks understanding. qing Microsoft Education / Office / Other

i shouldn't complain site weird. if question has been answered 1 has, if reply email , click read reply on microsoft community , goes top of a page displays question , that’s been marked answers. see new reply, need click on name in upper right, click on profile, click on last reply 19 hours 52 minutes ago  for question has new reply. takes it. i've found no other way it. i shouldn't worry things starting discussions long have own workaround, that's ol' jeff. Community Participation Center / Discuss the Microsoft Community site / Site suggestion

this happens quite bit when i'm trying load something......   how fix? if happening on 1 (or few) website(s) there really (by internet explorer standards) long running script on page , ie doing favor providing "stop script" option. click on stop script button. again, if only a site or 2 affected... it might break desirable feature on site, placing site in restricted sites disable javascript , script messages stop. internet options> security> restricted sites... if you're seeing message on or sites, browser add-on might causing it. note: google toolbar has caused script problems users. start internet explorer without add-ons start> programs> accessories> system tools> internet explorer (no add-ons) or from start> run (or windows logo key + r) type in iexplore.exe -extoff (iexplore.exe<space>-extoff) hit enter. if problem goes away, an add-on causing i

whenever select , "open" picture folder comes in paint 3d has somehow become preferred place appear.  not want this.  how can normal ? hi, there's possibility paint 3d default photo viewer. change this, go settings > apps > default apps . under photo viewer, click photos . then, choose preferred app photo viewing. should have other concerns, don’t hesitate let know. Windows Insider Program / Apps on Insider Preview / Insider Hub app / PC

hello, first post forums. let me preface, windows insider- getting updates on active development on fastest channel. i haven't been able find issue similar mine on here. i able download , install updates, when comes down restarting computer finish updates computer restarts doesn't install update.   have attached screen grab of issue... have tried resetting update components , running troubleshooter multiple times. i'm lost... ***moved from: (english / windows / windows 10 / windows update, recovery, & backup / pc).*** hi...have got 'active hours' set time scheduled time period prefer? you may have defective update , have start over. you can try 'disk clean-up' of 'system files' delete contents of download folder: path:> c/windows/softwaredistribution/ download folder. *john Windows Insider Program /

pass this. want register program of windows insider, problem when give button "getting started" jumps error page (this more specific https://insider.windows.com/home/error ) ... have tried several times , wrap want register ... can me? is device language set non english language, if try setting english use web page, then original language later. if set english try using different browsers. Windows Insider Program / Windows Insider Preview / PC

how resolve error - error 0xc190011f   ???? , answers post should include minimum information. 1.  device type. ie pc, laptop, tablet, surface, phone 2.  made , model. if home built type motherboard 3.  os type, home, pro, enterprise, etc 4.  current build.  go settings, system. about. os build xxxxxx.xxxx 5.  insiders include rs4_release or rs_prerelease. 6.  happening on computer,  boot, screen, app, etc Windows Insider Program / Windows Insider Preview / Windows Update / PC

i keep getting mtp device driver failure when trying update surface book 'see' phone.  has been going on several updates. moved from:  windows / windows 10 / devices & drivers / pc since have exhausted possible troubleshooting steps issue , still cannot mobile device detected surface book, we suggest contacting our answer desk team further assistance regarding matter. can reach them clicking on link . regards. Windows Insider Program / Windows Insider Preview / Windows Update / PC

i have lumia 830, i've been using windows 10 preview while, became unbearable, decided revert windows 8.1, downgraded couldn't login microsoft account, therefore can't download in store, nor can update w10 once again. i can't stand anymore, it's been 3 days already. there fix? there way force update this, can log in again? i hard-reset 14 times, soft-reset it. winrt 8 goddamn times, changed data, manually, automatically, changed region, language, prayed little. i don't know anymore, brick more useful phone right now. Mobile Devices / Microsoft Lumia and Nokia Lumia / Microsoft account

i have nokia lumia 630, , has windows 8.1, , no longer supported. why it? why did stopped supporting it, there lot of people, has phone, can't upgraded windows 10? it unfair, , unethical customer, , i'd fair solution, apps back. ***"sub-topics" edited clarity moderator.*** it reached end of support cycle. still works fine, there no further development nor updates in future. with regard app developers have decided stop supporting wp8.1 - need ask them why - phones still work fine. Mobile Devices / Microsoft Lumia and Nokia Lumia

download **the "topics" edited clarity moderator.** hi, it seems you're having issue downloading apps on phone. contributing factors microsoft account issue, server not responding, , phone's software issue. these affect phone downloading apps store app. more information this, please answer following questions: which windows version running on phone? are getting error message or code? which type of internet connection using, wifi or mobile data? what troubleshooting steps have tried far? regards. Mobile Devices / Microsoft Lumia and Nokia Lumia / Apps + Store / Other/Unknown

in phone have skype not being upgrate . app store can't download apps. seeing microsoft account. did microsoft account . seeing family set . . , how . plz tell me do. hi, family allows people add kids' account , restrict can/ cannot phone. simply, tap started begin setup of family account. taken kid page can add kid's account. tap go. on next page, have sign in kid's microsoft login. if kid doesn’t have microsoft account, can go ahead , create account on screen. once kid’s name has been added page, tap fix link below name , accept windows phone store terms of use. child able download apps , games windows store. let know if need further on downloading app on phone. Mobile Devices / Microsoft Lumia and Nokia Lumia / Apps + Store / Other/Unknown

my son getting fitbit christmas , trying install fitbit app on windows phone keeps telling me cannot install app due family settings.  cannot see family setting preventing me installing app.  have tried turning off restrictions , still doesn't work.  fitness tracking app fail see problem restrictions.  please help **moved from: (windows / windows 8 / other windows apps / other).** hello lewis, some of things may affect how download apps in windows phone include poor internet connection, incorrect date , time settings, or incomplete information in microsoft account profile. if on legal age , being asked set family, date of birth might entered incorrectly microsoft account. sign in here , check date of birth. also, suggest please check article on how manage family settings . we're here if have further questions. regards.    Mobile Devices

my samsung a5 galaxy  seems in hanging mode more 1 hour should ? can u please?  need contact samsung support or @ least forum dedicated android devices. microsoft, resp. windows support forum , cannot you. Mobile Devices / Other Windows mobile devices / Tips, tricks, and customization / Other/Unknown

hi all, i check how proceed password retrieval. i bought , installed office 2016 on 1 of users pc, during installation have created outlook.com account setup. its been while , when doing inventory check, found have missed out on taking down password particular account.  so tried reset password, (1) cant remember details during account creation , (2) not using account emails, i unable fill enough data retrieval form. i have physical 25 key box me, how should proceed account? i have tried failed re-link 25 key email. thanks ks hi, to retrieve account password, kindly check article . provide steps on how can reset password. please let know if need further assistance. Office / My account, billing and sign-in / Windows 10 / Office 2016

hello, i working contract cfo on financial projections. has created spreadsheet both need update periodically. best 1 of host spreadsheet in cloud, , share other make sure we're both working same document.  what best way that? i'm on mac, he's on pc. have onedrive account.  thanks, chris hi badlydrawnboy,   are wanting collaborate using excel client? if yes, not possible between mac users , windows users.   the feature available windows users using office 365 subscription within following excel versions: insider fast channel: march 28, 2017 build 16.0.8017.1000. insider slow/first release current channel: july 17, 2017 build 16.0.8326.2033   for feature, suggest share same in user voice . features updated based on customers' constructive comments. understanding.   however, feasible collaborate using excel online. upload excel workbook onedrive , share cfo, can that.   i

in excel 2016 mac, in few charts @ random places font size changes on horizontal axis values. looks fine on pc displays wrong on mac. see last 2 columns in sample chart screenshot below. first notices 6-9 months ago. ideas? hi helen,   we have tested problem on our side, found in 15.40 can reproduce problem have, while in insider fast, problem resolved. can try using insider fast version or can wait fixed version.   if want use insider fast, can refer article: what office insider?   regards, tisky Office / Excel / Mac / Office 2016 for Mac

can provide a formula that counts number of rows have @ least 1 numeric value in c:l in row, without relying on helper cells? the formula must work in excel 2003. see image below.  can download file "count rows conditions.xls" ( click here ). [1]  ignore preview errors.  download file. the formula in m3 =sum(n6:n19) . the formulas in n7:n19 of form (showing n7; n6 empty):  =--(count(c7:l7)>0) . note ryan has no 1s in row.  ryan should not counted in m3. ----- [1] https://app.box.com/s/5ytmtyiews42p6p9fsum83fnv5633bt4 enter below formula array formula (ctrl+shift+enter): =sum(--(frequency(if(c7:l13<>"",row(c7:l13)),row(c7:l13))>0)) counts non-blank rows. regards, amit tandon www.globaliconnect.com Office / Excel / Other/unknown

i want copy xlsx. (excel online) data , paste xls.  (old excel). there no way save worksheet xls. i 6 col x 20 rows until recently, control c control v .   more corrupt information, formatting, etc.  no copying @ all. rob Office / Excel / Windows 10 / Office 2007

os windows 10 v1607 x64. after update excel 2016 version 1707 build 8326.2062 click-to-run, add-in can't not run more. error "you not have appropriate license use functionality". what matter? add-in runs before update! anybody knows how fix? or how degrade/remove excel update? in advance. hi rex, exact error message "error 429 - not have appropriate license use functionality."? if yes, have happen when launch frx, software product used financial reporting , analysis small mid-sized organizations, while computer has number of frx versions installed. please click here , find resolution fix issue. if you'll needing further assistance, please don't hesitate post back. Office / Excel / Windows 10 / Office 2016

the shortcut ctrl+h supposed display find , replace dialog box, replace tab selected. since several days, since last update (office professional plus 2016, version 1708, build 8431.2079) shortcut ctrl+h displays find , replace dialog box, find tab selected (same ctrl+f). this appears in excel, not in word. else experience bug? hi, issue ctrl+h when opening find , replace dialog box in excel was fixed per office monthly channel version 1708 (build 8431.2094) . same issue discussed on thread . once you're on page, kindly refer felix tao msft's post more information. let know if have other queries can assist with. Office / Excel / Windows 10 / Office 2016

hi, i have office 365 installed in windows 10 pc. excel version 1708 build 8431.2107. not able see auto save icon on top left corner. have tried open file 1 drive still icon missing. how auto save option. hi  srirengarajan, the autosave feature has not been made available semi-annual channel (targeted) yet. feature available on monthly channel. you're welcome wait next update on the  semi-annual channel (targeted) or switch current channel. if wish make switch, make sure following organization's policy, suggest contacting org's department. regards, sheen Office / Excel / Windows 10 / Office 365 for business

hi, i'm trying figure out formula return person's last task end date, , enter following day start date next task. there may situations subsequently entered tasks, if these have end date sooner previous tasks end date (for tasks dumped on them while in middle of something, completed before previous one). like in following example, instead of =f2+1, i'm after recognise person start date being entered (tommy h) , list of tasks, find person's name, , find predicted end date value occurs last (ignoring end date f3 of task in ) - , enter value + 1 new start date. thanks try =maxifs(f2:f5,f2:f5,"<"&today(),c2:c5,c6)+1 best wishes Office / Excel / Windows 10 / Office 365 for business

why excel freeze when trying use data subtotal sum values have same narrative.  this worked fine office 365 wont have spotted problem - have make sure flag removed on"replace current subtotals" though there none.  this clears problem Office / Excel / Windows 10 / Office 365 for business

tell me function has stopped working.  all tone stating can not access or not work hi nancy, " my tell me function has stopped working ", share steps how reproduced situation , provide screenshots of symptoms understand scenario? moreover, may let know excel version. check version: open excel>file>account>capture screenshot of product information , share us. regards, felix Office / Excel / Windows 10 / Office 365 for business

in column there blank cells , data cells. want data cells out blanks. hi george, not quite enough info here. do have single column of data? if multiple columns, blank cells extend right across data? Office / Excel / Windows other

hi, may check if there formula can put in 2nd table excel can pick value 1st table based on start , end date update staff movement? thanks! i see mistake.  please ensure serial number column true number. shouldn't text. also see file @ link. https://1drv.ms/x/s!apywctyrvafkg0cderab6tonkib- Office / Excel / Windows other / Office 2016

i have tried vlookup , looked other formulas, can not find solution, expect there easy solution. i have 2 tabs:   test master , testsheet1.    i want find person test master in testsheet1 , copy 'department' name testsheet1 test master specific user.  in test master not exist in testsheet1 , not have department fine. here sample sheets. anything can suggest?    thank you! your 3rd parameter in vlookup should column number want return not range of values want return. 2nd parameter should range cover data not lookup column. =vlookup(a2,testsheet1!$a$2:$b$10,2,false) you can wrap in iferror cater ones not found =iferror(vlookup(a2,testsheet1!$a$2:$b$10,2,false),"not found") Office / Excel / Windows other / Office 365 for bu

hi guys, i not able open infopath formin sharepoint online. getting below error  this form cannot opened in web browser. open form, use microsoft infopath. please suggest on this. thanks, hide error details correlation id: 26xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx36b18 omkar. [private message removed forum moderator] hi omkar,   according error message, may refer suggestions in article . (you need download document check detailed information.)     if above doesn’t help,   please provide following information troubleshooting:   1.a related screenshot of error message "this form cannot opened in web browser. open form, use microsoft infopath."   2.how open infopath form? please provide detailed steps before getting error.   3.your tenant information. please provide information in private message se

i have 2 interrelated problems: my company uses microsoft 365 our email system.  on personal computer, mac, use @ office, subscribe office 365.  latest update of excel not seem work me in have updated @ least 10 times , continues indicate need update  excel software.  when tried reach microsoft support desk via website, microsoft tells me have company edition , should reach out company administrator.  company administrator has nothing personal office subscription.  cut off support office , continue have issue.  on both issues please. 1. go tools > disable add-ins , see whether problem disappears. if yes, enable them 1 one , see 1 culprit. 2. try updating mac os 3. try updating office again. solves many problems. https://support.office.com/en-us/article/check-... 4. uninstall , install again option you? mean either have microsoft account or product key? if have, uninstall current installation complet

how cancel microsoft office  free trial? want cancel subscription. thanks might help: cancel office 365 Office / Install, upgrade and activate / Other/unknown / Unknown/other

hi  i have microsoft office professional plus 2013's product key, , download on new desktop.  cannot find link download on microsoft website. can guide me download link.  not have office on desktop. thank you, ketki there no direct link download of office pro plus 2013 you can sign in link & choose options install there https://support.office.com/en-us/article/download-and-install-or-reinstall-office-2013-on-a-pc-7c695b06-6d1a-4917-809c-98ce43f86479 Office / Install, upgrade and activate / Windows 10 / Office 2013

can not activate office word using microsoft account. @ end tells me account not associated office word. should activate office word? hi, we need know if installed office 2016 through office 365 license or office perpetual license.  we recommend check response of parth p patel on thread . provide steps on how can activate office product. don’t hesitate contact if have further inquiries.   Office / Install, upgrade and activate / Windows 10 / Office 2016

it wont let me activate word 2013 . how fix that? see: https://support.office.com/en-us/article/activate-office-365-office-2016-or-office-2013-5bd38f38-db92-448b-a982-ad170b1e187e Office / Install, upgrade and activate / Windows 10 / Office 365 Home

i purchased microsoft .but,i can not open.it keeps saying need reactivate account.please help hi mary, you need activate office make sure you'll able use full function , make sure using genuine product. assist better, we'd ask if have microsoft account activate office. suggest follow steps in article . let activate on internet telephone , troubleshoot 1 experience activation errors. feel free post if need more assistance. Office / Install, upgrade and activate / Windows 10 / Office 365 Home

how can know key of office attached account why want know key? after office 365 activated key no longer usable. stored in myaccount site. don't know 365, 2016, show last 5 char of key in myaccount. Office / Install, upgrade and activate / Windows 8 / Office 365 Home

hello team, i have exchange 2013 users syncing ad 2012 r2 office 365 e3. no hybrid yet. i have noticed that  health mailboxes have started show in office 365, shown below. now did read somewhere in forum use command  get-mailbox -monitoring | remove-mailbox , delete onpremise , sync cloud, doesnt permanently fix issue. after few days, again synced , seen on cloud. i have unselected microsoft exchange system objects syncing, shown below can direct on needs done permanent fix ? hi aishwarya,   yes, you’re correct.   as know, there’s 1 solution resolve case. delete mailboxes on-premises using ems command: get-mailbox -monitoring | remove-mailbox manual sync using azure ps: start-adsyncsynccycle -policytype initial and wait online users deleted. then restart service 'msexchangehm' (health manager) the health manager recreated health mailboxes not synced cloud.   i notice have pe

hello, i purchased account when try log in system tells me there isn't account associated it. please help. thanks! hi martha, did error following picture shows? if yes, reason don't have required office license when trying activate office. please sign in office 365 subscription page , make sure have been assigned license called " the latest desktop version of office ". if not, please let office 365 admin assign "office 365 proplus" or "office 365 business" license you. then, need sign in office licensed account activate it. if above not scenario, please let me know 1. office 365 subscription you're using? 2. screenshot of error message "the system tells me there isn't account associated it". 3. want sign in? thanks, james Office / Office 365 for admins

keep getting notice office 365 subscription expired account set on auto-renew , current subscription thru june 2018.  hi jhamilton89 , when office 365 subscription expire, receive notice well. notification comes when have been disconnecting internet long time or subscription not kept current. to confirm this, you  go office 365 subscriptions , check expiration date of office 365 subscription? please note need admin of tenant check this. you can provide detailed information screenshot below(eac> billing>subscriptions) or screenshot include expiration notification: if subscription expire, please refer solution in article reactivate office: a subscription notice appears when open office 365 application . thanks, huni Office / Office 365 for admins / Other/unknown /

i message saying "combo box not found" every time open word document. happened after updating word v.16.8. i'm on office insider slow , using mac. how resolve this? thanks was getting same error after updating version 16.8 of word, mendley plugin. mendley have update error, in version 1.17.13, , error didn't show again. Office / Office Insider / Mac / Word

i stupidly put folders edited work "pictures" folder; automatically synced onedrive. no problem there, right? when deleted onedrive folders linked folders on computer deleted. oops! cannot recover them onedrive recycle bin (i did moments ago, gone). clicked "restore" not restored. folders edited work, of irreplaceable, gone. gone. microsoft!!! why did deleted folders not restored? hi jesse, we find have post thread situation on our forum. we have moderator on thread. please follow on thread: deleted onedrive thanks understanding. qing Office / OneDrive for Business / Windows 10 / Office 365 for business

split thread. me too. though i'm not using buisness version, window-10 on lab top. i'm trying limit upload speeds onedrive doesn't hog bandwidth. found in structions invole clicking on onedrive icon settings. when setting not there.  -arthur hi arthur, i explain suggest click onedrive icon @ task bar of computer, not click on video, can check icon below: if couldn't find it, please provide screenshot of task bar provide. regards, qing Office / OneDrive for Business / Windows 10 / Office 365 for business

my 1 note crashes open program. program date. have attempted uninstall , reinstall. have updated , reinstalled imac os. here error report. microsoft error reporting log version: 2.0 error signature: exception: exc_bad_access exceptionenumstring: 1 exception code: kern_protection_failure (0x0000700006745ff8) date/time: 2017-10-04 00:25:41 +0000 application name: microsoft onenote application bundle id: com.microsoft.onenote.mac application signature: onmc application bitness: x64 application version: 15.38.0.17090100 crashed module name: microsoft onenote crashed module version: 15.38.0.170901 crashed module offset: 0x00000000008830dc blame module name: microsoft onenote blame module version: 15.38.0.170901 unsymbolicatedchecksum: a047b1ecb96ad7969ff29242534fc178 blame module offset: 0x00000000008830dc stackhash: 301f_background application lcid: 1033 app info: reg=en loc=0x0409 build type: ship audience: production

hello,  our org has thousands of pages of documentation in onenote. need way determine following:  number of hits per page number of hits per section number of hits per notebook who hitting these how long spending on content and other simple analytics.  1. onenote online accommodate simple feature? 2. if not, soon?  thank you,  hi eric_thomas_   you can view page version know has edited page , when.     for rest of requirement, isn’t feasible in onenote online view information.you can provide feedback product group through onenote online uservoice . uservoice best way provide suggestion.   you can check following article know task can perform in onenote online: onenote online   regards, neha Office / OneNote / Other/unknown /

cannot open onenote aspx.mht file. orginally onenote file , not have onenote folder. saved aspx.mht. using windows 10 , onenote 2016. please help. a .mht file should opened after double click in internet explorer. bernd Office / OneNote / Windows 10 / Office 365 Home

i tried import pages evernote onenote. the pages imported without title. major bug me. i can see not setting fix problem in importer. please help. ***post moved moderator appropriate category*** hello adrian, there possible reasons why encounter issue onenote. may caused importer or app outdated. isolate what's causing issue, suggest update both onenote , importer , see if issue persists. please keep updated provide more help. Office / OneNote / Windows 10 / Office 365 for business

have windows 10 , use microsoft edge. when print internet print comes out small can not read it; how enlarge print can see clearly? hi, printing content directly browser may result in limited customization . in screenshot below, show how on paper once printed. if not satisfied font size, use scale adjust settings. let know how goes. Microsoft Edge / All other issues / Windows 10

red vertical lines appear on of pictures , videos when microsoft edge used. how removed? hello lisa, this issue due incorrect/incompatible graphics card drivers installed on computer . for better assist you, we'd know following: confirm build installed on device. check, follow steps below: press windows key + r , type in winver . click ok . were there recent changes made prior issue? does issue occurs on microsoft edge? have tried using browser? what make , model of device? meanwhile, recommend updating display adapter's driver. refer steps below: 1. press windows key + r , type in devmgmt.msc , press enter . 2. expand display adapters category, right click graphics card , select update driver . 3. select search automatically updated driver software . 4. if windows doesn't find new driver, can try looking 1 on device manufacturer's website , follow instructions. we forwa

i have blogged info log out of micro soft edge, results, others have ask microsoft error, no response micro soft info log out-----zero response problem??? blog reply micro soft, response, (paraphrasing response) windows 10 new , still working out bugs??? if there way log out of micro soft edge, included when there answer. thank you??? * moved insider what mean when want log out of edge?  if saying not want use more browser.  use avant browser firefox rendering , firefox nightly.  have unpinned edge start , taskbar. . to answers post should include minimum information. 1.  device type. ie pc, laptop, tablet, surface. 2.  made , model. 3.  os type, home, pro, enterprise, etc 4.  current build.  go settings, system. about. os build xxxxxx.xxxx 5.  insiders include rs4_release or rs_prerelease. 6.  happening on computer,  boot, screen, app, etc 7.  error getting if any

split thread. are facing problem microsoft edge too? try run windows update , install updates. i have microsoft edge , having same issue.  microsoft icon, when hover on it, says "no actions needed."  when try open check updates, same thing microsoft edge, flashes , closes down.  have tried method using microsoft key+r , typing command inetcpl.cpl folllowed resetting browser setting in advanced tab.  what else can do? Microsoft Edge / All other issues / Windows 10

hello. hope can clear me. click on "discuss microsoft community site" i see whole bunch of threads there. of them questions , of them discussions. i'm not sure should in section, seems should threads community.  there few threads community, there threads every thing else. there sections discussions , questions. if have question, thread should started in question section. if want have discussion, should start thread in discussion section. i'm new member here , confusing me. seems confusing new members.  i'm thinking new member posts thread in wrong place , don't need. can't forum. don't have answer this; have question this. here think needs corrected? ps started similar thread , got locked. don't know about. thought helping forum better. donetta89 hello. see moderation request section, can request threads moved, , see members spend lot of time requesting threads other member

i have windows 10 pro insider preview 16251.rs3_release.170721-2122. after booting received message ms account needed attention proceeded mail , selected fix account, received disk full error. have ssd 120gb w/10gb free.  cleaned user/.../appdata folder had 50+gb , still can download app store or fix account. hi, for assist in regard error code 80090027, suggest in referring post of greenreaper thread possible resolution on concern. do tell results , if have other questions, don't hesitate post back. Windows Insider Program / Windows Insider Preview / Desktop and Start / PC

no build today. i'm hoping too! buildfeed has 1 new build showing. but there may more...? edit 1. stoppress lawrence crumb confirms new build tomorrow. tomorrow, july 13,2017 in redmond, there build go little further toward fall creators update. Windows Insider Program / Windows Insider Preview / Windows Update / PC

hello, i error code 80073d0d every time try install viber app on lumia 640 xl lte. tried powering off, installing on msd card, on phone, soft reset , without msd card, hard reset , reinstalling again, windows 10 mobile apps, error persists. can please help??  i running latest official update of w10m phone -1703, os build 15063.728. version 1709 not supported on phone, according microsoft. hi borut, the error code 80073d0d relates having issue in accessing disk program being written to. since issue remains unresolved after performing hard reset , installing software update, advise phone, reset phone software using recovery tool time. more detailed information, can refer windows device recovery tool: faq. your phone reset factory default status upon using tool. installation process delete content on phone including apps, texts, , photos. avoid losing important files, recommend back files before using s

on old dumb phone; nokia 6300; put on welcome message. every time phone switch on there message: if found, please call (02)..... just in case found phone. is there way put welcome message on sister's lumia 520 , l550? s thing can think of can send message phone via find phone app set need logon microsoft account on phone , pc @ same time register phone via pc there can send message phone visible on lock screen don't know if message stay there or disappear once use phone try , see happens rgds roy Mobile Devices / Microsoft Lumia and Nokia Lumia / Settings / 500-series

need update window phone , default wifi settings on. how switch mobile data cos wifi service not available.? can not update on mobile data, has wifi. Mobile Devices / Microsoft Lumia and Nokia Lumia / Software update

as plug in usb c connection (including microsoft charger, usb connection computer, etc.), 950 xl either: freezes / goes death spiral of trying restart / ignores connection / occasionally charges (but unpredictable). has been happening since last update. have changed batteries, removed / changed sim cards , sd cards - still same. once remove usb c connection, phone works fine (if charged...). have suggestions? thanks! ****moved windows / windows 10 / devices & drivers**** got it, baschi. if tried using compatible cable connect lumia 950 xl pc, it's more of hardware issue. it's best contact b2x support further assistance. through them, click b2x customer care . let know if have other concerns.                                 Mobile Devices / Microsoft Lumia and Nokia Lumia / Using Windows 10

just updated windows 10 mobile 8.1, after not able attach mail "outlook mail" app. using lumia 830. when click on attach icon or use insert file or picture menu, nothing happens, can please let me know how fixed did hard reset, working fine Mobile Devices / Microsoft Lumia and Nokia Lumia / Using Windows 10 on phone

dear all, i have 2 text box controls ( start date1, end date1 ) of date values. have text box control ( week1 ) representing first week of year. i need expression code for week1 text box control show number of days in between start date1 and end date1  falling within this  week1 . can anybody help to get answer required. advance thanks. your post little confusing.     what control source of start date1 , end date1 - or enter dates? so number in week1 never greater 7 is  representing first week of year. then want "the number of days in between start date1 and end date1  falling within this  week1 ."   Office / Access / Windows 10 / Office 2013

have msaccess table ("combined") and created query makes sure 2 fields (in same table) have data in them ("ftnb").  need create separate query (to used in mail merge) looks @ combined , subtracts out matching records ftnb. help! you can use left or right join in query , set criteria of null under 1 of fields non-matching. without exact table , field names common field(s) it's bit difficult provide non-generic answer. might work: select tablea.* from tableb right join tablea on tableb.fielda = tablea.fielda where tableb.fielda null; Office / Access / Windows 10 / Office 2016

purchased microsoft office 2016 through hup month. notice if want continue use have pay $119 per year starting in mid november!! purchased few days ago. why have pay fee more hup negotiated price when have had software 1 month! ridiculous. had purchased ms office 2010 , used several years without hassles. note: purchase software legally product code etc. thank you.  hi blair, pre-installed copies of office may come product key, or activate on internet no product key being required. if product key not required, please note limited time offer , expires 6 months after activate windows. suggest contacting our microsoft accounts , billing department further assistance regarding office 2016 issue. let know if have other concerns. Office / My account, billing and sign-in / Windows other /

i have decadry place cards,6 a4 sheet.how print tent place cards on them? moved windows / windows 10 / windows settings wonder decadry might think .   Office / Excel / Windows 10 / Office 365 Home

excel update stalls during installation. how correct it. hi rolliekimbrough, when installing updates, update package installed office 365 applications @ once. can’t install updates single app in windows. mentioned issue excel, please confirm , how installing updates? getting error? if so, please provide screenshot. here’s article can steps: install office updates additionally, please provide screenshot of office 2016  product information . screenshot, open word or excel 2016 on system, click  file > account , capture screenshot of information mentioned under  product information .   thanks, neha Office / Excel / Windows 10 / Office 365 for business

using excel's conditional formatting (or other function), can add text cell based on value of cell (or cell)?   i have spreadsheet column d have single space in if cell empty (i.e., every cell in column d populated no cells left blank).  simplest solution seem should type in space each cell empty since need first 100 rows populated (and wouldn't take long); however, moment insert new row (which often; deleting , inserting new rows), new row not have column d populated text.  want column d automatically populated space, new rows added.   i tried using formula [=if($d1=""," ") , applying column d, not work.  thinking conditional formatting can used formatting (:p) , not text input.  so wondering if there way achieve this?   it may know why want this.  have list of ongoing files in first 50 rows.  completed, delete row.  if new file comes in, insert new row. column d identifies task must completed.  i've written c

i trying use match function identify highest cost vendor.   however, noticed wasn't giving me correct position.  reason noticed wrong because on first row can see cost being highest.  however, match function showed column three! here sample: cost a cost b cost c highest cost position of highest cost 39.7439 39.6774 38.871588 39.7439 3 56.154 52.61175 52.403932 56.154 3 77.8463 77.0098 69.518092 77.8463 3 85.4903 85.24075 81.493328 85.4903 3 53.4247 53.08745 47.01718 53.4247 3 73.9851 75.3013 62.805694 75.3013 2 108.976 97.95065 82.09887 108.976 3 48.4169 48.29025 44.980782 48.4169 3 61.0638 60.7556 50.93333 61.0638 3 this formula used: cost a cost b cost c highest cost position of highest cost 39.7439 39.6774 38.871588 39.7439 =match(d2,a2:c2) 56.154 52.61175

i trying create uniform order sheet , having trouble filtering.  the simple filtering easy want bit more advanced. there 2 sheets in workbook.  order , itemlist.  itemlist have 200 items broken down 12 main categories, sub-categories , forth.  the order sheet show 12 main categories, , user select sub-category , forth. please @ itemlist.  in textbox - shows below attachment. on order sheet [picture order or below], "coveralls" show "unisex coverall (s - xl)" , "unisex coverall (2xl - 4xl)" keeping example going - "order" sheet pull size based on category + item description.  the sku pull based on previous 3, , cost pull previous 4. ideally, looking getting going - if works, should able rest on own.  it's been while since have had coding or fancy filtering. note: windows other windows 7 pro (64-bit) office 2010 , 2013. thank you, ksj hi, in

hello, i'm working on project work, , wondering if knows how skip blank cells , consolidate text or numerical values list. i've attached image showing ideally columns b , c, if makes sense. thanks! use below formula , drag down - =iferror(index($a$2:$a$100,aggregate(15,6,(row($a$2:$a$100)-row($a$2)+1)/($a$2:$a$100<>""),row(1:1))),"") Office / Excel / Windows other / Office 2016

upon reopening excel file connection add-in link is no longer recognized. error message received, '(file link), not found. check spelling of file name, , verify file location correct.' upon subsequently trying run macro clicking established quick link receives, "cannot run macro (macro name). macro may not available in workbook or macros may disabled." accessing manage office add-ins screen shows add-in active correct file location. reestablishing link gets message "a file named '(shows correct file link)' exists in location. want replace it? clicking yes reestablishes link , works. but, saving, closing file , reopening gives same error messages again. **post moved / split moderator appropriate forum category / thread Office / Excel / Microsoft Office Programming /