Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-04-2010, 03:52 AM
Equilar Equilar is offline Cells from other worksheets apear on current worksheet Windows Vista Cells from other worksheets apear on current worksheet Office 2007
Novice
Cells from other worksheets apear on current worksheet
 
Join Date: Feb 2010
Posts: 2
Equilar is on a distinguished road
Default Cells from other worksheets apear on current worksheet

I have a user who works on big excel files.


When he is working one worksheet, occationally it will show up cells from other worksheets in the file.


Highlighting the area or moving to another worksheet then back removes the problem.

There is plenty of free space on his HDD, 1GB of RAM and upto 2GB virtual memory. Graphics card work fine on other, more intensive, applications.

Any ideas?
Reply With Quote
  #2  
Old 05-01-2010, 09:42 AM
Kristiina's Avatar
Kristiina Kristiina is offline Cells from other worksheets apear on current worksheet Windows Vista Cells from other worksheets apear on current worksheet Office 2007
Advanced Beginner
 
Join Date: Apr 2010
Posts: 58
Kristiina is on a distinguished road
Default

Hi,


first of all, that's not really much (resource I mean). Please also note that extensive Excel spreadsheets, which I presume are all linked to each-other (meaning they use data) and contain complicated formulas and conditions, make Excel in it's essence slower. It's may not be that your computer is slow, but the program cannot handle the data any faster. Analyizing and calculating is a lot of work

Hope to have helped.


Rgrds,
Kristiina
Reply With Quote
  #3  
Old 05-01-2010, 02:15 PM
zyzzyva57 zyzzyva57 is offline Cells from other worksheets apear on current worksheet Windows 7 Cells from other worksheets apear on current worksheet Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

I would work from this ss being in Compatibility Mode (as seen at the top of the file) which probably means this is saved as a 2003 Excel SS

I would try Save As the file in a 2007 file format and see if another copy with 2007 format helps


click for more infor
Reply With Quote
  #4  
Old 05-03-2010, 01:40 AM
Equilar Equilar is offline Cells from other worksheets apear on current worksheet Windows Vista Cells from other worksheets apear on current worksheet Office 2007
Novice
Cells from other worksheets apear on current worksheet
 
Join Date: Feb 2010
Posts: 2
Equilar is on a distinguished road
Default

The user remade this spreadsheet in 2007 and it seems ok now. Thanks
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Headers in Same Worksheet Tom Excel 3 05-18-2011 03:22 PM
Cells from other worksheets apear on current worksheet Auto insert current month's name and current year Styler001 Word 4 01-25-2010 06:40 PM
Cells from other worksheets apear on current worksheet Worksheet copying? markg2 Excel 4 01-07-2010 10:08 AM
Help with worksheets on Word eballi Word 4 11-18-2009 05:17 AM
Office hyperlink that closes current program solarscott Office 0 08-10-2009 11:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft