• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 259
  • Last Modified:

Excel 2010 SP1 formatting

Excel 2010 SP1 on terminal server 2008 R2.  I'm not sure if it's a server issue or Excel, but I'm leaning towards the server.  
I've got a large spreadsheet with multiple tabs and each tab has a complex pivot table.  On one server only, when I open the spreadsheet, initially it's fine.  When it reads the data and updates the cells, the formatting for the column widths on 4-6 columns is blown out to 255 from around 20.  I'm stumped on this one.  Any ideas?
0
Scott Miller
Asked:
Scott Miller
  • 4
  • 2
1 Solution
 
NorieVBA ExpertCommented:
How is the data being read and the cells updated?
0
 
Scott MillerIT ManagerAuthor Commented:
When the spreadsheet is automatically updated upon opening.  I can turn that off, but it shouldn't do that.
0
 
NorieVBA ExpertCommented:
How is the update happening?

Is there code importing data?

Is a data/web query being refreshed?
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
Scott MillerIT ManagerAuthor Commented:
The update happens when the spreadsheet is opened.  It reads data (for about 6 tabs) from a 7th tab and updates accordingly.  It's all pivot tables, no data importing.
0
 
Scott MillerIT ManagerAuthor Commented:
This can be closed.  I didn't figure it out, but it seems no one knows what's up.
0
 
Scott MillerIT ManagerAuthor Commented:
I turned off the automatic update on opening.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now