Computer Support Forum

Excel 2010 side bars

Question: Excel 2010 side bars

My HP pavilion have window 7, Excel; 2010 opens up with side bars too dark. It is difficult to see scowling bar clearly. Any suggestions please?

More replies
Relevance 100%
Preferred Solution: Excel 2010 side bars

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link (This link will automatically start a download of Reimage that you can save to your computer.)

Relevance 82.41%

How can I open 2 excel files side by side in Office 2010?

Answer:How to open 2 excel files side by side in Office 2010?

See if this helps: Comparing Two Excel 2010 Worksheets Side by Side - For Dummies

1 more replies
Relevance 79.95%

Working on a client's computer running Win 7 Home Premium and Office 2010. When opening Excel it crashes stating there is an "side by side" error, event ID 59.
here's the dialog box: "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL,EXE The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log or use the command-line sxstrace.exe tool for more detail"
Following is from the event log:
Activation content generation failed for "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE.Manifest" on line 0. Invalid Xml syntax.
Also PowerPoint opens OK but when trying to open a file it says that there is a problem with the content of the file. Attempts to repair don't work. The file opens on other systems so it is not the file.
I've tried uninstalling and reinstalling the C++ packages with no help. Any help would be appreciated.

Answer:"side by side" error in Excel 2010

Right-click "Microsoft Office 2010" in "Uninstall or change a program" and select "Change". Select "Repair", click the "Continue" button and follow the onscreen instructions.

6 more replies
Relevance 64.78%

all instructions can be found here at


More replies
Relevance 64.37%

Hello Richard,

I've run a scan and the result appears encouraging:

"Windows Resource Protection" did not find any integrity violations."

Attached is a copy of the results: sfcdetailsFrancaBB.txt

I'm moving on to the sxstrace ... according to Lorien's directions.


Answer:Side-by-side configuration error after Quicken 2010 upgrade

Hello George!

Well done on creating a new thread. Thanks for that!

Well, nothing wrong in the SFC log. That has got to be good - as long as we get a lead from one of the other logs!

Thanks for continuing on. I am afraid that I can do nothing until I get those other logs, as that SFC logs showed nothing wrong.

Again, thank you, and the very best of luck!


8 more replies
Relevance 64.37%

Suddenly out of the blue nothing opens - Am not a programmer and don't understand all this lingo have 4 0r 5 redistributible programs C++ 2005, 2008 etc with all relevant service packs - NO LUCK - this is killing me am looking for work and can't get to my resume can't open any programs at all - adobe, microsoft office NOTHING please tell me how to restore my system files to default and start over

More replies
Relevance 63.55%

Good Morning,
I have three identical machines all running Vista Home Premium with Service Pack 2. All three have Office Home and Student 2010 installed. On one machine I have to keep uninstalling and reinstalling Office because I get the side by side configuration error on a random and recurring basis. Is there a permanent fix for this? I have the free upgrade for Windows 7 Home Premium for all three machines but have not used them because I am generally happy with Vista. Would upgrading to Win7 possibly help?
Thanks in advance for any help.

More replies
Relevance 63.55%
Question: side bars & prizes

Hi, I am having trouble with side bars loading & notices that i have won some sort of a prize.
this causes the computer slow to load an application as these two seem to have to load first.
then after a while i get a message that comes up internet explorer has stopped working.
i have stopped POP UPS by clicking on internet options & stopping Popups. but this has not had any effects.
Any help would be appreciated. Thanks

Answer:side bars & prizes

Sounds like a infection to me. I would recommend going to our Security Thread on this Forum.

2 more replies
Relevance 63.14%

IE 11 Annoying side bars/popups. I am getting these on every site I go to now and I actually hate the internet now. I tried Firefox and it's the same. Please tell me how to get rid off them altogether. Thank you in advance. Please see image at View image: Annoying popups in IE11!!!

Answer:IE 11 Annoying side bars/popups

Hi there ... Have a look at your Browser add ons Under Tools Manage Add ons .. Also look in program and features to see what is lurking there .. I would also Download AdwCleaner ...
AdwCleaner Download

6 more replies
Relevance 63.14%

Okay, this problem has been irritating me for quite some time now. My issue is this: I open a game called Ultima Online and click full screen with the highest resolution available. My result: a blown up play screen with two bars on each side of my screen about two inches thick cutting off my gameplay. I had this exact same issue with Call of Duty: Black Ops, and changing the resolution to 1080p quickly solved this. I also have a flickering problem with Ultima Online when I enter full screen, which many people have had issues with and few found solutions. A big thing with them is that they use Razor and that causes the flickering, but I do not use Razor... My question is, does anyone know how to fix this or have any suggestions I can try? My operating system is windows 7 64 bit, laptop toshiba qosmio x505-Q880, i7 processor, 18.4 inch HD display with a Nvidia GTS 360M graphics card, so my GPU is not the issue here. My uncle plays Ultima Online as well with the same operating system on a desktop with a 22 inch widescreen 1080p monitor and has no issues at all. the game looks great and works fine. He does use an AMD graphics card, so if there are any Nvidia Control Panel options I could change that would be an easy fix.

Things I have tried:
Reinstalling the game with a fresh download of the client
updating graphics driver (it's up to date)
playing with some of the graphics options in the Nvidia Control Panel, but alot of them I don't know what the do
tried turning ... Read more

Answer:Black bars on either side of screen

no responses?

8 more replies
Relevance 63.14%

I've recently re-installed Vista on a friends laptop. Now it has wide black bars on both sides of the screen. How can I resolve this please.

Thank you for any help.

Answer:Black bars at side of screen

6 more replies
Relevance 63.14%

I am running Compaq Presario CQ61 using AMD M880G with ati Mobility Radeon HD 4200.

I am trying to run certain games on full screen and I get these two black bars on the side of the screens. One emulator I used was "Project 64" and I set some options to make it exactly full screen and it worked.

But as for most PC games like Sims won't really work. Is there something wrong with my graphics card?

Answer:Black bars on side screens

it's probably the games' settings.
Some games only run in full screen 4:3 mode.

5 more replies
Relevance 63.14%

Whenever I watch video , wether its through video players such as wmp winamp vlc or through web browsers , ie youtube ect I get black bars eitherside of the video even when I veiw on full screen.I have an xfx nvideo 7800 GTX using Vista home premium with the latest drivers.Any suggestions on how I can view video without the black bars either side ?

Answer:Black bars either side of video.

VLC media player for Windows click hereWhen the Video is playing, Right click mouse in viewing area, Select Video, Aspect Ratio, 16:10 does it for me (Wide Screen Monitor).

2 more replies
Relevance 62.32%

Having searched Google for a week now, I've yet to find a satisfactory solution to this, what appears to be a common problem. I have the Satellite L500-11V, with Windows 7 installed, all latest drivers from Toshiba website, and the BIOS update to 2.10. The notebook has been working fine, and then all of a sudden this week the display appears to have shifted over to the left and down. I now have a black band across the top and right side of the screen!

Also I've noticed the maximum resolution is 1280 x 800, I've had to set it to 1280 x 720 so I can see the task bar at the bottom of the screen.

Have Toshiba or Intel (as I have the Intel Mobile 4500 Chipset) ever solved this problem...

Would appreciate some answers to this annoying problem.

Many thanks

Answer:Satellite L500 -11V - Black Bars top and right side

Native resolution for this 15,6? display is 1366 x 768.
Can you choose this resolution in display settings?

It is not easy to understand what is wrong there but as first step try please to install Intel display driver again.

9 more replies
Relevance 62.32%

Can somebody PLEASE tell me how the hell to get rid of them? I've already tried stretching the screen horizontally but the desktop icons go inside the black bars and the black bars still stay there

Answer:Those black bars on left and right side of your screen!

By using the monitor adjustments. If it's a 14 or 15" older monitor you are probably stuck with it.

1 more replies
Relevance 62.32%

What has happened to PC advisor forum? Why all the moving bars? Driving me nuts. Can I switch them off?sanap

Answer:Why all the floating side bars in PC ADVISOR -real

click here

1 more replies
Relevance 62.32%

Like I mentioned before in my last post I acquired another Tower, but Im using an old RELISYS 16' monitor with this system, ok anyway, I was wondering why I have black bars on both sides of the monitor the picture is not filling the whole screen I have looked behind the monitor for an adjustment and in front of it also, and cannot find an adjustment for it, and i have removed the monitor from the device manager and rebooted and let windows install the best one, do I need to search from Drivers for this?, the Resolution is set at 640x480 and I'm not sure what the Refresh rate is set at, could this be a problem also.thanks for the help.

ICQ# 51865388
AOL IM daveandrew v1


Answer:Monitor Problem....Black bars on each side

7 more replies
Relevance 62.32%

Hi, I switched on my laptop after 2 days and I found a black bar on the right side of my screen and another black bar on the bottom of the screen. The bar on the bottom is even strange. Its kinda blurred and the windows icon is also blurred near bottom. When I placed my mouse pointer in that bar its just gets elongated in the entire bar. I had this problem once earlier but then I just restored my system and it was OK. Now even system restore did not work. Please help (Kindly give an elaborate answer)Thanks

Answer:black bars on side and bottom of screen

try uninstalling the last video driver, or updating with a new video driver..and earlier retore point also may help..i hate computers!but cant help myself....

2 more replies
Relevance 61.5%

In build 14271 rs-1 scroll bars have been added so the icons can be shifted left or right. I have icons that I want to be visible at all time so I select that no icons be hidden. Even with this selection to see all icons, I still get the scroll bars and I do not like that at all. How can I get rid of them? There seems to be no way.

More replies
Relevance 61.5%

I received a .pps file of old planes. I wanted to extract a picture file and use it as my wallpaper. My problem is that the slides of the old planes are all centered with Black bars on both sides. When I copy or extract that particular picture file to convert to a .jpg file, it has the side bars on it. When I set it for my wallpaper, it has the Black side bars. I've tried my Nero Essential program to modify the picture, but I can't find anything that works. So, my question is, How to I get rid of the side Black side bars to make a full screen picture that can be used as wallpaper for my monitor? Monitor is a 23" Samsung LCD (1920x1080) I even tried the Print Screen method and that did not work. Any help would be appreciated. ThanksOS: Windows 7 64bit/Ubuntu 12.04 LTS 64bitCPU/Ram: E8500/8GB PC2-6400Manufacturer/Model: AVA Direct / Built onlinemessage edited by gilloz

Answer:Delete Black side bars from PowerPoint file

I tried other methods found on the Internet and they basically did not do the job eitherIf you try using XnView, which is freeware, you load the picture, then set your crop lines on the picture,then use the ZOOM tool to Zoom in as far as the program will let you,usually about 1600 %, to the point you can see individual pixels, the crop lines remain visible so you can get a really close crop.You then save the Cropped pic with a new name so you don't lose the original.I've done it a number of times.MIKE

7 more replies
Relevance 61.5%

ive had my comp for about 2 years now (with the same monitor) and recently i noticed my screen.. shrink.. lol... i just went to my monitors settings and streched it out.. no problem.. maybe 2 days later.. it shrank again.. this time leaving 2 black bars on the left and right side of my screen as what its receiving (i can make it so i can shrink what windows is displaying and i can still see to lighter black bars to the left and right side then what is completely black from what the monitor is blanking out) so i figure its a video card problem (radeon 9200 pci), my windows xp is messing up, or my monitors messed up.. help

Answer:black bars on left and right hand side of monitor

6 more replies
Relevance 61.5%

G'day everyone - I suspect this issue will be a tough one to get help with!

I've attached a screen-capture of a Microsoft Office Excel 2007 spreadsheet I'm working on at the moment. As you will be able to see on the screen-capture, I've marked the areas of interest and will explain here...

When I enter a name in this column (marked as '1'), I want the spreadsheet to check another column (marked as '2') to see if there is a match. If there is a match, I then want the spreadsheet to check the column marked as '3', and subtract that amount from the column marked as '4'. If there is no match between the column marked as '1' and the column marked as '2', I don't want anything to happen.

I hope that made sense, and if anyone can help me with a solution here, I would greatly appreciate it.

Answer:Solved: Calculating Side-By-Side Cells Dependant On Text Entries In Excel

8 more replies
Relevance 61.09%

Hello and thank you in advance for your help, I am in desperate need!

To be honest, I'm not entirely sure when this problem started as I haven't been on much the last week or so, but I've tried all the trouble shooting I could find but still cannot manage to fix this problem.

When I try to open Word or Excel I get an error message:
"The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log or use the command-line sxstrace.exe tool for more detail."

Not totally sure what that means, but I have ran an administrative command prompt of sfc/scannow, and all my bad files are fixed (at least that's what it tells me when I try to run it again)

I also read tips where it tells you to go to the Event Viewer to get more details on the side-by-side problem. Well this seems to be having a problem, too. I get an error message saying:
"MMC could not create the snap-in. The snap-in might not have been installed correctly.
Name: Event Viewer
CLSID: FX:{b05566ad-fe9c-4363-be05-714cbb7cb510}"

I did just get rid of the Scour redirect virus, and I'm 99% sure this was happening while I had that; not sure if it's related, but when I scan (and am doing another just to check) I come up clean.

Thanks again for your help!

Answer:Side-by-side configuration incorrect when trying to open excel & word

Well...have you tried uninstalling the MS Office suite...and then reinstalling?

It could have become damaged. Uninstalling/reinstalling, then updating it would take care of that possibiliity.


1 more replies
Relevance 61.09%

I have these vertical black bars on both sides of the LCD (like a 4:3 image on a wide screen laptop) and the resolution is low, once I log back in the screen returns to normal.  Anyone seen this

More replies
Relevance 61.09%

As the title I just can't seem to get rid of them and they move from side to side ever so slightly. I don't have the problem on my Windows 7 machine. I've a AMD R7 video card if that is any help.

More replies
Relevance 61.09%

Hi everyone.

More and more these days we see a vertical bar at the left side of web pages with social media links. I believe they are called CSS Social Media Sidebars. They usually cover up what your trying to read. They really annoy me and I was wondering if there is a way to automatically stop them loading with webpages.

I know that you can use Ad Block Plus to remove some but that doesn't always work and it's not automatic.

Any ideas?

Many thanks in advance.


More replies
Relevance 61.09%

As the title I just can't seem to get rid of them and they move from side to side ever so slightly. I don't have the problem on Windows 7 on the same machine as it's a dual boot. I've a AMD R7 video card if that is any help.

Answer:Videos have black bars in windows 10 on Flash and Netflix On side of.

200motels said:

As the title I just can't seem to get rid of them and they move from side to side ever so slightly. I don't have the problem on Windows 7 on the same machine as it's a dual boot. I've a AMD R7 video card if that is any help.

The above screenshot is from Flash player in Chrome in Windows 10, the screenshot below is from Windows 7 but no black bars on the side. So when you enlarge it the black bars stay on in Windows 10. Anyone come across this as it's wrecking my head.

4 more replies
Relevance 61.09%

I have a mac that runs vmware for windows. i was running windows 8.1, I upgraded to windows 10 and now have black bars on the side of monitor. I know longer have use of the whole screen. What should I do?

Answer:I have a Mac that runs vmware, I upgraded to Windows 10 and now have black bars on the side?

Originally Posted by Windows Central Question I have a mac that runs vmware for windows. i was running windows 8.1, I upgraded to windows 10 and now have black bars on the side of monitor. I know longer have use of the whole screen. What should I do? check your resolution settings for the screen in windows 10
If you need additional help or have more questions or details to share, please join the site so you can reply in this thread. See this link for instructions on how to join Windows Central.

2 more replies
Relevance 58.22%

Hi Lorien

I just joined the Forum in hopes I can find some solution to my "side by side configuration" problem in Office 2010. I saw your earlier posts and tried to no avail. Lots of time ahead this weekend hoping to find a fix - perhaps I should be redirected to a different forum?

Peter in Michigan

Answer:"side by side configuration" problem in Office 2010

Hello, and welcome to the Vista Forums!

Please have a read through this older thread by me. side by side configuration

Try Lorien's advice, then mine, for the first two answers. If that does not solve the issue, keep going with my advice, and post an SFC log (sfcdetails.txt), and the sxstrace.txt.

Also, could you give us just a few more details. I assume that the error message is "The side for side configuration is incorrect. Reinstalling the application may fix the issue" Can you please confirm that, and that it occurs for Microsoft Office only, as far as you are aware.



6 more replies
Relevance 57.4%

I am using Office XP,with Windows7, but if I have two Excel progams open, they are on top of each other. When I close one, they both close!
How do I get them to sit side by side?

Answer:Excel windows, side by side.

Here you go. 2 Excel.

10 more replies
Relevance 56.58%

I've found a number of suggestions on how to create a scroll bar in a PPT slide but the only suggestion that seems to work doesn't. The one that "seems" to work is to add the Developer ribbon to PPT which I did. I followed that, and actually was able to create the scroll bar, but when I went to slide show, it didn't work.

Answer:Creating scroll bars in powerpoint 2010 slide

Hello! Welcome to Seven Forums.

Anything here to help?
Using Activex Controls in PowerPoint

3 more replies
Relevance 55.76%

I have been getting the following errors in Excel 2010 for about 3 months and they are getting more frequent (I have Win 7 Pro):

(1) Errors were detected while saving 'C:\Users\username\Documents\filename.xlsx'.
Microsoft Excel may be able to save the file by removing or repairing some
features. To make the repairs in a new file, click Continue. To cancel saving the
file, click Cancel.
(2) Cannot open the Clipboard.
(3) An unexpected error has occurred. AutoRecover has been disabled for this session of Excel.
(4) Excel has stopped working.
(5) Freezes on print preview.

I have done the following:
- Tried Excel in safe mode.
- Uninstalled and Reinstalled Office 2010.
- Disabled all add-ins.
- Done an exhaustive search on the internet only to find that other people have one or more of these errors, but no solutions.
- Other Office 2010 apps work ok.

Nothing has worked. Iím barely able to get anything done! Please help, Iím dying here!

Answer:Excel 2010 ProblemsI have been getting the following errors in Excel 2010 for about 3

16 more replies
Relevance 55.76%

My operating system is WINDOWS HOME PREMIUM, I am using APACHE OPEN OFFICE 3.4.
The probmlem that I have is that the SYMBOLS and TEXT on the TITLE BAR, the MENU BAR and the TOOL BAR are so small that I find it a bit difficult to read them easily. In Windows XP I know how to enlarge them but I find that that method does not work. Can any one help me Please???. Weejohn.

Answer:Title Bars, Menu Bars and Tool Bars

click here

3 more replies
Relevance 54.12%

Hi friends!

Is there any way to decrease the gap between bars (NOT the width of the bars) of excel bar chart?
I made a bar chart with 23 dates (weeks like 10/5/2007, 10/12/2007, 10/19/2007 etc.). The row were very thin and the gap between the rows is long. Can we decrease the gap between the bars to make it look good?

Thanks in advance!

More replies
Relevance 54.12%

Hello everyone,Normally Excel gives the variety of charts (apple pie, bars, radar etc.) but in the chart all the series are displayed in the preselected mode.I'd like to know if it is possible to have mixed types of charts in one and namely:if I have e.g. two series, one of them is to show the real monthly results in the period from January to June and it should be shown by bars whereas the second series is to show the target objectives, which should be shown by a red line.Is it possible to do this in Excel?Thanks a lot for your suggestions!Zennon

Answer:Excel chart with bars and lines

2 things:1 - You didn't say what version of Excel you are using.2 - I'm not a charting expert, so while these steps will work, there may be a more streamlined method.In 2003:1 - Create a Bar Chart showing both series2 - Right Click one of the Bars for the second series and choose Chart Type3 - Select the Type for that series4 - Click OK

4 more replies
Relevance 53.71%

Cannot find in 2007 how to do this anymore.Create 100% bar chart with multiple cities.e.g.Have a multiple countries and the top 3 cities in Canada they move toSuch as (not real, but the idea):German to Toronto, Ottawa and Vancouver.China to Toronto, Quebec and VictoriaRussia to Vancouver, Toronto and Edmonton.That kind of thing. Should see the bars and inside the colour represents the different cities and the label is inside the colour.Can make individual charts, but not one whole one.What am I doing wrong?D

Answer:excel 2007 mutliple bars in 100% bar chart

click hereclick here

3 more replies
Relevance 53.71%


When I view an Excel worksheet, both my horizontal and vertical toolbars do not appear.

I have tried:

Office button (Top Left)>Excel Options>Advanced>Display Options for this workbook, and both horizontal & vertical scrollbars are already checked.

Yet I still can't see the scrollbars in my document on the 'Normal' view. They appear when I go to 'full screen mode' under 'View', but then I can't see any of my toolbars, which is no good.

Any suggestions how to make the scrollbars re-appear under 'Normal' view?


Answer:missing scrool bars in excel 2007

Hi amisir, welcome to TSG.

Can you see the worksheet tabs at the bottom of the screen? If not, it may be that your spreadsheet is not maximized.

1 more replies
Relevance 53.71%

How do I restore the horizontal and vertical scroll bars in Excel 2007? Also, the sheet tabs are missing

Answer:Missing scroll bars in Excel 2007

are you in full screen view - as they are normall off - otherwise
In tools - options - view, both the horizontal & vertical scroll bars are ticked.

2 more replies
Relevance 53.71%

i am using excel 2007, when i open excel there are no menu or tool bars along the top of the screen, but when i minimize it and then maximize, the full menu's tool bars reappear, i have obviously altered something in the excel options setup, but what? how can i get it to open normally

many thanks

Answer:Solved: excel menu/tool bars

Excel is opening in 'Full Screen' mode, if you press the 'Esc' key on your keyboard this will bring the toolbars back.

'Full Screen' mode can be found on the 'View' tab within 'Workbook Views'.

Unfortunately I haven't found what would cause Excel to always open in this mode...

1 more replies
Relevance 53.71%

Hi, i have created a dropdown menu with the months of the year in. I also want to make a drop down bar for the years upto the year 2099 possibly. I want to be able to select a month then a year then press the macro button which would then go to another page that is the month and year that i have selected.

e.g. I select June then 2004 i then press the button and this would then go to a page created for June 2004. i know this would create alot of pages but i just want to know the basic persedure

i have included an example of the excel worksheet!


please get back soon if anyone can help!!!

Answer:Producing macro/dropdown bars on Excel

Assuming that the Year is in cell A2 and the Month is in cell B2, and you have a sheet with the tab name 2004June (notice, no spaces), then try this:

Sheets(Range("A2").Value & Range("B2").Value).Activate

Modify for actual cell ranges.

If the naming syntax of your sheet tabs is 2004 June (with a space in between the year and month), then use:

Sheets(Range("A2").Value & " " & Range("B2").Value).Activate

1 more replies
Relevance 53.71%

I'm running Windows 7 Professional and just upgraded IE from 9 to 11. Afterwards, I observed that Outlook 2010 was not downloading pictures (instead showing red x's) and Excel 2010 embedded internet queries stopped working. 
I think I've cornered the problem, but can't seem to fix. I have also observed that IE's temporary internet files (TIF) folder may be missing (Internet Options>Browsing History>Settings>Temporary Internet Files shows nothing under Current Location)
and the allotted disk space is set to zero and cannot be changed. If I input another number (no matter the number), I receive the following error message:
"Please select a value between 8 and 8 for how much disk space Temporary Internet Files may use."
I have tried renaming the following RegEdit keys, but to no avail: Cache and LowCache (both under HKEY_CURRENT_USER>Software>Microsoft>Windows>Internet Settings>5.0). They get replaced when IE11 is re-opened.
The actual values within the registry keys are as follows:
Cache>Content>CacheLimit = 8192 (Decimal)
LowCache>Content>CacheLimit = 256000 (Decimal)
This is driving me crazy. Any help would be greatly appreciated. 

More replies
Relevance 53.71%

I'm running Windows 7 Professional and just upgraded IE from 9 to 11. Afterwards, I observed that Outlook 2010 was not downloading pictures (instead showing red x's) and Excel 2010 embedded internet queries stopped working. 
I think I've cornered the problem, but can't seem to fix. I have also observed that IE's temporary internet files (TIF) folder may be missing (Internet Options>Browsing History>Settings>Temporary Internet Files shows nothing under Current Location)
and the allotted disk space is set to zero and cannot be changed. If I input another number (no matter the number), I receive the following error message:
"Please select a value between 8 and 8 for how much disk space Temporary Internet Files may use."
I have tried renaming the following RegEdit keys, but to no avail: Cache and LowCache (both under HKEY_CURRENT_USER>Software>Microsoft>Windows>Internet Settings>5.0). They get replaced when IE11 is re-opened.
The actual values within the registry keys are as follows:
Cache>Content>CacheLimit = 8192 (Decimal)
LowCache>Content>CacheLimit = 256000 (Decimal)
This is driving me crazy. Any help would be greatly appreciated. 

More replies
Relevance 52.89%

Hi there. In Excel, I have 5 series of data, I want to chart them as 4 bars and the fith series showing as a line, can it be done? I am using the "Line Column" chart type but it is making the last 2 series into lines. I would like 4 bars (to show phone calls) and 1 line (to show texts) running over the top. Can this be done? Thanks so much.

Answer:Excel chart - 5data series - 4 bars/1 line??

Welcome to the Forum!
I am not too clear what you are trying to do. Could you either post some (fake) data or, preferably, a file showing what you are trying to do?

3 more replies
Relevance 52.89%

Every day I send out excel documents that I then convert to pdf's. I use the same excel template on each document. The only thing that changes in each document per recipient is the "name" "company" & "email" fields in the excel document.

Question: Is there a way I can get these documents to interface with outlook so that when I select more than one person to receive the document (as many as 30 people will receive the same document), and auto populate the contact info "name" "company" "email."

This way would save me a few steps so that I don't have to pick a contact... type all their info in the fields... send. Select my next contact... enter appropriate info in the fields... and repeat and repeat.

I'm emailing job specific information to everyone working on the same job. I'm sending it to multiple people, but need it to look like they were the only one who received the document. Just like when you get an email about the "deal of the week" that says, "Dear Mr. Johnson, How's your summer going?.... " while someone in NYC gets the same letter that says "Dear Mr. Thompson, How's your summer going.... " from the same sender. Of course the deal of the week changes each week.

How can I make this happen? If there is a better way outside using excel to create pdfs, or a totally different method entirely. I'm all ears. I just need to send the informatio... Read more

More replies
Relevance 52.07%

Help! I am trying to copy and paste a chart from Excel into a Word doc. It doesn't matter what Paste-Special option I choose, it pastes a box for the chart but only the bottom quarter inch of the chart appears in the box. The rest of the box is blank. If I click on the box and drag it, I can see a ghosted image of the contents of the chart but I can't get it to really appear. It also only prints the bottom quarter inch of the chart. I've tried and tried and tried, every option I can think of.

Answer:Word 2010/Excel 2010 STUMPED

I figured it out...but what a stupid solution. I had to change it's "Position" to anything but the default.

1 more replies
Relevance 52.07%

I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In other words, I want to keep all my other Office applications (Outlook, Word, etc running as 64 bit versions but in the future run Excel in only the 32 bit version.

I'll appreciate your help with this very much!
/ Gary E.

Answer:How to go back from Excel 2010 64 bit to Excel 2010 32 bit

What exactly are the options shown when you run setup? Do you have an option for completely uninstalling Excel?

As I recall, MS recommends the 32 bit install and I think it is the default. Did you have some specific reason to choose 64-bit?

Have you seen this:

How to Downgrade Office 2010 from 64-bit to 32-bit ? My Digital Life

6 more replies
Relevance 51.66%

I am running Microsoft Office Professional Plus 2010 on Windows 7.

When I open Excel my personal.xlsb opens fine and my macros are available and I can create new macros. No problems.

BUT when I open any existing Excel file the pesronal.xlsb is not opened and therefore no macros and I cannot create new macros as I get the error "Personal Macro Workbook in the startup folder must stay open for recording." I have been trying things all night with no luck. Any suggestions would be greatly appreciated. I will list the things I have tried or checked with no success below:
In Options>Advanced Tab>General Section....the box for "Ignore other applications that use DDE" is NOT checked.
In Options>Trust Center>Trust Center Settings>Trusted Locations... I have C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART listed which is where my personal.xlsb is located
In Options>Trust Center>Trust Center Settings>Macro Settings ...Disable all macros with notification...selected and not selected neither way solves the issue.
In Options>Add-Ins>Manage: Disabled Items ...There are no disabled items.
I have deleted HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel in the registry editor
I have deleted C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB and then run excel to create a new personal file.
I have renamed C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB to PERSONAL.XLSA

Thank you in advance fo... Read more

Answer:PERSONAL.XLSB does not open when existing excel files are opened in Excel 2010

6 more replies
Relevance 51.66%

I've searched for issues regarding non-working VBA code written for Excel 2010 and compatibility wit Excel 2011 for MAC.
I am currently using Addin (*.xlam) files that hold all the necessary code to process multiple files without needing to use the PERSONAL.XLSB and as eliminating the need to copy VBA code to every file that requires.
This works perfectly with all the Windows Office versions.
Today a colleague want's to run this same file on a MAC book with Office 2011.
The moment he opens the Addin het gets an error that a library cannot be found, understandable, but the Tools Reference in the VBA project is also greyed out so I cannot even try setting any reference.
Does anyone have any experience with this or is this something that needs a complete new approach when it regards Office on the MAC?

I hope somebody can help

Answer:Solved: Excel 2010 xlam file not working with Excel 2011 for MAC

6 more replies
Relevance 51.66%

We recently migrated from Office 2003 to Office 2010.

Just to give some background, (and I dont' know if this is relevant to this error), the Office 2003 excel did not accurately show the correct file paths where files were linked. It would show something in the C drive.

The issue I am concerned about today is this: when some users close files in 2010 (files were created in they sometimes get the error below:

'"The name ABE2, either conflicts with a valid range reference or is invalid for Excel. This name has been replaced with _ABE2"

Can someone assist me with this? I need to stop it from appearing and I am not sure how.

Answer:Solved: Excel 2010 v Excel 2003 Error Valid Range

14 more replies
Relevance 51.66%

Hey Folks,

Been banging my head against this for a few days now, and can't figure out what the issue is, so hoping someone here can help me.

A quick background- building an application that has a SQL backend (2008 R2) to store transactional data, a MS Access 2010 DB that has linked tables to the SQL DB that has some other tables with some forms built as a sort of 'administrative console', and an Excel 2010 (.xslm) workbook that is accessed by end users. Based on some user input in the Excel workbook, a dynamic query is built with VBA, then passed to the Access DB.

The application works fine when users with Excel 2010 use it, however users with Excel 2007 seem to be having issues.

When they try to run the portion of the application that calls to the DB, the following error is kicked:

" Run-time error '3146' ODBC -- call failed. "

Upon stepping through the DB engine errors collection, this is the error being tripped:

" ODBC -- call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string. (#241) "
The code is below (stripped out some server/db names, and some irrelevant code that sits in between where the query is built & where it is actually executed):


Sub CalculateLineItems()

Dim lastrow As Long
Dim queryFilter As String
Dim BudgetName As String
Dim sliceLevel As String
Dim NoLineItems As Boolean
Dim AccessDB As Access.Applicat... Read more

More replies
Relevance 51.66%

Problem in Excel 2010 [but revives a Closed TSG thread for Excel 2007]

The "Personal Macro Workbook" is a file called Personal.XLSB
The Personal.XLSB file is in the correct location /XLSTART/
The file properties option "Opens with Excel" is selected.
The file contains a (freshly re-made) macro.
(It also contained the same steps macro before it was deleted
and re-recorded during troubleshooting for this problem.)

When Excel is opened, the Personal.XLSB DOES NOT OPEN WITH it.

Because the Personal Macro Workbook does not open,
- existing macros do not function,
- nor can new macros be recorded

Same not-opening result, whether opened by clicking on
- Excel, in the Programs list or
- a desktop shortcut to a specific Excel file

However, the Personal.XLSB file can be opened and the macro made functional
by manually opening that file where it is stored in /XLSTART/

An unexplained workaround was identified in the closed thread.

*rename the Personal.XLSB to Personal.XLSA

I find this workaround effective.
The Personal.XLSA file opens with Excel and the macros are available.
But the file seems to be grayed out when viewed with Explorer in /XLSTART/

However, I do not like using workarounds, as they can cause trouble later.
I find that the "open with" setting was changed when the extension was changed
The setting is now "Opens with: Windows Shell Common"

I would appreciate an explanation how to make Personal.XLSB open as it should.
... Read more

Answer:Solved: Personal.XLSB in Excel 2010 does not open on starting Excel

16 more replies
Relevance 51.25%

Whenever trying to save an excel 2010 spreadsheet, getting an error, "Microsoft Excel is waiting for another application to complete an OLE action." I ticked the box in the advanced options to ignore other applications that use DDE, but then I started getting a new error, "There is a problem sending the command to the program" and my file won't open.

I'm stuck in a loop and google is failing me.

please halp!

Answer:Excel 2010, Microsoft Excel is waiting for another application to complete an OLE act

Re: Excel 2010, Microsoft Excel is waiting for another application to complete an OLE

Can you open excel with a blank file? If so, then uncheck the DDE option. If not, try this fixit.

1 more replies
Relevance 51.25%

Hi guys,

Since a day or two I?m having the following issue when I close an excel file (extension xlam).

I write my own addin files and have been using them for many, many years.

I?ve read that this seems to be a bug with Excel 2010 but the strange thing is why now and not before?

The addin is not installed, I run it when I need it, it contains the necessary xlm code with custom ribbons and all the necessary buttons, you name it, it just works as it should.

I have one button that either close the addin or quits Excel altogether

The VBA project?s properties are set to non-visible and password protected.

Now I get the dialog prompt to enter the VBE password. If I enter the password or press cancel, all I get is that Excel has encountered a problem and will shutdown.

OS: Windows 10 64-bit, Office 2010 and everything has been running fine with Windows 01 and before that with Windows 7

VBA Editor window is not maximized (as I read on several posts), and when I remove the password and save it and then reopen the vbe editor does not show up anymore when closing.

If I run the same macro directly, not using the menu button, the same thing happens. It seems like it?s trying to access the VBA properties, but I have not added any code to do that.

Very strange and especially I do not like thing I do not understand, no changes made and I do not address the VBE components in any way.

Any ideas?
P.S. I cannot upload the file but the thing is that it just started, all at on... Read more

More replies
Relevance 51.25%

Most of my Excel files open fine with a doubleclick from Windows Explorer. I have two XLSX files however, that "try" to open when I single click. They open to a blank, grey screen - essentially they open Excel, but the file does not open. (I do see a quick flash of tabs at the bottom indicating the file is starting to open or opens and then terminates immediately).

The problem is clearly not a "tiled window" or "window offscreen" problem - there is no file open. All the Excel functions are greyed out. If I go to File-->Options, i just get a blank grey screen. If I go to file --> open, I can then open any file.

It seems that these two files have some kind of trigger property that starts Excel with one-click, but I can't find how to change that property. None of my other XLSX files act this way.

UPDATE: Further experimentation reveals that this problem is somehow linked to password protection. I copied all the tabs to a new sheet and saved as XLSX. This sheet works normally, i.e. I can click on it once to highlight it and it does not open Excel. I double click and it opens. But once I password protect it, the behaviour changes to that described above.

Answer:Excel 2010 - Excel Opens Blank on One Click of File

Do you have the "preview pane" on? if so, turn it off and you should be able to view the password protected documents properly.

1 more replies
Relevance 50.84%


Does anyone know how to change the password for a Excel 2010 spreadsheet?

We have one, we know the password, but need to change it as many people that shouldn't know it, does. But can't figure out how

We can't use Save As, as the spreadsheet is linked to other tables on the network. Just want to change the password that we already know, to a new one.

Looked here already, they just mention Save As:

We're used to Office 2003, so this is a big jump at work for us



Answer:How to change Excel 2010 password (when in the excel sheet)

We can't use Save As, as the spreadsheet is linked to other tables on the network.Click to expand...

Why not? You can save it with the exact-same filename, even with the Save As command. It's only from here you can choose the Tools drop-down, General Options, and then change the password from there.

1 more replies
Relevance 50.84%


I am trying to pull a dashboard view from a "Tracker". Given below is the formula that I used:

=COUNTIFS('KT Tracker'!$T$2:$T$138,$C$2,'Tracker'!$U$2:$U$138,"<="&TODAY()+7,'Tracker'!$L$2:$L$138,'Monthly Dashboard'!$B17,'Tracker'!$AF$2:$AF$138,'Monthly Dashboard'!$A$13,'Tracker'!$AD$2:$AD$138,"<>Cancelled")

This perfectly works fine in my laptop that has excel 2013 but when I email this to my team who have Excel 2010, they only see zeros. We have checked all options like enabling Automatic Calulcation of Formula, removing all named ranges in the sheet etc., but it is just not working.

Can you please help ? This is a bit urgent and I need to present this for a meeting tomorrow.
Appreciate your help and thanks in advance !!!

Answer:COUNTIFS working in Excel 2013 but not in Excel 2010

It might be something to do with "<>cancelled"

1 more replies
Relevance 50.84%

As part of updatting our computer equipment I was reassigned from a Dualcore Windows XP Sp2 with Office 2007 to a new Quadcore Windows XP Sp3 with Office 2010. Both with IE8.

The problem at hand is this particular Macro that is run monthly and creates 167 web querys, one at a time. This is why I made a macro. The webpage that I get my imformation from is, which has a login page.

What I used to do in Excel was to first manually create a web query in such page in order to enter my login credentials, confirm that I entered the page, close the query wizard, and then proceed to run my macro. It worked, and still works, flawlessly in my previous PC but not so much in my new one, as all I get from the macro are a bunch of worksheets saying that I'm not logged in so I can't retrieve any information.

I hope I've been explicit enough as how it doesn't work. I really need this to work because my old PC is going to be formatted and my only option would be to do this manually.

If you need more info please ask, I don't think I've been clear enough as English is my second language.

Answer:Excel 2010 web query is not working as it did in Excel 2007

Could ik be that the symantec site has attached your login to a specic Ip address or machine name which now is changed because of your new system?
I don't really think it;s Office 2010.
Your system is new, another mac address, probably a new IP address, new computername.

All these seeminly irrelevant factors may be the reason it's now working, have you tried executing your macro step by step? Trubleshooting takes a lot of patience and time.

I hope this gives you some ideas to look at

2 more replies
Relevance 50.84%

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: AMD A6-4400M APU with Radeon(tm) HD Graphics, AMD64 Family 21 Model 16 Stepping 1
Processor Count: 2
RAM: 7650 Mb
Graphics Card: AMD Radeon HD 7670M, -2048 Mb
Hard Drives: C: Total - 931724 MB, Free - 865841 MB; D: Total - 21840 MB, Free - 2343 MB;
Motherboard: Hewlett-Packard, 18A7
Antivirus: Norton Internet Security, Updated and Enabled

I am unable to open a password protected Excel 2010 file in Excel 2007.

When attempting to open this file nothing happens but on clicking the office button the New and Open options are available but all the other options are greyed out.

Using the open option has no effect on this file whatsoever.

I would be grateful for any suggestions.



Answer:Excel 2010 file will not open in excel 2007

Does is need to be saved in a different format. Wasn't there a change in the default around that time??

1 more replies
Relevance 50.84%

With due respect and credit to DerbyDad03 whose earlier post gave me the code below; is there any way to have the new worksheets created from a variable length field e.g. a persons name in a list or a field of fixed length other than a date as the script below uses?Sub CreateMonthlySheets()Dim lastRow, mMonth, tstDate1, tstDate2, shtName, nxtRowOn Error Resume Next'Turn off ScreenUpdatingApplication.ScreenUpdating = False'Make a copy of the data sheet and sort by date Sheets("Sheet1").Copy After:=Sheets(1) Sheets(2).Name = "SortTemp" With Sheets("SortTemp") lastRow = .Cells(Rows.Count, 1).End(xlUp).Row Rows("2:" & lastRow).Sort Key1:=Range("A2"), Order1:=xlAscending 'Using SortTemp Sheet, create monthly sheets by'testing Month and Year values in Column A'Loop through dates For Each mMonth In .Range("A2:A" & lastRow) tstDate1 = Month(mMonth) & Year(mMonth) tstDate2 = Month(mMonth.Offset(-1, 0)) & Year(mMonth.Offset(-1, 0)) 'If Month and Year are different than cell above, create new sheet If tstDate1 <> tstDate2 Then ActiveWorkbook.Sheets.Add After:=Worksheets(Worksheets.Count) 'Name the sheet based on the Month and Year ActiveSheet.Name = MonthName(Month(mMonth)) & " " & Year(mMonth)'Copy Column Widths and Header Row .Rows(1).Copy ActiveSheet.Rows(1).PasteSpecial Paste:=8 'ColumnWidth ActiveSheet.Rows(1).PasteSpecial 'Data... Read more

Answer:Excel Macro to create new worksheet in Excel 2010

I created a quick macro to help you out. This macro creates a new sheet and names it using the contents of cell "A1".Sub CreateNewSheet()
Dim NewSheet
Dim SheetName As String

SheetName = Worksheets("Sheet1").Cells(1, "A").Value
Set NewSheet = Sheets.Add(After:=Sheets(Worksheets.Count), Count:=1, Type:=xlWorksheet)
NewSheet.Name = SheetName

End Sub
Law if Logical Argument: Anything is possible if you don't know what you're talking about.

4 more replies
Relevance 50.84%
Question: Excel Side bar

I have a slight problem with using excel. Although i only have about 450 line of date in the spreadsheet, the slider bar along the right hand side of the chart has a very, very small slider. This is difficult to get hould of to 'mouse' up and down. how can i make the slider bar larger?


Answer:Excel Side bar

16 more replies
Relevance 50.43%

It's taken me two days to figure out how to post to a forum that may or may not be the proper place for my question. I apologize for my frustration.

I have what should be a simple problem with all of my installed HP
printers. The envelope feed is on the right side of the tray. That means
that single checks and two checks on a sheet must be fed into the right
side of the tray.

Quicken 2010 and QuickBooks Pro insist that my options for printing an
envelope or single checks or two checks on a sheet are: Left side or
Center feed. Never the right side.

Spoke to HP at length about this problem with my new HP 4500 Officejet
yesterday and they concluded that the problem was Intuit's and not theirs.

I am running a Windows 7 (64) computer and have installed several other Brother and HP Printers in hopes of finding one that will allow feeding of single checks and envelopes from the right side of the tray. If I could find one that works, I can give it the same port as my current HP Officejet 4500. I have done this in the past with success. Unfortunately all the printers I have tried have the same problem with Quicken and Quickbooks. It's almost as if the Intuit driver is stuck and not really being overwritten by new printer drivers. I am way out of my league here and have no other ideas for a cure.

More replies
Relevance 50.02%

Help! I would like to convert to computerized recordkeeping. The only software available to me is Office 2010 suite. I have created an Access 2010 budget database that includes purchases, vendors and users. I also have created an Excel 2010 spreadsheet with beginning budget amounts and purchases that works very much like a checkbook. However, I don't want to have to enter information in both. Early next week, I have to produce a report that shows what percentage of our available budget we are spending on a vendor. This report will be used as a visual to ask for more money. Any suggestions on the best way to do that for a someone who is not familiar with VBS or SQL or any other real techno language?

Answer:Access 2010? Excel 2010? or both?

If all of the information is in Access already just create a report based on the vendors and money spent with each. You can easily do this if the data is set up correctly in the database.

3 more replies
Relevance 50.02%


I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns.

It's a cinch when drawing a table in MSWord (2003) so I cannot imagine why this should not be possible in Excel, but then I don't know everything

Thank you

Answer:Formatting Excel 2010, Excel 2003

If I understand your problem then it is quite simple. Assuming A1 has the "heading" then select thsi cell and all the other cells in row A which pertaim to the tanle and then "merge the cells" and centre the title. I forget how this is done in Excel 2003 but I do remember it being available on the screen on the Edit toolbar I think.


5 more replies
Relevance 50.02%

my new laptop windows 9 excel 2010 will not open excel 2007 files sent to me on email. It shows them as compressed files, and won't extract a viewable format. I do not have this problem with excel 97-03 files. What can I do from my end to enable being able to see an excel 2007?

Answer:Excel 2010 won't open excel 2007

Are these 2007 files coming from the same user or are you having problems with files sent from multiple users?Have you tried to open these files on another system - using the same email app?I see no reason that you should have to "configure" 2010 to open 2007 files so I'm looking for a problem related to the files and/or the source.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 50.02%

Hey all,

I'm having an issue with the Xerox Workcentre 7120 and Excel 2010. I simply cannot print Excel files whatsoever. It tells me that the document has been sent to the printer, yet two minutes later it tells me that the print job has failed - no reason given, it just says in the Completed Jobs tab that it was cancelled. When looking at the Completed Jobs tab on the printer itself, it tells me that it was "Completed-Error" - basically meaning that nothing happened. I'm running Windows 7 64-bit.

I've tried many fixes, including restarting the PC, restarting the printer, restarting the print spooler, reinstalling Office 2010 completely, installing another driver for the printer, running a repair on Microsoft Office 2010, reinstalling the printer completely (it's a network printer) and dancing around the PC in complete frustration whilst chanting (the last one helps a lot, strangely enough).

The weirdest thing is that it's just an issue with Excel - Word, Office and other Office programs print fine with this specific printer. Does anyone have any suggestions? I've tried printing to another printer in another part of the office, and that works perfectly fine. It's just a hassle having to go through multiple doors and parts of the office to retrieve a simple document.

More replies
Relevance 50.02%


The "XP Antispyware 2010" virus infected my computer. Details for this virus can be found at the following web site.

I was able to successfully get rid of this virus by running a scan with Ad-Aware and then with Malwarebytes' Anti-Malware.

Unfortunately, either the virus or one of the virus-removal programs left behind some damage. When I attempt to view my Windows Firewall, I get a pop-up message that says "C:\Windows\System32\rundll32.exe - Application not found.". I get this same error message when I launch HijackThis.exe. I renamed HijackThis.exe to, and I was able to get it to launch.

I looked in the C:\Windows\System32 folder, and there is a file called rundll32.exe in this directory.

So I ran HijackThis and clicked on the "Do a system scan only" button. I included the log file below. However, when I clicked on the "Generate StartupList log" button and clicked "OK" in the warning box, I never received a log file. I waited 20 minutes, but nothing happened. I tried several more times and never got a log file.

I cannot launch some .exe files, such as McAfee.exe. However, Notepad.exe launches just fine.

I would appreciate your advice on how I might be able to fix my computer. Thanks!
Logfile of Trend Micro HijackThis v2.0.4
Scan saved at 12:38:51 PM, on 11/26/2010
Platform: Windows XP SP3 (WinNT 5.... Read more

Answer:C:\Windows\System32\rundll32.exe - Application not found - side-effect of "XP Antispyware 2010" Virus

Hello and welcome to Bleeping Computer We apologize for the delay in responding to your request for help. Here at Bleeping Computer we get overwhelmed at times, and we are trying our best to keep up. Please note that your topic was not intentionally overlooked. Our mission is to help everyone in need, but sometimes it takes just a little longer to get to every request for help. No one is ignored here.If you have since resolved the original problem you were having, we would appreciate you letting us know. If not please perform the following steps below so we can have a look at the current condition of your machine. If you have not done so, include a clear description of the problems you're having, along with any steps you may have performed so far.Upon completing the steps below another staff member will review your topic an do their best to resolve your issues.If you have already posted a DDS log, please do so again, as your situation may have changed.Use the 'Add Reply' and add the new log to this thread.Thanks and again sorry for the delay.We need to see some information about what is happening in your machine. Please perform the following scan:Download DDS by sUBs from one of the following links. Save it to your desktop.DDS.scrDDS.pifDouble click on the DDS icon, allow it to run.A small box will open, with an explaination about the tool. No input is needed, the scan is running.Notepad will open with the results.Follow the instructions that pop up for post... Read more

2 more replies
Relevance 49.61%

For whatever reason, my signal strength seems to consistently drop, but only when I'm in my basement. I have perfect signal strength when I'm upstairs. Strangely enough there never used to be a problem and it just started out of nowhere. I want my internet speed back, it's frustrating, can someone please help me!?

I have a Dell Inspiron 7377.

Answer:Signal Strength Drops Constantly From 5 Bars to 2 Bars

It depends on where the Wireless Access Point is located, and how many other A/P's are on the same channel(s) as the Access Point. Also if the power is dialed down on the Wifi, that can also cause issues.

4 more replies
Relevance 49.61%

I was working tonight, and suddenly, while using powerpoint, after switching from google chrome the title bar and the tool bar all became very big. It also affected every desktop application I have. Please, please help me fix this.
This is how my powerpoint looks like right now.
here is my outlook.
I would really appreciate the help!

Answer:Can I get some help with my Windows 8.1 interface (All the title bars and tool bars became too big!)?

You need to change screen resolution I think same things happened to me a few times

4 more replies
Relevance 49.2%

Hi i am Jo

would need help in finding the length of the third side of a triangle in excel

I have three points number: AB- 235 BC- 156 need to find length AC - it's not a right angle triangle,

Answer:Find length of side of triangle in Excel

Welcome to the forums Jo.

Having the length of two sides of a triangle isn't enough to calculate the length of the 3rd side, for a non right-angle triangle. You'll also need to know one of the angles.

3 more replies
Relevance 48.38%

I have been using Excel (now 2007) to keep records of items that we give free after a certain amount of purchases are made. Each year I simply carry over to the new year and delete all those who received the free item so that I start with a clean slate.

I did this yesterday and now noticed that the numbering on the far left column skips the number I deleted and although there are perhaps 30 names there - the numbers are showing up to 237.

How do I change the numbers so that they run consecutively from 1 to layman terms please!


Answer:Excel 2007 Change Left Side Numbering - HELP!!

16 more replies
Relevance 47.97%

Hey all,

I have come to you in a fit of desperation. My USB drive was stolen recently and my master Excel data file was lost, which contained all my compiled data from my most recent lab experiment.

Anyway, I have charts of all the important stuff in a word document. The data is there, I can hover on each data point and see the values, and the axes and chart are all accessible for editing.

My question is, how the heck do I extract that data back out of the chart into a table or Excel spreadsheet? There MUST be a way that is better than copying down each data point one at a time

Your help is greatly appreciated.

Answer:Excel chart in Word 2010: extract chart values? Lost Excel data file!!!! Help.

Hi welcome to the fourm.
I don't know it reverse engineering is possible.
Something like convert chart to table?

One thing you could try is copy the chart back to a new Excel file and see if more is possible there than in Word?

Like I said never needed this. Have you googled for something like Excel data reverse enginieering?
Maybe something come up.

1 more replies
Relevance 47.97%

I have over 20 years professional experience of Excel.
Until now I have been able to use my old Excel toolbar/macros in 2010 by putting the .xlb files into the XLSTART folder when they have appeared on an "Add-Ins" toolbar.
I have just done a new install of Office 2010 Professional and this has not happened. The files still work on 2 other machines in Excel 2010. Personal.xls loads ok too.

Any ideas ? Can I convert the toolbars to addins ?
Thanks for any input.

More replies
Relevance 47.97%

Need help with the below excel formula to ensure the maximum value doesnt exceed 1200 - Can anyone help?=IF(AB14>59,Z14+1,ROUND(Z14+AB14/100+0.0005,2))[email protected] by moderator: email address deleted

Answer:Excel Formula Help Excel 2010

Ok, so did my suggested formula wok for you or not?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

6 more replies
Relevance 47.15%

It seems that there may be a problem in Office 2010. I just installed it to the standard MS default/recommended settings .........all looked good...used Word great..until I use Excel and each time I try to use excel it sets off an 'Office Configuration' screen which I can not take a few minutes and then loads OK. I tried to launch it from the installed prgrams icon but there is no files on 'start in' etc..I tied to create a shortcut to the desktop from the excel.exe file and get the same reconfigure seem that somehow I don't have either permissions or I have a corrupt install..all Office suite works eventually Anyone know how to fix it..please?

Answer:Office 2010 Pro Plus Win7 x 64 Excel reconfigures Office 2010

Have you ever had a previous version of Office on this copy of win7?

Do you have any component of a previous office suite installed still

I have seen this in the past with Viso that was due to remnents of an earlier trial remaining on disk and in the registry.

I also found that if I cancelled the configuration screen the Viso would load without problems without the need to wait for completion.

There are some rather involved solution stems on Microsoft website - cannot find them at the present but will try to look for them.

The problem was that I could never get the removal steps to actually cure the issue and I put up with the error until my next re-install of Win7, which was not to long in the case of that system

6 more replies
Relevance 47.15%

I seem to have too many bars on top of my screen. 3 of them. I don't think i need them all. How do I delete one or two ?

Answer:address bars/tool bars

Normally if you right clik any tool/menu bar the options will be listed...Also off the menu bar it will be listed under View.

1 more replies
Relevance 47.15%
Answer:Why has my volume dropped from 30 bars to just 10 bars?

Are you using headphones? It could be for hearing protection purposes in that case.

3 more replies
Relevance 45.51%
Question: Excel 2010 help

I have a document in Excel 2010 which contains 2 columns. Data from 2nd column is constant, does not change and is assigned to data in 1st column. Names and surnames are great example, so I will use this case for explanation.

Currently there are 200 unique names in 1st column and of course 200 surnames, attached to them in every row. There won't be any new names ever.

This is functionality I'd like to have. I often have to copy some of those names from external database (software) in various numbers. Let's say 50 random names to 1st column. But when I do that, I have to manually write down surnames to 2nd column, because they come from another database (software) which is not synchronized with the first one, so I cant just copy/paste them.

Is there any way to save (connect?) all 200 surnames to all 200 names in Excel, so when I would copy some of names from external database to 1st column, Excel would automatically attach appropriate surname to 2nd row?

I hope I was clear. Thanks for help in advance!

Answer:Excel 2010 help


Seven Forums is an excellent place to get answers. But sometimes, you might find that there is a more focused, dedicated forum for a specific topic, such as in this case.

One of the best excel resources with a bunch of extremely helpful people is at | Excel Resources | Excel Seminars | Excel Products.

Jump on the forums there. I'm sure you will have your answer very quickly.

good luck

2 more replies
Relevance 45.51%
Question: Excel 2010

When trying to open Excel 2010 file "Excel cannot complete this task with available resources. Choose less data or close other applications."
Anyone else having this issue?

More replies
Relevance 45.51%
Question: MS Excel 2010

Hi Guys,

I have an issue with my Excel application. Every time I open Excel and click on File from the menu bar the application keeps freezing. I can click on the other menu bars but not FILE.

I have tried safe mode, re-installing the the whole MS Suite, and repairing and nothing worked.

Does anybody have some tips for me.

Thank you,

Answer:MS Excel 2010

I found this article that may help you:

Failing that you could contact Microsoft themselves if you believe it is a problem with their software:!campaign=officeUniversity

The last idea I have is to make sure your Anti-virus and Malware software are up-to-date and working, in case that it causes a problem. Although that might be more than just the one program.

Hope this helps

1 more replies
Relevance 45.51%
Question: Excel 2010 help

I have created a worksheet which I need to expand to fit an A4 page for printing. How do I go about it please?

Answer:Excel 2010 help

Select File > Print >Settings, Choose A4 Paper and change Scaling to fit to one page.

1 more replies
Relevance 45.51%
Question: excel 2010

If cell A1 is a empty cell and in cell A2 I have =if(A1>=0, 5%, ""), how can i have the forumla return nothing rather that 5%.  Excel treats the empty cell as a 0 which I dont want it to, just as a empty cell

Answer:excel 2010

Have you tried formating cell A1 to be "text" instead of default in which it expects a number. Not sure of this will fix it as for I cant test this on this computer I am at.

2 more replies
Relevance 45.51%
Question: MSO 2010 - Excel

When trying to print a selected area, the "rows to repeat at top" are greyed out (as are the other two adjacent options.
Have read the "cures" for Excel 2003 and 2008, (leave print preview and use file/print/page setup) but these do not work for my 2010 version.
Can anyone help please?

Answer:MSO 2010 - Excel

I've heard of this error before, it seems to be a bug in Excel. Did you get to the page set-up through the print options? If so, try the button on the ribbon instead - select the Page Layout tab, the click on the Print Titles button in the Page Layout group. Hopefully it should allow you to select the option you're after.

Let me know how you get on

6 more replies
Relevance 45.51%

Item No. Item Description Units Approx Quantities LOW BIDDER PRICE HIGH BIDDER PRICE
im trying to do a little statistical analysis for some bids that we will be receiving for a job. i have a function that will look through all of the sheets and find the lowest number for that item [PRICE]. i would like to have returned next to it the name of the contractor for that particular item [LOW BIDDER] and [HIGH BIDDER] the contractor is just a title cell on each sheet.

How do i do this?


Answer:EXCEL 2010 how to do something

It is a little tough without seeing the spreadsheet.

If it is not private, I would love to have a look at it for you.

PM sent.

9 more replies
Relevance 45.51%
Question: EXCEL 2010 HELP

Hi, my boss clicked on install upgrade to change to windows 10 everything is pretty much ok apart from all my excel spreadsheets. There are cells on each spreadsheet that wont print out the text in them. Only a few random ones here and there. In print preview they show the text there but when printing it doesnt show up. Anyone have any suggestions please

Answer:EXCEL 2010 HELP

That's weird! Have you tried resetting the print area?

3 more replies
Relevance 45.51%
Question: Excel 2010

Hi all
I'm trying to add a little Calculator function to a Spreadsheet I use for trading shares.

I pull basic data from YAHOO finance and would like to have at the bottom of a spreadsheet a calculator which would allow me to enter Nr of shares bought, Price Paid and return things like Profit / Loss.

The advantage of having it on the spreadsheet is then it's all in the same place.

The spreadsheet looks something like this -- enclosed pic

I'd like to embed the calculator in column M say starting at Row 15-- I'm not sure whether this should be done with a FORM or embed another spreadsheet.

Any ideas / links --- all the googling I've done either quote examples that are so impossibly complicated or hard or just too basic.



Answer:Excel 2010

It is possible that there already exists a function formula for the purpose:
Excel functions (by category) - Excel - Microsoft Office

e.g. PV - Returns the present value of an investment
I just came across this, which might also be useful:
Excel VLookup Function and VLookup Example

9 more replies
Relevance 45.51%
Question: Excel 2010

 I am learning Excel 2010 and My Instructor wants me to attach the Function Formulas to my assignment.  How is the best way to do this?  When I am in a worksheet that contains Data, I click the Formulas Tab, then click "Show Formulas" and they display, then I save  the worksheet.  When I reopen the worksheet, the Data is displayed and not the Formulas.  What am I missing?Thank You and I am looking forward to help.  StevenRunning Windows 7, Ult 32 Bit.

Answer:Excel 2010

I was unable to duplicate this with Excel 2010. I opened a worksheet, "Show Formulas" like you said, and then saved and closed it. When I opened it back up again, it was still showing the formulas.Is there any reason that the file is or could be unsaveable or read-only? Can you make other changes than showing formulas that are saved?

2 more replies
Relevance 45.51%

Need some help in excel please
Got this project where i need to make a table in excel with info innit and such but the words are too big so it looks bad as pic related
How do i make it bigger?

Answer:Need help in excel 2010

Hi, welcome to the forum.
You can cahange the columns width, you kan change the font sieze.
Could you be more specific?

You can select the 4 columns and then double click in the border between A and B to autofit.
Because you are using the autofilter you van also increase the column width a little, but with your info it's unclear what you really want / need

SVP duidelijk uitleggen

1 more replies
Relevance 45.51%
Question: Excel 2010

I am new to Excel 2010 but I am learning quickly. I love working with Excel and once I know what to do and where to go, I'm all set.

At this moment, I was asked to create a yearly spreadsheet (one month per tab) for sales reps and what they do in terms of correspondence.

In the old version we had here (Excel 2003), I tried doing the same and it didn't work, either.

What I'm trying to do is whatever information is created in January (names of clients and sales for that month) be transferred to February BUT allowing to make changes in February for the month following. So, if in January I had company ABC, BCA, CAB and in February I added CCB, I'd like it to show up in March. I used the "=" sign and it works from January to February but not from February to March....maybe it's because its already a formula? I'd like some help in this please.

Another explanation: In February, one company was removed, I'd like it to not show up in March. And then any changes from March onto April. Basically, each month, the reps will be able to add or remove clients but data stays for stat purposes.

Can this be done with perhaps an "IF" formula????

Answer:Excel 2010

There is nothing new in Excel 2010 that would allow this to work that I know of. There may, however, be a way to do it. I'll think about it and see if I come up with anything. Maybe someone else will have another idea before I respond again.

5 more replies
Relevance 45.51%
Question: Bug in Excel 2010?

For my workbook, I have defined the default font to be 11 pt Calibri. However, when I select a row (or column) and select Clear Formats, the cells are reformatted to 10 pt Arial. To me, this seems like a bug. Am I missing something?

Answer:Bug in Excel 2010?

How have you set the default font. You can set the Default Font by opening Excel, select file & then Options & under General there is a Sub Heading "When Creating new Workbooks" & there you will see "Use this as the default font". Then you can use the drop down list to select the font & size. If you change this it will only operate on any new workbooks that you create. Any previous ones will remain in the font that was originally used.
I use Excel 2013 so this info comes from that, but I think Excel 2010 is the same or very similar.

8 more replies
Relevance 45.51%
Question: Excel 2010

Hello. I am having an issue with formulas. Whenever someone emails me a spreadsheet or if I open a previously done spreadsheet that I have not opened before, there are formula errors thru-out. Some are just simple addition. What is the cause of this and how can I fix it? Also, my co-worker and I have the same Excel versions and it still comes up. Thanks!

Answer:Excel 2010

need to know what the errors are

1 more replies
Relevance 45.51%
Question: Excel 2010

When I click on my Excel 2010 shortcut instead of Excel opening I get a Windows message asking if I want to allowthe Programme to make changes to my computer. If I click 'yes', Excel opens but with a blank blue screen in the working area instead of the normal grid. Likewise if I click on an Excel attachment in an email the same thing happens. To open an Excel document I have to go to the main Microsoft Office section in Programmes and click on Excel. This has only happened recently. Any ideas on the cause of the problem and on a solution?

Many thanks.

Answer:Excel 2010

Try System Restore - choose a restore date which precedes the date when the problem was first noticed.
Start >> All Programs >> Accessories >> System Tools >> System Restore

1 more replies