Go Back   Tech Support Forum > Microsoft Support > Microsoft Office support

Excel - Missing Columns

This is a discussion on Excel - Missing Columns within the Microsoft Office support forums, part of the Tech Support Forum category. I have a small problem of missing columns in my worksheet. It starts at column H, but the columns aren't


Closed Thread
 
Thread Tools Search this Thread
Old 06-17-2011, 08:53 AM   #1
Registered Member
 
Join Date: Jun 2011
Posts: 8
OS: XP



I have a small problem of missing columns in my worksheet. It starts at column H, but the columns aren't Hidden because I've tried to unhide them. I'm not sure how to get columns A through G back. Any ideas?

Using Excel 2003

__________________
LadyTB is offline  
Old 06-17-2011, 08:59 AM   #2
CEM
TSF Enthusiast
 
CEM's Avatar
 
Join Date: Jan 2011
Location: Florida / USA
Posts: 660
OS: win7 Professional x64


Send a message via MSN to CEM Send a message via Skype™ to CEM

Hi welcome to TSF ;

Can you try on menu Tools > options > view > Row & Column Headers

__________________
Trust God and walk in His WAY
CEM is offline  
Old 06-17-2011, 09:04 AM   #3
Registered Member
 
Join Date: Jun 2011
Posts: 8
OS: XP



All that does is take away the row that tells me with column it is. Doesn't change that columns A through G and all the data contained within them are missing.
__________________
LadyTB is offline  
Old 06-17-2011, 09:26 AM   #4
CEM
TSF Enthusiast
 
CEM's Avatar
 
Join Date: Jan 2011
Location: Florida / USA
Posts: 660
OS: win7 Professional x64


Send a message via MSN to CEM Send a message via Skype™ to CEM

If you haven't already, install the compatibility pack download and install from here: Microsoft Downloads

Might be help your issue
__________________
Trust God and walk in His WAY
CEM is offline  
Old 06-17-2011, 10:10 AM   #5
Registered Member
 
Join Date: Jun 2011
Posts: 8
OS: XP



This is a shared file throughout the office. Multiple people access it at any given time throughout the day. I can't change the format of it or they wont be able to work the file. This is a company computer and network. I can't download anything onto it without the company permissions. :(

I need to fix this within in the confines of the 2003 Excel program.
__________________
LadyTB is offline  
Old 06-17-2011, 10:22 AM   #6
CEM
TSF Enthusiast
 
CEM's Avatar
 
Join Date: Jan 2011
Location: Florida / USA
Posts: 660
OS: win7 Professional x64


Send a message via MSN to CEM Send a message via Skype™ to CEM

Update doesn't effect to file just upgrade for excel software

So you said shared document and multiple people using this file.Did you check with other user is files is showing normal or some user might be saved without notice.If other users has normal view on file.So have to check your user account. I will work around and collect more info for you .
__________________
Trust God and walk in His WAY
CEM is offline  
Old 06-17-2011, 10:30 AM   #7
Registered Member
 
Join Date: Jun 2011
Posts: 8
OS: XP



It was one of the other users that pointed out the problem to me this morning. I hadn't noticed it. When I was last in the file (last night) the worksheet was fine. Since no one can edit it while I have it active (which I have all day long), something happened after hours to modify the file after I'd left for the day and before I got in this morning.
__________________
LadyTB is offline  
Old 06-17-2011, 01:22 PM   #8
CEM
TSF Enthusiast
 
CEM's Avatar
 
Join Date: Jan 2011
Location: Florida / USA
Posts: 660
OS: win7 Professional x64


Send a message via MSN to CEM Send a message via Skype™ to CEM

My suggestion to you you better talk with IT dept. who's IT guy there.??? They must be fix this issue for you guys from server
__________________
Trust God and walk in His WAY
CEM is offline  
Old 06-17-2011, 01:38 PM   #9
Registered Member
 
Join Date: Jun 2011
Posts: 8
OS: XP



Thanks for the advice.
__________________
LadyTB is offline  
Old 06-17-2011, 01:59 PM   #10
CEM
TSF Enthusiast
 
CEM's Avatar
 
Join Date: Jan 2011
Location: Florida / USA
Posts: 660
OS: win7 Professional x64


Send a message via MSN to CEM Send a message via Skype™ to CEM

You are welcome.
__________________
Trust God and walk in His WAY
CEM is offline  
Old 06-18-2011, 11:12 AM   #11
TSF - Emeritus
 
Join Date: Jan 2010
Location: Louisiana
Posts: 1,224
OS: Windows 7, CentOS 5.7



Hey LadyTB,

Can you post a copy of the workbook? It will be easier for us to troubleshoot it. If needed, just change secure information to some nonsense.

Regards,

Robert D. Specian Jr.
__________________
RSpecianjr is offline  
Old 06-20-2011, 11:01 AM   #12
Registered Member
 
Join Date: Jun 2011
Posts: 8
OS: XP



Hello Robert,

Here's a copy of the Workbook mentioned.

This is also the same workbook I'm trying to have auto sort the "Last Name" and "Street" sheets.

I have the information copying over from "Job Number" through a formula, but do not have it sorting and don't know where columns A through G went on the "Last Name" sheet.

(Can't upload. the .xls is not supported by your forum....)
__________________
LadyTB is offline  
Old 06-21-2011, 12:26 AM   #13
TSF - Emeritus
 
Join Date: Jan 2010
Location: Louisiana
Posts: 1,224
OS: Windows 7, CentOS 5.7



Hey LadyTB,

You must first zip the file, then you can upload it.

Regards,

Robert

__________________
RSpecianjr is offline  
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
select max date and max value from multiple columns in excel 2003 or 2007
Hi, i have excel with next columns: value1,date1,value2,date2,value3,date3. I want to in one column which comes after above mentioned to have for example max date from columns date1,2,3.., also in next column to have max value from columns value1,2,3. Thanks
starback7574 Microsoft Office support 1 06-02-2011 09:29 AM
Inserting rows for Missing Date/ Time data (Excel 2007)
Hi everybody I have got an hourly meteorological data for 10 years. The problem is that some of the data entries are missing. e.g. 23-April-2006 19:00 23-April-2006 20:00 23-April-2006 22:00 23-April-2006 23:00 I need to insert the rows for missing hours. Rest of the columns in the...
mzalikhan Microsoft Office support 0 05-31-2011 08:57 PM
[SOLVED] BSOD problems.
· Vista · x64 · What was original installed OS on system? None. Custom built. · OEM: Full Retail Version · Age of system (hardware): 3 years · Age of OS installation - have you re-installed the OS? 3 years. Yes. · CPU: Intel Core 2 Duo E8400 Wolfdale · Video Card: EVGA GEforce 8800 GT...
ajcc323 BSOD, App Crashes And Hangs 25 02-24-2011 05:31 AM
error from upgradation to oel 6 from oel5_6
--> Missing Dependency: libiso9660.so.5()(64bit) is needed by package xine-lib-1.1.19-2.el5.rf.x86_64 (installed) java-1.4.2-gcj-compat-devel-1.4.2.0-40jpp.115.i386 from installed has depsolving problems --> Missing Dependency: python(abi) = 2.4 is needed by package...
csayantan Linux Support 1 02-20-2011 10:04 PM
Bandwidth Virus
Hi, I recently received my Internet usage bill. On February 1st someone exceeded my limit in one day using over 200 Gbs. I did a virus scan using Hijack, Can anyone tell me if I have a Bandwidth using virus? C:\Program Files (x86)\iTunes\iTunesHelper.exe C:\Program Files (x86)\Common...
Ciden Virus/Trojan/Spyware Help 1 02-07-2011 09:10 PM

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Post a Question


» Site Navigation
 > FAQ
  > 10.0.0.2


All times are GMT -7. The time now is 09:31 AM.


Copyright 2001 - 2014, Tech Support Forum

Windows 7 - Windows XP - Windows Vista - Trojan Removal - Spyware Removal - Virus Removal - Networking - Security - Top Web Hosts