Home

Sharepoint Spreadsheets not syncing

%3CLINGO-SUB%20id%3D%22lingo-sub-1015534%22%20slang%3D%22en-US%22%3ESharepoint%20Spreadsheets%20not%20syncing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1015534%22%20slang%3D%22en-US%22%3E%3CP%3EI%20use%20a%20master%20spreadsheet%20for%20all%20pricing%20on%20parts.%20This%20includes%20list%20prices%2C%20multipliers%2C%20etc.%20They%20can%20change%20often%2C%20and%20so%20I%20tie%20all%20of%20my%20pricing%20spreadsheets%20for%20routine%20jobs%20to%20this%20master%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20we%20change%20out%20a%20quantity%20of%2024%20of%20the%20same%20part%20twice%20a%20year.%20In%20the%20columns%20for%20list%20price%20and%20multiplier%2C%20I%20set%20them%20to%20equal%20the%20values%20in%20the%20master%20spreadsheet.%20All%20of%20the%20spreadsheets%20are%20stored%20in%20the%20company%20SharePoint%2C%20which%20I%20have%20synced%20with%20my%20laptop%2C%20and%20am%20accessing%20via%20the%20desktop%20Excel%20application.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20set%20the%20formulas%2C%20they%20work%2C%20and%20the%20data%20updates.%20However%2C%20when%20I%20close%20out%20excel%20and%20open%20it%20back%20up%2C%20I%20get%20the%20following%20error%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22Sorry%2C%20we%20couldn't%20open%20%3CA%20href%3D%22https%3A%2F%2Fblejwas.sharepoint.com%2FUsers%2Ffarrelltamke%2FBlejwas%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblejwas.sharepoint.com%2FUsers%2Ffarrelltamke%2FBlejwas%3C%2FA%3E%20Associates%2C%20Inc%2FBlejwas%20-%20Blejwas%20Sharepoint%2FSales%20Assets%2FPricing%2FPricing%20Books%2F%5BMASTER%20PRICING.xlsx%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20exact%20file%20path%20to%20the%20aforementioned%20spreadsheet.%20IS%20what%20I'm%20intending%20to%20do%20just%20not%20possible%2C%20or%20is%20this%20an%20issue%20of%20granting%20permissions%20for%20the%20master%20pricing%20spreadsheet%3F%20Again%2C%20all%20of%20the%20individual%20job%20spreadsheets%20exist%20in%20the%20SharePoint%20as%20well%2C%20I%20just%20use%20the%20desktop%20application%20to%20make%20edits%20faster.%20Thank%20you%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1015534%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
farrelltamke
Occasional Visitor

I use a master spreadsheet for all pricing on parts. This includes list prices, multipliers, etc. They can change often, and so I tie all of my pricing spreadsheets for routine jobs to this master sheet.

 

For example, we change out a quantity of 24 of the same part twice a year. In the columns for list price and multiplier, I set them to equal the values in the master spreadsheet. All of the spreadsheets are stored in the company SharePoint, which I have synced with my laptop, and am accessing via the desktop Excel application.

 

When I set the formulas, they work, and the data updates. However, when I close out excel and open it back up, I get the following error:

 

"Sorry, we couldn't open https://blejwas.sharepoint.com/Users/farrelltamke/Blejwas Associates, Inc/Blejwas - Blejwas Sharepoint/Sales Assets/Pricing/Pricing Books/[MASTER PRICING.xlsx]

 

This is the exact file path to the aforementioned spreadsheet. IS what I'm intending to do just not possible, or is this an issue of granting permissions for the master pricing spreadsheet? Again, all of the individual job spreadsheets exist in the SharePoint as well, I just use the desktop application to make edits faster. Thank you in advance!

1 Reply

@farrelltamkeHave you tried clearing Office File Cache in %localappdata%\Microsoft\Office\16.0\OfficeFileCache ?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies