Home / office-2010

office-2010

office-2010

Catching Excel 2010 Save event with Template using VBA

The situation: A template has been created for users to create a new Weekly working sheet, when opened it automatically adds certain information determined by the financial week. When saved or closed it needs to prompt a SaveAs dialog with a specific location and title. The problem: Well this is …

Read More »

Inbox doesn’t show up in OMB

So, I am an owner of an OMB but for some reason the Inbox doesn’t show up under it. My boss is the administrator and we tried trouble shooting but nothing. It took him like 2-3 days for it to actually show up for him so is it a waiting game or is there …

Read More »

Venn Diagram from Excel Data Source

I have an Excel Spreadsheet with the following Column A Is Account Name  (46 rows of names) Columns B through H Are Account Types Can Account can be more than one type.  denoted with an “X” in the cell of the correlating Account Type I want to produce a Venn …

Read More »

Gutter on outside edge of pages

I want a gutter margin on the outside edges of each page rather than the inside edge.  The only choices for gutter are "Left", which puts it on the inside edge.  Anyway to get the gutter on the outside edge?

Read More »

Is there a way to verify a Microsoft Product Key online?

I had an "Invalid Product Key" error while activating Microsoft Office 2010 online. After several attempts to find a solution, I ended up calling Microsoft Customer Support. I was treated well, but had difficulty understanding the representative and they had difficulty understanding me when I gave them my product key. …

Read More »

Printing problem with Excel2010

I have Excel2010 and yesterday it started to print only page 1 of a 3 page spreadsheet.  Although it says there are three pages to print before hitting the print button, it only prints the first page.  Later, it printed all three pages.  Today, it’s back to first page only.  …

Read More »

Last Value by Date in Range of Dates

I have a series of dates and each date has a matching balance.  Because the dates correspond to transactions the true balance for any one date is the value for the last date in the group of dates.  Using the example the value I need for 1/1/16 is $102,042; for …

Read More »

OneNote sync error

Error code: 0x80070193 “The process is not in background processing mode.” I used a help sheet that asked me to hit the link and get online and see if I can view the Notebook online, I can use it online just fine. I even clicked the “edit in OneNote” button …

Read More »

.wma file problem

I have put together a PP presentation on my desktop usinng PP10. The PP contains video and music wma files. I copied the PP to disc to play on my laptop and assumed all files would be included. The laptop plays the video files and while the icon for the …

Read More »

Column Filter

I have Excel2010 running on a 64 bit Win7 3.4GHz 128 GB SSD, 1TB HD, 8GB RAM. I have multiple Excel files with multiple sheets that have from 1k to 25k records in a sheet. When I first open a WB and select the Filter Column at top of column, …

Read More »

Outlook Updating folder

We use Outlook as our email client. It seems that Outlook updates my folder (i.e. Trash, Deleted Items, any folders I created) during regular business hours. It bogs down my work because I use email exclusively. Is there anyway to schedule the updating of the folders to a non-business time?

Read More »

Outlook 2010 Calendars

Hi Guys, I wonder if you can help me, At work we share our calendars with everybody else in our department. The bosses have decided to create project teams do do certain tasks at certain times in the working week. Putting each project teams calendars into groups is easy but …

Read More »

VBA Code to change a calculated field’s decimal places?

Hello all, In my workbook I have two tabs: the first displays a pivot table, the second displays the pivot table’s chart. I’ve created some VBA macros that are assigned to buttons to switch between different calculated fields like this: Sub IncidentRate() Application.ScreenUpdating = False Worksheets(“Sheet1”).Activate Set pt = ActiveSheet.PivotTables(“PivotTable4”) …

Read More »

Date validation in VBA

Hello All, I have a userform where the user will enter a date into 3 text boxes, one each for Month, Day & Year.  Then I will use the values of the text boxes to create a date.  I would like to validate that what they entered actually corresponds to …

Read More »

Mac/PC Word doc compatibility

I’m working on Word for Mac 2011. When I send documents to a colleague who’s working on a PC he says he has to click a yellow button or box at the top of the screen that says "Click to edit" or some such. Can this be avoided and how?

Read More »

Countifs before current week and after current week

Hello, I can currently count anything that occurs in the current week using the below formula, however I can only count anything before or after today to determine if SLA was missed. How would I modify the formula to begin counting anything before or after current week? Current week formula …

Read More »

VBA application.ontime method question

Hello, I am trying to use the application.ontime method to possibly run a macro at a certain amount of seconds after another macro was run. The reason for this is that I have a macro that goes to a website to download information as an excel file. Then the workbook …

Read More »

Windows 10 downgrade problems

I used the media creation tool to reinstall Windows 8.1 when Windows 10 caused problems with my Dell One 27. I accepted the option to retain my personal files. Micorsoft outlook has always been my email program, and that seemed to have migrated satisfactorily to the Windows 10 environment. However, on …

Read More »

Using 1 Macro on Multiple Files

Hi,  I’m trying to copy and paste macros from 100s of files to 1 master file in excel. I’m using macros to do this however I have to open or download a file from an server and each file has a different name. I’m encoutering trouble using the macro I …

Read More »

Outlook for Windows 10

I use Outlook on a Windows 10 OS. If I receive an email that contains an embedded email address and left click on the address in order to send an email to that address, the Windows email program in Win 10 opens up and a new email with the clicked …

Read More »

Access – Calculations in Reports

How can I calculate weighted averages in a Report? Example: Sector               Price             Weight Autos                  99                  2.0 Chemicals            88                  3.5 Retail                   75                   2.5 I would like to display at the bottom of the report, the weighted average price. Also, the data includes n decimals in the report….how can I round off to 1 decimal? …

Read More »

Office 2010 download gets stuck on Validating

Hi, In trying to download Office 2010, it validates my Product Key ok, but once I’ve selected my language it just stays in “Validating your request…” mode. I’ve tried doing this in clean boot mode (as suggested in another post) but same result. Help please! Thanks Stu

Read More »

COMPARING

Dear All, I need to compare products by clients sales in 2015 and 2016. That means i have customer  – Article name – amount(2015) I need to add amount(2016) next to it, also some article names are new in 2016 so they are not showed in 2015 so i can …

Read More »

Minimal numbering macro

Would anyone be able to guide me towards a macro for a standard Word 2013 document which would change 127-146 to 127-46; 100-198 to 100-98; 461-69 to 461-9, 25-29 to 25-9 etc.? In other words, it retains the relevant digit or digits to abbreviate numbers without losing any important information. In word …

Read More »

Update a table with a control source set with a Lookup function

Dear all, I have a Table “Nominalledgertbl” and another table “Codes”. i have form “NominalLedgerF” designed to update all the fields in the “NominalLedgerTbl” all the fields update correctly except for one textbook with “control Source” set with a lookup function =DLookUp(“Narration”,”CodesTbl”,”Code=” & [NominalCodeCmb]). 

Read More »

Always show "Not Responding" during Saving

I am using Excel 2010 in the following conditions – Using Marcro – Using ActiveX image object – The excel file size is at least 70 mb Problems – When I try to save it as either xlsm or xlsx, it will shows “not responding” – But, when I save …

Read More »

how to delete message that won’t download

There is apparently a huge incoming message (14 MB) that causes errors and won’t download.  Is there a way I can tell Outlook to delete it instead of trying to download it? Windows 10 Home, 64 bit. Microsoft Office 2010 bellsouth.net (at&t) Thank you.

Read More »

I cant get into onenote on new computer

I recently purchased a small laptop.  it has onenote 2013 on it.  I use onenote 2010 on my desktop computer. When I try to add my previous account to my onenote on the laptop, (which is linked to my hotmail account) it doesn’t recognize the account.  I’ve got a lot …

Read More »

Question on a query

I have a form that runs a parameter query using (4) combobox’s. If you select an option in combobox1 it filters what is in combobox4. One of the selections in combobox1 makes combobox2 available. I was trying to use an IIF statement in a query to filter what combobox4 options …

Read More »

Outlook inbox

Everything in my inbox just disappeared.  All the folders in my inbox were left untouched.  The emails disappeared from my desktop, mobile phone access and from my providers site. In the past I have been able to delete an email from anyone of these locations without it affecting the other. …

Read More »