hi,
i have a big problem with my excel 2007.
when i open excel, the formula bar is displayed on the entire page. i cannot do anything with it. when i move the cursor on the top of the formula bar, i see a pop-up "expand formula bar (ctrl+shift+U)" if i close the formula bar i can see only very tiny cells and can't see my data. I don't understand where exactly the problem is. please help me. please let me know if i need to provide additional specific details of the problem.
thanks
m
Move the mouse to the Upper - Right corner, where you see a double up arrow, you could see "Collapse the Formula Bar" then click the double up arrow.
Or you could move the mouse on the lower side of the Formula Bar, when it chage to be a two dimensions arrow, then drag it up.
See the picture: http://i248.photobucket.com/albums/g...FormulaBar.jpg
Oldman Chatting: thanhmy_pham@yahoo.com Mailing: thanhmypham@gmail.com
thanks for your response. unfortunately i cannot see the double arrow. i cannot even see fx in front of the formula bar.
Last edited by shg; 07-18-2010 at 02:01 PM. Reason: delete quote
if this is difficult to be solved, then please let me know how i can erase the settings completely and reinstall the software. i did reinstallation three times after complete removal and inspite of that i am getting same problem
thanks
Looking at your screenshot, I see "fx" perfectly fine in the upper left corner. (Just left of the white space of the function bar where you can enter/edit formulas.)
How about showing us a screenshot of your entire page, not just the upper right corner of your screen?
What view are you using? Normal? Page Layout? Page Break Preview?
What is the zoom level?
If this does not affect all workbooks, upload the workbook in question to this site.
hi,
thanks. the image that you have seen is not from me. anyway here is the image that i am having. it is happeneing for all the workbooks.
http://picasaweb.google.com/muralidh...32907632296178
thanks again
m
Do you have a template workbook in either of your XLSTART folders?
If you hold down the Ctrl key while opening Excel normally and choose Yes to open in Safe Mode, does it fix the display?
Everyone who confuses correlation and causation ends up dead.
@ptm and mettam,
please use the forum facilities to upload files. External untrusted sites may not be available to all users. If you want as much exposure to the helpers here, use the forum tools.
@ romperstomper
thanks for your reply. i donot have any template in my XLSTART folder.
also starting excel in safe mode is not solving my issue.
i reinstalled the office for three times. still i ahev same problem.
@teylyn
can you please provide me a link where i can find tools to upload images. sorry for my ignorance.
thanks
Click "Go Advanced" below the Quick Reply box, then click the paper clip icon to attach a file.
What happens if you uncheck the Formula Bar option? (a picture would be useful here)
very tiny cells. difficult to do anything with this page. here is the picture.
What if you click the 100% Zoom button?
still it remains same.
In your picasa screenshot, the Table tools tab is visible. In your last screenshot it is not. Is there a table in your file?
What happens when you hold down the Ctrl key and use the mouse wheel to zoom in and zoom out. Does that work?
Last edited by teylyn; 07-21-2010 at 02:20 AM.
What is your default font size set under Excel Options?
the default font size is 11. even if i increase the font size, it is not making any difference. i guess there is some critical setting which is being modified which i donot understand.
thanks
Last edited by mettam; 07-21-2010 at 04:49 AM.
If you click the Zoom button and change to 200%, do the cells get bigger?
From the last screen-shot I'd go with romperstompers' earlier thoughts
Is it possible that the formula bar is switched off?
Office Button > Excel Options > Advanced
Scroll down to "Display"
Make sure the Show formula bar checkbox is checked
We turned it off earlier as a temporary solution to the fact that it was obscuring the entire workbook!
To fix that, from what I can see of the screenshot, would probably require a registry change - I'm not sure how confident the OP is with that?
it is not making any difference if there is a table or not. when i zoom it, the cell is increasing in width direction but not in length direction. if there is data, i can see the data only in page break view.
when i click continuously on these different view options, suddenly i get a error message " Not enough system resources to display completely"
thanks
Originally Posted by teylyn
i have mentioned in my previous post about the situation of zoom in.
i have no problem in changing registry if you have a suggestion. you seem to be an expert.
thanks
Sorry romperstomper,
I missed your post #11
The page was at post #15 when I posted #19
This is how long it took me to respond, I keep getting extremely slow reaction from the BB between
approx 09:30 and 10;30 (BST) often resulting in
No other sites are affected, and it does the same on several computers.Oops! This page appears broken. DNS Error - Server cannot be found.
It's becoming a real pain.
OK then, let's have a little look before we start changing anything.
First thing - open the registry editor (start-run, type Regedit and press enter)
Now navigate to:
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options
in the left hand pane, right-click the Options item and choose export, then select a location to export the file to.
Now locate the .reg file you just created, zip it and post it here so I can see what settings you have.
here it is.
OK, that seems to be fine (I deleted all my settings and replaced them with yours just to be sure).
Can you repeat the process but with:
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\Toolbars
please?
here it is.
Nope - those seem to be OK too.
Can you have a look in your:
C:\Documents and settings\username\Local Settings\Application data\temp\Office
folder (I'm assuming WinXP) do you have an Excel.qat file?
If so, can you move it somewhere else (with Excel closed) and then start Excel?
Also can you tell us what, if any files, you have in:
C:\Documents and Settings\username\Application Data\Microsoft\Excel
and
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART
Last edited by romperstomper; 07-21-2010 at 07:30 AM.
hi,
i am using windows vista. i could not locate the documents and settings folder in vista.
I tried to give search for the mentioned file name which did not return any result. I could find one XLSTART folder in the following location:
C:\Program Files (x86)\Microsoft Office\Office12
however, this folder is empty.
When searching you need to include hidden folders. For Vista I think the paths would be:
C:\users\username\AppData\Local\temp\Office
C:\users\username\AppData\Roaming\Microsoft\Excel
and
C:\users\username\AppData\Roaming\Microsoft\Excel\XLSTART
You may want to search for Excel.qat to locate the first folder.
I don't see Office folder in the 1st location.
I see a XLSTART folder in the second location and i see nothing in that folder.
while searching i have included hidden files and folders.
Did you search for Excel.qat?
Just to check, you mean that the Excel folder only contains the XLSTART folder and there are no files in either of those folders?
The correct location on Vista for the qat file is:
C:\Users\username\AppData\Local\Microsoft\Office
NBVC has very kindly reminded me of this MSKB article which contains some good troubleshooting steps and various automated FixIt tools. It may be time to give them a try!
i didn't find the Excel.qat file in any of these locations.
the Excel folder only contains XLSTART folder. nothing else. is it a problem? am I missing something?
I have tried to run the fixits sometime ago from the same location but there was problem in running them. when i try to run the fixit, it suddenly closes.
thanks for your time.
Let's try cleaning out the registry (Excel will recreate it). With Excel closed, open the registry editor again, locate:
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel
export it, then right-click and Delete it.
Now restart Excel and see if anything has changed.
sorry. this didnot help.
Do you have Office Service Pack 2 installed?
Also, how are you opening Excel? Is it the same if you do Start-Run and type excel.exe then press enter?
i am having service pack2.
it is same if i use start -> Run -> excel.exe or start-> all programs-> microsoft office-> Microsoft excel 2007
Can you run the Diagnostics from Excel Options (on the Resources section)?
did not return any errors
I confess I'm starting to run out of ideas now. What is the default font set in Excel Options?
never the less, i appreciate your efforts.
the default font is Calibri.
when i uninstall office, is there a way to uninstall completely with all the settings, so that if i reinstall office, it might give me with normal settings. perhaps, this could be last option.
thanks
Maybe contact Microsoft Support? Go to Office Button, Excel Options, Resources.....
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Can you try logging in as another user on that machine to see if the issue is user-specific?
thanks romperstomper. now the issue is fixed. when i opened the following website, there was a fixit and this fixit somehow fixed the problem. i don't know what exactly this did.
http://support.microsoft.com/kb/942382
thanks a lot
Great - glad you got it sorted out! Thanks for posting the solution link.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks