Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
rumbha
 
Posts: n/a
Default Excel does not display changes made to doc on another workstation

Hi,

Ok, I have 2 users both running Excel 200 SP3 on XP Pro.

User A created a spread sheet and then emails it to user B.

User B edits the spreadsheet.She doesn't change the data itself, just
inserts page breaks and a header on each page.

User B mails the sheet back to user A.

Now when User A opens this document she gets a glimpse of the edited
document with the page breaks etc... after 1-2 seconds the excel sheet
reverts back to the original created by user A in the first place.
When we open the page break preview there are no page breaks.
On user Bs PC the document displays fine.

When User A mailed the doc to me the same thing happens on my machine.

So I took an edited copy from User B and placed it in a network share.
Now, when I copy the file to my desktop and open it , it's fine.
When user A does the same the page breaks disappear.

ANyone seen this before, I'm sure its got to be a minor setting on User As
Excel.
Or is it some wierd cache thing going on?

Please help,

Thanks in advance.....
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
the only idea i have is different printer settings?

--
Regards
Frank Kabel
Frankfurt, Germany

rumbha wrote:
Hi,

Ok, I have 2 users both running Excel 200 SP3 on XP Pro.

User A created a spread sheet and then emails it to user B.

User B edits the spreadsheet.She doesn't change the data itself, just
inserts page breaks and a header on each page.

User B mails the sheet back to user A.

Now when User A opens this document she gets a glimpse of the edited
document with the page breaks etc... after 1-2 seconds the excel sheet
reverts back to the original created by user A in the first place.
When we open the page break preview there are no page breaks.
On user Bs PC the document displays fine.

When User A mailed the doc to me the same thing happens on my machine.

So I took an edited copy from User B and placed it in a network share.
Now, when I copy the file to my desktop and open it , it's fine.
When user A does the same the page breaks disappear.

ANyone seen this before, I'm sure its got to be a minor setting on
User As Excel.
Or is it some wierd cache thing going on?

Please help,

Thanks in advance.....



  #3   Report Post  
rumbha
 
Posts: n/a
Default

Thanks for the reply, I checked the printer settigns and they all loked ok.

I then found a setting in:

Views\Custom Views.

It had a list aof all the people who had worked on the document. I set it to
the most recent user and it all lokks ok now.

Never seen this feature before.

Thanks anyhow.

"Frank Kabel" wrote:

Hi
the only idea i have is different printer settings?

--
Regards
Frank Kabel
Frankfurt, Germany

rumbha wrote:
Hi,

Ok, I have 2 users both running Excel 200 SP3 on XP Pro.

User A created a spread sheet and then emails it to user B.

User B edits the spreadsheet.She doesn't change the data itself, just
inserts page breaks and a header on each page.

User B mails the sheet back to user A.

Now when User A opens this document she gets a glimpse of the edited
document with the page breaks etc... after 1-2 seconds the excel sheet
reverts back to the original created by user A in the first place.
When we open the page break preview there are no page breaks.
On user Bs PC the document displays fine.

When User A mailed the doc to me the same thing happens on my machine.

So I took an edited copy from User B and placed it in a network share.
Now, when I copy the file to my desktop and open it , it's fine.
When user A does the same the page breaks disappear.

ANyone seen this before, I'm sure its got to be a minor setting on
User As Excel.
Or is it some wierd cache thing going on?

Please help,

Thanks in advance.....




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
display last entry in Excel ayedeeh Charts and Charting in Excel 3 January 15th 05 04:22 PM
How do I display a data table in an Excel 2002 chart? Dr. Mark F. Charts and Charting in Excel 3 December 29th 04 04:04 PM
Excel: To Display Formula in the cells Instead of Value [email protected] Excel Discussion (Misc queries) 1 December 10th 04 10:48 PM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 07:03 AM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 06:47 AM


All times are GMT +1. The time now is 02:37 AM.

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

About Us

"It's about Microsoft Excel"