Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Missing info in Formula Tab

When using Excel 2007, I can open every tab in the workbook....except the
"Formula Tab". When I click on the tab, the program locks up! When I go to
the task manager window it says "not responding"...what in the world in going
on? HELP, HELP!!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Missing info in Formula Tab

Hi

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"SOS Excel 2007" <SOS Excel wrote in message
...
When using Excel 2007, I can open every tab in the workbook....except the
"Formula Tab". When I click on the tab, the program locks up! When I go to
the task manager window it says "not responding"...what in the world in going
on? HELP, HELP!!


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Missing info in Formula Tab

Ron-

Thanks...but no problems and the issue still exists.

I appreciate the response. Anyone else have any ideas?

"Ron de Bruin" wrote:

Hi

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"SOS Excel 2007" <SOS Excel wrote in message
...
When using Excel 2007, I can open every tab in the workbook....except the
"Formula Tab". When I click on the tab, the program locks up! When I go to
the task manager window it says "not responding"...what in the world in going
on? HELP, HELP!!



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Missing info in Formula Tab


If you start Excel in Safe mode is it working OK for you then ?

Close Excel first
Hold the Ctrl key when you open Excel
Say Yes in the dialog
Now open a workbook


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"SOS Excel 2007" wrote in message
...
Ron-

Thanks...but no problems and the issue still exists.

I appreciate the response. Anyone else have any ideas?

"Ron de Bruin" wrote:

Hi

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"SOS Excel 2007" <SOS Excel wrote in message
...
When using Excel 2007, I can open every tab in the workbook....except the
"Formula Tab". When I click on the tab, the program locks up! When I go to
the task manager window it says "not responding"...what in the world in going
on? HELP, HELP!!




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Missing info in Formula Tab

Ron...that did it my friend!! Thanks. What now? Will I always need to open
in "safe mode"?

"Ron de Bruin" wrote:


If you start Excel in Safe mode is it working OK for you then ?

Close Excel first
Hold the Ctrl key when you open Excel
Say Yes in the dialog
Now open a workbook


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"SOS Excel 2007" wrote in message
...
Ron-

Thanks...but no problems and the issue still exists.

I appreciate the response. Anyone else have any ideas?

"Ron de Bruin" wrote:

Hi

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"SOS Excel 2007" <SOS Excel wrote in message
...
When using Excel 2007, I can open every tab in the workbook....except the
"Formula Tab". When I click on the tab, the program locks up! When I go to
the task manager window it says "not responding"...what in the world in going
on? HELP, HELP!!






  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Missing info in Formula Tab

I'm not Ron, but I'd look to see if there was a macro that was misbehaving.

Start Excel in Safe mode.
Rightclick on the worksheet tab with the trouble.
Select view code.

If you see code in there that you don't understand, you can go back to the
developer and tell him/her what's happening.

This kind of event code can also be found in the ThisWorkbook module, too. If
there is no code under the Formula worksheet, you may have to continue the
search.



SOS Excel 2007 wrote:

Ron...that did it my friend!! Thanks. What now? Will I always need to open
in "safe mode"?

"Ron de Bruin" wrote:


If you start Excel in Safe mode is it working OK for you then ?

Close Excel first
Hold the Ctrl key when you open Excel
Say Yes in the dialog
Now open a workbook


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"SOS Excel 2007" wrote in message
...
Ron-

Thanks...but no problems and the issue still exists.

I appreciate the response. Anyone else have any ideas?

"Ron de Bruin" wrote:

Hi

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"SOS Excel 2007" <SOS Excel wrote in message
...
When using Excel 2007, I can open every tab in the workbook....except the
"Formula Tab". When I click on the tab, the program locks up! When I go to
the task manager window it says "not responding"...what in the world in going
on? HELP, HELP!!





--

Dave Peterson
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Missing info in Formula Tab

If you have the problem in every workbook
It is also possible that there is a bad add-in that cause this problem.

Open Excel and press
Alt ti
Uncheck all add-ins
Close Excel

Open Excel normal and see if you have the same problem
If it is OK add all your add-ins one at the time and see which one is the problem.

It is also possible that there is a file in your XLStart folder that is the problem.
But try the add-ins first


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message ...
I'm not Ron, but I'd look to see if there was a macro that was misbehaving.

Start Excel in Safe mode.
Rightclick on the worksheet tab with the trouble.
Select view code.

If you see code in there that you don't understand, you can go back to the
developer and tell him/her what's happening.

This kind of event code can also be found in the ThisWorkbook module, too. If
there is no code under the Formula worksheet, you may have to continue the
search.



SOS Excel 2007 wrote:

Ron...that did it my friend!! Thanks. What now? Will I always need to open
in "safe mode"?

"Ron de Bruin" wrote:


If you start Excel in Safe mode is it working OK for you then ?

Close Excel first
Hold the Ctrl key when you open Excel
Say Yes in the dialog
Now open a workbook


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"SOS Excel 2007" wrote in message
...
Ron-

Thanks...but no problems and the issue still exists.

I appreciate the response. Anyone else have any ideas?

"Ron de Bruin" wrote:

Hi

Try this first

Run Office Diagnostics.
Office ButtonExcel Options...Resources


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"SOS Excel 2007" <SOS Excel wrote in message
...
When using Excel 2007, I can open every tab in the workbook....except the
"Formula Tab". When I click on the tab, the program locks up! When I go to
the task manager window it says "not responding"...what in the world in going
on? HELP, HELP!!





--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
zero value from using 3D formula, value is missing chedd via OfficeKB.com Excel Worksheet Functions 4 June 18th 07 05:39 PM
formula missing something mmock Excel Discussion (Misc queries) 4 March 29th 06 01:30 AM
Legend Missing Info Debra Ann Charts and Charting in Excel 0 October 11th 05 03:23 PM
missing formula bar Ron New Users to Excel 2 September 28th 05 05:09 PM
Formula is missing Shakeel Excel Worksheet Functions 1 July 11th 05 12:20 PM


All times are GMT +1. The time now is 04:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"